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:] For Loop - increase stop counter due to inserting rows ? (3 replies)
  2. Run-Time Error '424' Object Required (2 replies)
  3. Table of content (4 replies)
  4. Navigate to WebBrowser problem (0 replies)
  5. Automating tables creation with VBA code (1 replies)
  6. Help with conditional values (3 replies)
  7. Ommitting Unused Data on Cell (6 replies)
  8. Trying to copy current worksheet name (5 replies)
  9. GoTo vs Call (12 replies)
  10. Save as csv (1 replies)
  11. Solved: RmDir generates File/Path Access Error (7 replies)
  12. Counting Unique Values to Generate a List of the Top X Largest (1 replies)
  13. function operations (4 replies)
  14. Solved: Refering to a specific control in a class object (2 replies)
  15. Need a loop script to copy from one 'data' workbook' to a template, make some edits, (8 replies)
  16. Need help on reconcile two worksheet (2 replies)
  17. Add List value to hyperlink (5 replies)
  18. Solved: Understanding Date and Time Formats (2 replies)
  19. Automatically create Combobox (1 replies)
  20. Checkout system (2 replies)
  21. INSTR (3 replies)
  22. Solved: Looking for values outside of a range (3 replies)
  23. Conditional Copy Paste Code (1 replies)
  24. Solved: auto complete based on the first and last name (combobox / UserForm) (5 replies)
  25. get html img src filenames by Excel VBA (2 replies)
  26. List Folder Based On Search Word (2 replies)
  27. datatype mismatch in criteria expression (1 replies)
  28. finding 12 numbers that'll give me the most result in a row of an array (1 replies)
  29. [SOLVED:] Writing VBA code to loop (4 replies)
  30. Excel visual basic (ctrl+click) copying clicked cells to new excell file (2 replies)
  31. Track and display multiple changes by different users as comment (2 replies)
  32. Browse to a folder and extract all workbook names to a sheet in a workbook (0 replies)
  33. Need Visual Basic code for macro to select pivot field name indirectly (0 replies)
  34. Solved: Error using file on another computer (2 replies)
  35. Basic Help: Copy value from one sheet to another (1 replies)
  36. Basic Help: Copy value from one sheet to another (1 replies)
  37. Solved: Count Unique Values When Filtered (10 replies)
  38. Scripting Web Form (1 replies)
  39. Solved: double click worksheet event limited to a worksheet range (2 replies)
  40. Import selected cells from multiple WB's to 1 (1 replies)
  41. Matching Co-Ordinates (2 replies)
  42. VBA SetCursosPos with co-ordinates of cell value (6 replies)
  43. How can I add a file to the playlist of VLC when it's already in use (6 replies)
  44. turning off calculation on all worksheets (3 replies)
  45. Solved: User can only save workbook if completed, or close without saving (5 replies)
  46. Sending Emails from Excel Via Outlook 2007 (1 replies)
  47. Solved: Help with labelling of graph (6 replies)
  48. Solved: Filter on matching data in two columns (6 replies)
  49. Efficient Macro - Suggestions (5 replies)
  50. Help required - please (1 replies)
  51. Question on Target.Parent.Active (1 replies)
  52. Probably an easy question for you VBA pros! (1 replies)
  53. Solved: cut and paste records based on multiple criteria (3 replies)
  54. Programming help (0 replies)
  55. Grouped Cells - show and hide groups in code (1 replies)
  56. [SLEEPER:] Sum Till Target is Reached (10 replies)
  57. Election results (19 replies)
  58. VBA for Investment (0 replies)
  59. VBA to extract all images from word file (12 replies)
  60. UserForm to select items from dependent lists (2 replies)
  61. Help please - very new to this (3 replies)
  62. Upon returning research userform,date is reversed MM/dd/yyyy(I.need.DD/mm/yyyy (3 replies)
  63. Copy Paste Code (4 replies)
  64. Mail attachment through EXCEL (0 replies)
  65. Solved: Averaging figures logged in the AM vs PM hours (2 replies)
  66. discret convolution (0 replies)
  67. Combining Spreadsheets by feature (1 replies)
  68. Help using For Next loop to delete ranges (6 replies)
  69. VBA 2010 create PDF from multiple sheets (2 replies)
  70. [SOLVED:] vba code for remove blank cells (9 replies)
  71. How to Extract Title from a Text file and Paste to Excel (4 replies)
  72. Copy\Paste (4 replies)
  73. Drop down problems (3 replies)
  74. Solved: text to column question (8 replies)
  75. Solved: Use VBA to assign assign code/a macro to a custom button added to a toolbar?it (15 replies)
  76. extracting from web (20 replies)
  77. Multiple Actions on each cell in loop (8 replies)
  78. [SLEEPER:] Search (6 replies)
  79. Help with an Export Macro to Excel (3 replies)
  80. Solved: Transposing Irregular Data (7 replies)
  81. Question on Row References in VBA (4 replies)
  82. Autofilter - Worksheet Calculate (8 replies)
  83. VBA: Multiple Autofill in same column (1 replies)
  84. check if a surname is repeated within a cell and output a simpler name (8 replies)
  85. Color Entire row based on the date (2 replies)
  86. vba code required to help populate emails with details in spreadsheet and send (2 replies)
  87. Consolidate Lists (2 replies)
  88. [SOLVED:] Plz help to modify search VBA (Data sheet to another file) (2 replies)
  89. Values and Reporting (1 replies)
  90. Selecting a range based on a date range (4 replies)
  91. Macro to insert batch hyperlinks from external sheet [pics] (3 replies)
  92. Page Numbers (6 replies)
  93. Formulas into VBA (1 replies)
  94. Find repetition in data values (2 replies)
  95. Merging cells based upon values (0 replies)
  96. Uncheck boxes in one group only (4 replies)
  97. Solved: What's the use of a class module (7 replies)
  98. Excel Compatibility issue (11 replies)
  99. Solved: Date Format Problems (16 replies)
  100. .txt -> .xls format (6 replies)
  101. Asking about Using VBA in Excel for Download Financial Data (3 replies)
  102. Vlookup query (3 replies)
  103. Help with VB to VBA (0 replies)
  104. Open objFile For Input As iFileNum opens only 512 files and fails to open 513th (6 replies)
  105. After print event (4 replies)
  106. vba combobox help (4 replies)
  107. Update Multiple workbooks with Master File (0 replies)
  108. Copying columns from multiple sheets to master (13 replies)
  109. Get Data from IE Error .... (1 replies)
  110. textbox color change (21 replies)
  111. Help with modifying code to look for like sheetnames (1 replies)
  112. Pivot chart - Auto change Data source (3 replies)
  113. Application to enter data from columns that are in the various documents (0 replies)
  114. VBA to Add ListItems to a ListView (7 replies)
  115. Duplex printing of specific sheets in workbook? (1 replies)
  116. Look at Sheets that begin with Shop* then see if data exists in Range... (1 replies)
  117. hi im new to VBA need some help copy and pasting with a twist. (2 replies)
  118. Solved: copy ranges (tables) separated for separate tabs (3 replies)
  119. google spreadsheet help (0 replies)
  120. google spreadsheet help (1 replies)
  121. How to code a boolean expression parser? (10 replies)
  122. Show formula and absolut reference (6 replies)
  123. Solver in VBA- Project Dependencies (2 replies)
  124. loop to fill different cells regarding an Data base (8 replies)
  125. Help to extract data between tags in webpage html (3 replies)
  126. Solved: Making two cells date and placing them with a hyphen in a cell (3 replies)
  127. Find the max and min from a range of cell given a criteria (4 replies)
  128. Solved: Stepping through Userform VBA code (2 replies)
  129. Kick off macro at 8:15 am central time (1 replies)
  130. Solved: (VBA) Export to .txt only specific columns without empty cells (7 replies)
  131. Solved: VBA to replace specific alphabets with blanks (2 replies)
  132. Solved: Renaming modules (3 replies)
  133. Using a variable to as criteria in autofilter (3 replies)
  134. Solved: Auto-populate column with hyperlink code (2 replies)
  135. Solved: Mouse over a particular column in ListView to display a message (7 replies)
  136. Write Res Password - Force ReadOnly unless Macros Enabled (11 replies)
  137. VB Code partially working (1 replies)
  138. edit code for display In Exponential (0 replies)
  139. text help (1 replies)
  140. Solved: Selection.Find Error handling (3 replies)
  141. Out of memory when saving file (9 replies)
  142. VBA Macro to Count Rows across Multiple Workbooks (5 replies)
  143. Input Box: Ranges... (7 replies)
  144. Solved: Copy and Paste to new row/column IF values exist in paste (2 replies)
  145. Help with macro code found on this forum (3 replies)
  146. RefreshAll complete event (1 replies)
  147. Solved: Trouble with syntax? (4 replies)
  148. Macro to count words (6 replies)
  149. Solved: Rename the name of files (1 replies)
  150. Solved: If Or Statement (4 replies)
  151. Solved: Subscript out of range when using name of workbook that exists (2 replies)
  152. edit vba code for display In Exponential Form (12 replies)
  153. Solved: Parsing an array, calculating cumulative sum and spitting some output (5 replies)
  154. Solved: Conditional Format (2 replies)
  155. Solved: Accurate specific cells must be maintained in the concrete columns on another sheet (2 replies)
  156. Application object names, true, false etc (4 replies)
  157. If formula - Can't get to work properly (3 replies)
  158. Excel VBA control loop with Find (0 replies)
  159. Not Copying the Value of an equation from range. (11 replies)
  160. Building a Call Tree (work in progress) (6 replies)
  161. A bit of Help with an array code (4 replies)
  162. [SOLVED:] Interpolation function with empty data (2 replies)
  163. Understanding Code - Check If Named Range Exists (13 replies)
  164. Solved: Auto Fit Selected Row Plus 10 (2 replies)
  165. Run Autoit File from Excel File Location (3 replies)
  166. Solved: If in particular column written text then other column should be numeric (7 replies)
  167. extracting a single row from a multi row/column range (5 replies)
  168. Simple but not for me :( (5 replies)
  169. Automating distribution of emails with excel attachments with VBA (4 replies)
  170. if find matched data, delete the column data (2 replies)
  171. Solved: Trouble with copying in a loop... (1 replies)
  172. Run time error '429': ActiveX component can't create object (11 replies)
  173. Compare and delete duplicated data from several columns (6 replies)
  174. Run time error '429': ActiveX component can't create object (1 replies)
  175. Excel, send emails, vba, question (1 replies)
  176. I need VBA code to update log worksheet and maintain a history of all orders. (16 replies)
  177. Trying to open Excel 2010, auto-open Excel 2003 (1 replies)
  178. Combining multiple columns into 1 for pivot table (0 replies)
  179. External Workbook Lookup and Match (0 replies)
  180. Create orders log and monthly report for all orders (0 replies)
  181. Loop thru FTP sub-folders, downloading, renaming & uploading their files. (20 replies)
  182. Solved: finding row and skipping over data (2 replies)
  183. connect to the Internet with a click of a button (2 replies)
  184. Is there an Easier way to do this? Sum Sheets based on Name * (1 replies)
  185. Macro to print chart (1 replies)
  186. Solved: Pivot Chart Help (14 replies)
  187. Break Text at First Space Before Char 75, Insert Line and Move Char 75+ to New Line (10 replies)
  188. Loop Issues (1 replies)
  189. Solved: AddIn - Unhelpful Error Message - please illuminate! (4 replies)
  190. Solved: How update tow Chart after import by VBA finish (7 replies)
  191. Does not work if there is only 1 entry in column, works for more than one enteries (3 replies)
  192. Complex-ish macro including averageing and choosing-data-by-identifier (2 replies)
  193. Message box pop up for command button (6 replies)
  194. Solved: extract row from multi row range (2 replies)
  195. Stopwatch In Excel (12 replies)
  196. working with ranges in custom function (2 replies)
  197. Building a formula using VBA (7 replies)
  198. Solved: Conditional Formatting: Copy Formats (4 replies)
  199. Solved: Extend selection to next three cells (2 replies)
  200. VBA to collect internet search term hyperlinks (2 replies)
  201. [SLEEPER:] VBA to ungroup only selected values (1 replies)
  202. Solved: Allowing time for the SQL query to fully run (3 replies)
  203. VBA not doing Mathmitical calculation when its ran (8 replies)
  204. Solved: VBA logical test (3 replies)
  205. Excel 2010 Slicer selection range (1 replies)
  206. [SOLVED:] Row Number of Cell (2 replies)
  207. Date format,crosstab in SQL statement (5 replies)
  208. Basic: Copy-Paste Data using xlDown multiple times (1 replies)
  209. Capturing Data from a user form (14 replies)
  210. Excel add multiple radio buttons (4 replies)
  211. How to test Querytable connection before actually executing SQL query (1 replies)
  212. Unable to set visible property of the pivotitem class (3 replies)
  213. Solved: 5 small subs into 1 sub. HELP! (6 replies)
  214. [SOLVED:] Could this be a buffering problem? (14 replies)
  215. Project Analyzer - Procedure call tree (1 replies)
  216. Solved: VBA to go the sheets specified and run the macro. (12 replies)
  217. Sumif to VBA (4 replies)
  218. As Integer datatype allows fractions (1 replies)
  219. Solved: Read Sheet name from a Cell (10 replies)
  220. Creating an Object Model (8 replies)
  221. I need help secure a workbook with a password (2 replies)
  222. [SOLVED:] VBA Code or Forumula (3 replies)
  223. How to Link 2Combo Box select Date and Cell name (7 replies)
  224. VLook Up with Multiple criteria (2 replies)
  225. [SOLVED:] Reference to same word in excel (8 replies)
  226. multiple condition if statement (5 replies)
  227. Character symbols for file types (7 replies)
  228. Help with Loop (10 replies)
  229. Solved: Unlock Row If cell Equals Specific Value (8 replies)
  230. [SOLVED:] Subtotals (3 replies)
  231. [SOLVED:] Autosum error (1 replies)
  232. Date format problem (4 replies)
  233. Small VBA program - fast (1 replies)
  234. Populate Listbox in "alpabetic order" (2 replies)
  235. [SOLVED:] excel automate copying cells from row (6 replies)
  236. [SOLVED:] How to format differently 2 parts of same string? (5 replies)
  237. [SOLVED:] CLearcontent or delete rows: Keep proper count of used row (2 replies)
  238. How to access a Checkbox in a ListView per row? (15 replies)
  239. Coding not works sometime (11 replies)
  240. Solved: PIVOT FILTER (2 replies)
  241. delete the duplication value between 2 WS (2 replies)
  242. Encrypt a worksheet in a workbook using VBA (0 replies)
  243. Having a problem debugging using SendKeys (6 replies)
  244. lock autofilter range or autofilter part of range (6 replies)
  245. Copy,Paste,Transpose in VBA loop -Thank you so much! (1 replies)
  246. Help with SendKeys (9 replies)
  247. Finding a specific text string within a cell (3 replies)
  248. Data Validation List Macro (14 replies)
  249. Solved: Convert time (5 replies)
  250. Solved: Find row above and below searchvalue, VBA (4 replies)