Log in

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 [146] 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173

  1. User Input for Formula (6 replies)
  2. Solved: Relative Links (2 replies)
  3. First Step in VBA (2 replies)
  4. Solved: page breaks question (5 replies)
  5. Solved: Maxif UDF required (3 replies)
  6. Solved: Unique values from date range (12 replies)
  7. Solved: Search a spreadsheet (13 replies)
  8. Solved: Save As powerpoint that reference a cell in Excel (4 replies)
  9. Solved: Brainstorming - Querying data (6 replies)
  10. Controls on the fly (15 replies)
  11. Solved: Figuring out a DATE from a Number (2 replies)
  12. Solved: Add array items to multi column ListBox (7 replies)
  13. Online spreadsheet? (5 replies)
  14. calling subs from conditional statements (6 replies)
  15. Delete rows of other sheets also (3 replies)
  16. Solved: How to clean up data (12 replies)
  17. Solved: Can't get my XLA auto installer to work... (12 replies)
  18. Solved: IF/THEN Copy macro (13 replies)
  19. Stop userform from loading (2 replies)
  20. Tab key issues in form (inserts tab rather than moving to next control) (6 replies)
  21. Excel 2007/ Outlook 2007 Mail Problem (1 replies)
  22. Pivot Data Question (1 replies)
  23. Solved: File Import Browser Filter Failure (4 replies)
  24. Going over formula length limit (9 replies)
  25. Google Translation Issue (3 replies)
  26. Application Object Error- Range(Cells( (3 replies)
  27. Split date into part (5 replies)
  28. Compare 2 spreadsheets with conditions = Macro? (0 replies)
  29. Solved: Changing position of Chart XValues (4 replies)
  30. Range & Cells Property Prob (3 replies)
  31. Solved: Sorting Question (12 replies)
  32. NumberFormat of Now (5 replies)
  33. Help: how to insert pic, textbox to chart automatically??? (7 replies)
  34. how to put tabindex for rows of data Grid? (5 replies)
  35. Record data from a dynamically changing cell (11 replies)
  36. Bingo anyone? How to cross check a list of numbers & letters (3 replies)
  37. Solved: Efficient way to store/retrieve data of large UDT (4 replies)
  38. Automatically populate cell based on validation list (3 replies)
  39. Hexadecimal to ASCII UDF (3 replies)
  40. Solved: Import Macro help (37 replies)
  41. Solved: Sort of dynamic drop down list (3 replies)
  42. Solved: Auto Export cells to pop message and text file (8 replies)
  43. Show only Current Contracts (3 replies)
  44. Solved: Len function problem (25 replies)
  45. Solved: Clear all within range (2 replies)
  46. Sorting order please help! (3 replies)
  47. Solved: Date Saving Problem (1 replies)
  48. Solved: Getting rid of the glimpse of opening/closing file (9 replies)
  49. Solved: use a cell reference to name a save-as (5 replies)
  50. Solved: Search 2nd ListBox Column (10 replies)
  51. Array of objects (7 replies)
  52. Solved: Identify .csv attachment in LotusNotes Inbox (0 replies)
  53. Solved: Single Event Handler for Multiple Checkboxes (5 replies)
  54. Genetic Algorithm (1 replies)
  55. Solved: Replace error types with string (2 replies)
  56. Enabling Mouse Wheel for a Scroll Bar (1 replies)
  57. Execute Access Module within Excel (1 replies)
  58. Add-in sheet (13 replies)
  59. Solved: Update Links (1 replies)
  60. Unprotect Excel Worksheets (5 replies)
  61. Copy all sheets to new Workbook (4 replies)
  62. [SOLVED:] Assigning password to all files (2 replies)
  63. A few small problems... (1 replies)
  64. Pivot Field Have I Just Clicked On? (0 replies)
  65. Macro To Start An External Tool Process? (1 replies)
  66. Show All in PivotTable (1 replies)
  67. SUBSTITUTE FUNCTION (7 replies)
  68. Loop Problem (16 replies)
  69. Word doc in email body (1 replies)
  70. Add consecutive numbers (3 replies)
  71. Solved: Columns Alighnment (1 replies)
  72. Solved: Show Width Of Selected Columns... (2 replies)
  73. Dynamic Chart (6 replies)
  74. Solved: Copy Range Names (3 replies)
  75. Select network printer for printing Word doc (15 replies)
  76. How to copy sheet with dynamics chart? (4 replies)
  77. using variables in "Find Function" (3 replies)
  78. Solved: Copying a range from one sheet to a new sheet in the background (6 replies)
  79. Solved: Control the execution of macros (5 replies)
  80. Solved: Save Sheet to a user defined location (4 replies)
  81. Solved: Finding repeated values/cells (3 replies)
  82. Range behaviour after delete (3 replies)
  83. Search Listbox Problem (5 replies)
  84. Solved: pROBLEMS....! (6 replies)
  85. Solved: Template??? Conference Matrix (6 replies)
  86. Solved: Hide zero rows (10 replies)
  87. Solved: Edit in ListBox & changes made to RowSource (11 replies)
  88. Solved: ListBox Headers without .RowSource (2 replies)
  89. Solved: Protect sheet except for new inserted sheet (9 replies)
  90. Solved: Returning a Value from and "If Then Else" (12 replies)
  91. Solved: Help alter code to pickup extra info. (7 replies)
  92. Solved: Unable to Hide Columns ... Why?? (5 replies)
  93. Changing code in runtime - why doesnt work (2 replies)
  94. Solved: Excel 2003 Subscript issue (2 replies)
  95. Solved: Import File Using Browser (18 replies)
  96. Pasting Cells Into Word Chart (5 replies)
  97. Solved: Add cutom header to Top of printed worksheet (2 replies)
  98. Very large number: Mod operator (1 replies)
  99. Solved: Passing variable from access to excel (4 replies)
  100. Solved: Copy data from all the sheets in a workbook into a single sheet (11 replies)
  101. Bar chart (1 replies)
  102. Removing rows based on "0" Value but keeping Headers... (2 replies)
  103. Solved: Easy format Question (13 replies)
  104. Solved: Vlookup you helped me with yesterday not working again!!! (7 replies)
  105. Variables not stored globally? (6 replies)
  106. Solved: Email function on spreadsheet (4 replies)
  107. Can you use the min & average function with cells and not ranges? (8 replies)
  108. switching focus from userform to spreadsheet? (3 replies)
  109. How to update Office 2003 code to compatible with Offfice 2007 (0 replies)
  110. Solved: How to populate listbox (6 replies)
  111. Solved: User can extend 'RowSource' (2 replies)
  112. Solved: Assigning formula to a range of cells usign VBA (7 replies)
  113. file (xls, doc, pdf, jpeg etc) adding to mysql database ? (0 replies)
  114. Solved: Saving output as a text file with pre-fixed space between columns (2 replies)
  115. Inserting Rows during Worksheet_Change Event (2 replies)
  116. Run another Sub from within active Sub (6 replies)
  117. Solved: Range selection and other questions (18 replies)
  118. can't find project library (1 replies)
  119. Words in a String to Columns (3 replies)
  120. Vlookup from another Sheet in the same Workbook (11 replies)
  121. Copy without using the clipboard (4 replies)
  122. Solved: Saving output as a text file with pre-fixed space between columns (4 replies)
  123. Solved: Listbox With Checkboxes inside (24 replies)
  124. If...Then...Else - Help! (3 replies)
  125. array.copy (5 replies)
  126. Wrong number of arguments or invalid property assignment (8 replies)
  127. Basic Question? (3 replies)
  128. Rounding numbers with user defined increment (6 replies)
  129. Help with highlight macro (1 replies)
  130. Sub or Function not defined (2 replies)
  131. Open a simple email template out of excel (1 replies)
  132. Delete empty column in mutliple excel worksheets (1 replies)
  133. Need help with macro to only unhide 5 rows at a time based on cell value (4 replies)
  134. Date wise calculation (4 replies)
  135. Solved: Index match with command button (3 replies)
  136. Strange Behaviour from Excel (3 replies)
  137. Solved: Recieving a "FALSE" in If function. Need Help! (3 replies)
  138. Writing to the next empty cell (4 replies)
  139. Solved: Unique Lists (12 replies)
  140. fill list box with txt file (2 replies)
  141. Number ranges (3 replies)
  142. getting rid of all user form objects in a workbook (6 replies)
  143. Greyed Out Menu Items when Editing in Cell (4 replies)
  144. copying sheets without references to the original workbook (3 replies)
  145. Solved: How To Delete Column O/empty columns from all sheets in a work book? (5 replies)
  146. [SOLVED:] Function to add/write cells (6 replies)
  147. Exporting Drawing Objects from Excel (1 replies)
  148. Selecting from a column and more... (2 replies)
  149. Solved: nightmare fractions in formulas (3 replies)
  150. Solved: Printing multiple worksheets to a single pdf file (23 replies)
  151. Moving controls (6 replies)
  152. Export data from Excel to SQL (8 replies)
  153. Show the time and date of when the code is being executed (4 replies)
  154. Solved: Difference between 2 count last row/column command (3 replies)
  155. Solved: Timer for code execution (2 replies)
  156. Solved: Alert before delete a record (4 replies)
  157. Need to use VBA to send email using Lotus Notes From Inside Excel (2 replies)
  158. Change Row into a Column (3 replies)
  159. Solved: Remove Hyperlinks (7 replies)
  160. Solved: Userform events for dynamic controls (5 replies)
  161. Getting username for last update on closed xl wb (1 replies)
  162. [SOLVED:] Copy open event to active workbook (7 replies)
  163. Solved: Look up Values in Access (7 replies)
  164. Import data from Access to Excel (6 replies)
  165. Solved: VBA To insert File Path Footer at bottom of each sheet (4 replies)
  166. Solved: Dumping data from AD If statement issue (14 replies)
  167. Show Menu Bar (24 replies)
  168. Solved: VBA to set print area on several worksheets to 1 wide and N tall + Landscape (6 replies)
  169. Automatic Updating of Functions in Excel (2 replies)
  170. Solved: How Do I clear leading spaces from a column? (5 replies)
  171. Email from excel (10 replies)
  172. Solved: Is it possible to set a bit in a long integer ? (5 replies)
  173. Solved: Copy results to sheet2 (2 replies)
  174. Hide Rows if the Value is ZERO (1 replies)
  175. Can Excel Transparence UserForm Show Only Control in Form (2 replies)
  176. Insert Row when cell Value differs from above (4 replies)
  177. Explanation of Cell Comments? (1 replies)
  178. Solved: Creating a log file help required (0 replies)
  179. From KBase (17 replies)
  180. Solved: copy cells from many .xls files to master file (6 replies)
  181. Solved: Stubborn Styles (How To Remove Them?) (11 replies)
  182. Using Arrays to Populate Listbox (5 replies)
  183. Solved: Using an array as a parameter in an ADO query (6 replies)
  184. Seemingly impossible replacement task. (2 replies)
  185. Solved: How To Re-edit The Sheet Names In VBE Project Window? (2 replies)
  186. Solved: Redim Preserve (1 replies)
  187. Solved: Printing Zeros. 1.000 Zeros disappear, why? (2 replies)
  188. Solved: Last Date of Last Month (5 replies)
  189. Solved: Print macro (3 replies)
  190. how to write code for doing format cells/ patterns/ no vcolors? (1 replies)
  191. Solved: countif question (7 replies)
  192. Import with troubles - Date format (3 replies)
  193. Add " at the beginning and end of a string (7 replies)
  194. Solved: Hidding Data Hides Chart, Why? (4 replies)
  195. Creating a List in Memory (1 replies)
  196. Combine rows from multiple different worksheets / workbooks into a Master workbook (2 replies)
  197. I'm new to this and trying to fix an error (3 replies)
  198. Solved: how to find charecters in texts? (2 replies)
  199. Importing CSV Files Without Preserving External Links (4 replies)
  200. Solved: LastRow on every page (13 replies)
  201. Save as the active sheet into a new workbook (5 replies)
  202. Delete Rows Based on Partial Cell Value (5 replies)
  203. Solved: ?Cells? and ?Range? Properties (4 replies)
  204. How to make a range dynamic? (4 replies)
  205. Solved: Question on Option Buttons on Forms vs Control (2 replies)
  206. Convert Formula R1C1 to Range (20 replies)
  207. Solved: Array as a Public Const (5 replies)
  208. Uninstall ADD-INS (2 replies)
  209. Additional Control in Vista (6 replies)
  210. Generate Exe from Workbook (3 replies)
  211. Create/Clean-up of Objects (6 replies)
  212. Auto deletion of data when deleted from master file (9 replies)
  213. Solved: Looping required (8 replies)
  214. Solved: Choose sheet code (13 replies)
  215. Solved: Add text in title bar (4 replies)
  216. Solved: Combobox column width (2 replies)
  217. Ignore blank in Data Validation (3 replies)
  218. Solved: extracting info from cells (13 replies)
  219. Solved: Populate Specific Column Cell based on ListBox Selection (6 replies)
  220. Multiple Worksheet Entry (1 replies)
  221. save file as CSV (2 replies)
  222. Solved: VBA tutorial greenhorn (7 replies)
  223. Solved: File Exists Issue (2 replies)
  224. how to connect one excel file to another? (6 replies)
  225. Solved: Find Method not working properly (5 replies)
  226. Solved: Insert code to worksheet programmatically and run it in the same Sub - compiler error (12 replies)
  227. Sheet and cell validation (2 replies)
  228. workbooks.open question (5 replies)
  229. Solved: Need help with this macro (10 replies)
  230. Sort (3 replies)
  231. Solved: User Defined Function (5 replies)
  232. Selection not displaying in dropdown box (2 replies)
  233. [SOLVED:] How to Clear the ?Last Cell? (7 replies)
  234. Solved: How to Determine Which Fonts Are Being Used (Loaded) (5 replies)
  235. Error - manipulate dates in VBA (3 replies)
  236. Solved: graying out check boxes (10 replies)
  237. Mask the Salary (12 replies)
  238. Solved: Copying and Pasting from each Spreadsheet in a Folder (4 replies)
  239. Solved: Data Validation / Array (2 replies)
  240. Formula help (2 replies)
  241. ADODB.Connection Copy RecordSet to Array (8 replies)
  242. Solved: Force user to fill cell (11 replies)
  243. Items in Dropdown box of Internet Form (0 replies)
  244. Solved: how to diferentiate between text and value? (4 replies)
  245. concatenating strings & data from ranges without typing a formula (4 replies)
  246. Solved: Make cells inactive (9 replies)
  247. Solved: function to retrieve characters between to given values (7 replies)
  248. [SOLVED:] Delete empty rows (3 replies)
  249. Solved: Find empty cell (4 replies)
  250. Solved: Copy PDF into Excel and Keep PDF Structure (2 replies)