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. Solved: Move every Nth cell up without affecting the rest of the columns (12 replies)
  2. Change cell color after using copy command (1 replies)
  3. Solved: Reading a binary file into Excel with VBA code? (11 replies)
  4. Insert empty columns (3 replies)
  5. Solved: SUMPRODUCT HELP (3 replies)
  6. [SOLVED:] Initiate .xlsm file with task scheduler (24 replies)
  7. Trouble with Userforms (5 replies)
  8. Series of IF conditions (6 replies)
  9. Solved: It copy one row not all needed rows (5 replies)
  10. Compare Data in two excels (7 replies)
  11. Solved: Looping (23 replies)
  12. saving tab as file (3 replies)
  13. Vba To Fill Web Page Form (3 replies)
  14. [SOLVED:] Close Excel Window (7 replies)
  15. List of all Application. methods (4 replies)
  16. Solved: Environ("USERNAME") - Can't find Project or Library error (3 replies)
  17. Time Calculation (13 replies)
  18. Search Multi workbook with multi sheet and copy (2 replies)
  19. Populating an array with a userform (7 replies)
  20. Selection.OnAction = "macro1" (5 replies)
  21. Solved: Excel Macro Copy cells and pastes them in another sheet (3 replies)
  22. Solved: Naming a worksheet for all subs in project (4 replies)
  23. [SLEEPER:] Save as csv file format (36 replies)
  24. Leave only numbers in a column (10 replies)
  25. Functions Within Functions... (5 replies)
  26. Thank You All... (1 replies)
  27. Fill listbox then update same row (2 replies)
  28. How to change the code to search by row instead of by column? (1 replies)
  29. How to fill the number in the cells. (3 replies)
  30. VBA Security / Encrypt VBA Code (3 replies)
  31. Solved: SUM a range based on user selection (6 replies)
  32. Solved: Need a tutorial on Array Redim Preserve (7 replies)
  33. When there is an advanced filter, clear it. (6 replies)
  34. Solved: Understand and Modify Code (7 replies)
  35. unhide and activate worksheet based on entry in other cell (3 replies)
  36. Error handling (11 replies)
  37. Populating combo box using dynamic range - run time error 1004 (4 replies)
  38. Solved: duplicate record count and paste in new sheet (11 replies)
  39. Setup column to require unique entry (9 replies)
  40. Possible via vba to check the datetime stamps on files in a directory? (4 replies)
  41. Solved: Coloring alternate rows (9 replies)
  42. ActiveSheet.ShowAllData (2 replies)
  43. Command Bar Control Error (11 replies)
  44. Solved: Sumproduct Question (1 replies)
  45. Detect Excel Version of a closed file. (12 replies)
  46. Open Excel and do vlookup. (2 replies)
  47. Solved: Found data in another Column using Formula (6 replies)
  48. Solved: Sorting (2 replies)
  49. highlighting precedent cell (3 replies)
  50. Please kindly help! (2 replies)
  51. Solved: enable more options in userform with password (7 replies)
  52. Opening CSV-files as new sheets in current workbook (6 replies)
  53. ActiveWorkbook.Path (8 replies)
  54. Solved: Can you determine row number from Activecell (4 replies)
  55. My first VBA (13 replies)
  56. Solved: Excel file only to open on designated computers (23 replies)
  57. VBA to open, copy data from one workbook to another (1 replies)
  58. Conditional statement does not work (16 replies)
  59. Help w/ Comparing Lists using IF's and vLookup (2 replies)
  60. SUMPRODUCT confusion (6 replies)
  61. Today() to send email. (4 replies)
  62. Open each file in ary and transpose range (0 replies)
  63. First experience with VBA - hoping to get tips on streamlining my macro! (6 replies)
  64. find worksheet based on selection from dropdown list (8 replies)
  65. Solved: Update current url (3 replies)
  66. First empty row in given range (i.e. C3:G16) (7 replies)
  67. Need for Speed (4 replies)
  68. send mail automatically on a specific date (2 replies)
  69. Advanced onsheet Goal Seek (3 replies)
  70. Solved: copy only used rows to another sheet (7 replies)
  71. Mass file renaming (30 replies)
  72. Help with VB in Excel 2010 (5 replies)
  73. Highlight Cell if it contains a specific character in specific position. (4 replies)
  74. Solved: Copy and Paste in next available row (4 replies)
  75. Solved: output excel rows to txt files (15 replies)
  76. Close ss with confirmation (10 replies)
  77. [SOLVED:] Compare Two Columns and return text (13 replies)
  78. Convert format cell to text (2 replies)
  79. Copy non continuous ranges and paste it new word file (1 replies)
  80. Web Query from Logon and password protected web page (12 replies)
  81. Interesting observation about evaluate command (15 replies)
  82. Solved: Controlling a webpage dropdown (19 replies)
  83. Solved: Too many nested loops in excel (8 replies)
  84. Error handler (7 replies)
  85. Runtime Error '9' Subscript out of range (2 replies)
  86. Solved: Silly Ques: What is the Underscore btwn listed variables? (6 replies)
  87. Problem with Macro printing code (9 replies)
  88. Data Sequence like sheet1 (0 replies)
  89. Solved: Assign Cell Value to array (16 replies)
  90. Random (4 replies)
  91. Solved: Too next Together? (12 replies)
  92. Use a macro to stop to run other macros. (2 replies)
  93. Excel Macro Code Run without Button Click (4 replies)
  94. select columns A through D for each cell value in column A that equals a variable (3 replies)
  95. Macro to LIST ALL FILES IN FOLDER and then IMPORT ALL LISTED FILES (46 replies)
  96. Port to word doc (9 replies)
  97. Solved: Copying excel cell content into word template table (6 replies)
  98. Solved: Code that returns the full path of a link (5 replies)
  99. Solved: Pivot Table Source and Filter (7 replies)
  100. Solved: Add amount everyday (7 replies)
  101. How to use variable column number in vba (2 replies)
  102. [SOLVED:] Problem Reading Text file with Excel Macro (VBA) (2 replies)
  103. Solved: Need help to understand this code (2 replies)
  104. Concatenate Data with Column Headings (3 replies)
  105. Solved: Running a Function from a Worksheet (7 replies)
  106. Userform_activate from immediate window? (1 replies)
  107. Array to fill combobox (6 replies)
  108. Increase row number (2 replies)
  109. Open a File from a folder Excel Vba (5 replies)
  110. Help to Create Addins XLA for user control access (1 replies)
  111. Solved: Vlookup help filling combo box (10 replies)
  112. cut, paste, blank cell.... (1 replies)
  113. Solved: Auto Numbering Alternative Column using VBA Macros (6 replies)
  114. need vbd string to number (7 replies)
  115. VBA Generating List (23 replies)
  116. Solved: the last cell in each column (16 replies)
  117. Solved: VBA If statement using and OR function (4 replies)
  118. if sheets("sheet1") doesn't exist, then a message box will appear (1 replies)
  119. pivot help (1 replies)
  120. Prevent Clear Contents (2 replies)
  121. Adv Data Seperation (6 replies)
  122. check if workbook open - if not open it (2 replies)
  123. Solved: Print Selective Area (8 replies)
  124. Solved: trying to dynamically create a userform (6 replies)
  125. Copying from only cells with data in range (3 replies)
  126. Solved: Msg Box on 1st of every month (6 replies)
  127. insert empty row where the content between two lines are different (3 replies)
  128. skipping ahead in for loop (9 replies)
  129. expression for offset() (5 replies)
  130. Hyperlink problem (2 replies)
  131. macro to generate next serial NO (5 replies)
  132. Solved: Lotus Notes (1 replies)
  133. Email with updated spreadsheet attached (2 replies)
  134. regex function isn't working (4 replies)
  135. error when changing font color with VBA based on cell value (5 replies)
  136. Clear out static variables (3 replies)
  137. Solved: Simple Segregation of Sums (6 replies)
  138. Solved: Incorporating dynamic ranges into CORREL function using VBA (12 replies)
  139. Solved: VBA Code for Sum by condition for each date (2 replies)
  140. [SOLVED:] Infinite Loop problem (2 replies)
  141. Run macro at different intervals based on cell date's distance from today's date (5 replies)
  142. textbox to integer (6 replies)
  143. Cell Tab Order (1 replies)
  144. VBA Code for Calendar Date Button (16 replies)
  145. How can I let the macro determine if the contents of a cell is numeric or text (4 replies)
  146. Password encrypted (1 replies)
  147. Worksheet_Change and DDE (4 replies)
  148. Back to user form (5 replies)
  149. Excel VBA - load and search a Word Doc? (1 replies)
  150. Solved: Enter Times Without the Colon (3 replies)
  151. Criteria Based web query in excel (1 replies)
  152. How to add calender controls button in toolbox (3 replies)
  153. Cumulative mismatch records to single one (6 replies)
  154. Solved: VBA code for number sequence excel (2 replies)
  155. Who Can Solve This Problem? (10 replies)
  156. Shell with an array result - check items 1 by 1 (1 replies)
  157. SQL statements with VBA (2 replies)
  158. Solved: Chr(34) returning "" (12 replies)
  159. invalid property value error with combobox (9 replies)
  160. Reference a word doc embedded into excel (6 replies)
  161. Pivot table multiple filters (3 replies)
  162. Solved: evaluate some numbers (4 replies)
  163. VBA Problem taking cell data from IE (6 replies)
  164. Solved: VBA VLookup not working (6 replies)
  165. Solved: AlphaNumber Formula (10 replies)
  166. WRITE FORMULA TO WORKBOOKS HAVE PASSWORD (EXCEL 2007) (0 replies)
  167. [Excel 2010 VBA] Get events of an object created on a Frame, OLEObjects. (1 replies)
  168. [SOLVED:] Run time error 424 object required (3 replies)
  169. filter data and than load it into master file (5 replies)
  170. Change format of Variable to Time (1 replies)
  171. Solved: Display Message after Submission on a Data Validation List (2 replies)
  172. Solved: Hyperlinking to bookmarks in a word document (7 replies)
  173. Creating a control (6 replies)
  174. Removing Punctuation Macro Also Removing Leading Zeroes (2 replies)
  175. Help perfecting some VBA from a recorded macro (9 replies)
  176. expression for the code "cells.find(..)" (15 replies)
  177. Solved: deleting blank rows in a specific range (2 replies)
  178. Copy data from several worksheets to one existing worksheet with VBA (0 replies)
  179. Sum unknown rows with know columns (4 replies)
  180. next number in column (2 replies)
  181. Array or Collection - building a file summary (6 replies)
  182. Solved: Find key words in a column and color the row (7 replies)
  183. export word tables into excel (4 replies)
  184. Create Sheet (12 replies)
  185. Solved: Hyperlinking photos from directory (25 replies)
  186. [SOLVED:] Merge multiple .txt files into one .txt thru Excel VBA (6 replies)
  187. Copy data from Multiple Sheets (7 replies)
  188. Formula Help (1 replies)
  189. Delete Row If Cell Doesn't Contain Word (3 replies)
  190. Fill Rows Based On Cell Above (1 replies)
  191. VBA overflow problem, export data (3 replies)
  192. Formatting a cell's value as a date (3 replies)
  193. Error in Picking the specific excel file (2 replies)
  194. Solved: Convert formula to Macro; find closest value and return adjacent values (2 replies)
  195. Solved: Formula to extract string help (5 replies)
  196. Solved: Using Dir() (5 replies)
  197. Find Function - ONLY find what is specified (3 replies)
  198. split workbook into 2 by criteria (10 replies)
  199. Solved: Creating folder with drive selection. (4 replies)
  200. Solved: Search Through Subfolders of a Selected Folder (0 replies)
  201. Store Value in A temporary Variable (2 replies)
  202. Remove Duplicates by Date Range (8 replies)
  203. find number of work days in month (5 replies)
  204. Solved: combine data from spreadsheet help (13 replies)
  205. sort by upcoming date 60 days from today (1 replies)
  206. read write format text files (3 replies)
  207. Multiple columns into multiple rows (14 replies)
  208. Solved: How to perform code on all pages except first one (9 replies)
  209. Auto Email (4 replies)
  210. Solved: problem with sum product formula (3 replies)
  211. Solved: if-else query (5 replies)
  212. Extract substring (5 replies)
  213. Minimise use of SELECT in macro copying data from one sheet to another (9 replies)
  214. Sum x number of rows (3 replies)
  215. VBA Code to copy required data into Separate Sheet (8 replies)
  216. Use PlaySound and control left/right volume independently (1 replies)
  217. userform combobox error (0 replies)
  218. [SOLVED:] Close and re-open (4 replies)
  219. Collecting Data (5 replies)
  220. How to disable Paste Special->Keep Source Formatting - Excel 2010 (0 replies)
  221. Same ComboBox Value to show in 3 other ComboBoxes in Seperate Userforms (10 replies)
  222. copy cells to one page from others (11 replies)
  223. need help with simple macros (19 replies)
  224. More Robust Directory List Generator? (37 replies)
  225. ActiveCell.Offset in a Data filtered sheet (4 replies)
  226. Show / Hide part of Tabstrip or Multipage (4 replies)
  227. [SOLVED:] Deploying Add-in (2 replies)
  228. Comparing spreadsheet - VBA almost working.. (4 replies)
  229. Lookup and Match data (6 replies)
  230. Extract missing digits (1 replies)
  231. Close messages (2 replies)
  232. Edit macro to pull from column instead of line in macro (2 replies)
  233. Solved: Sheet Protection and Clipboard (4 replies)
  234. Updating Linked Data (6 replies)
  235. [SLEEPER:] Obtaining the standard deviation of a range in vba code (1 replies)
  236. VBA Print Range (6 replies)
  237. Solved: excel can't calculate formula (4 replies)
  238. COUNTIF formula with text color (3 replies)
  239. Delete all rows under a group (10 replies)
  240. How to go through a list on two different worksheets comparing values using VBA (3 replies)
  241. Solved: Delete Duplicate Colums (2 replies)
  242. Formatting not alligning properly on macro run (8 replies)
  243. Solved: Macro embedded in workbook (2 replies)
  244. Locking Cells (4 replies)
  245. Solved: Excel VBA Code for higlighting Pass Or Fail profile (9 replies)
  246. replace text/integer within a formula (4 replies)
  247. Solved: color (8 replies)
  248. edit values of a cell through textbox in a user form (4 replies)
  249. Solved: Need help with adding yes/no msgbox to Find Procedure (5 replies)
  250. change the (Worksheet_Change) event for a module (Sub). (19 replies)