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 174
  1. Page Numbers (6 replies)
  2. Formulas into VBA (1 replies)
  3. Find repetition in data values (2 replies)
  4. Merging cells based upon values (0 replies)
  5. Uncheck boxes in one group only (4 replies)
  6. Solved: What's the use of a class module (7 replies)
  7. Excel Compatibility issue (11 replies)
  8. Solved: Date Format Problems (16 replies)
  9. .txt -> .xls format (6 replies)
  10. Asking about Using VBA in Excel for Download Financial Data (3 replies)
  11. Vlookup query (3 replies)
  12. Help with VB to VBA (0 replies)
  13. Open objFile For Input As iFileNum opens only 512 files and fails to open 513th (6 replies)
  14. After print event (4 replies)
  15. vba combobox help (4 replies)
  16. Update Multiple workbooks with Master File (0 replies)
  17. Copying columns from multiple sheets to master (13 replies)
  18. Get Data from IE Error .... (1 replies)
  19. textbox color change (21 replies)
  20. Help with modifying code to look for like sheetnames (1 replies)
  21. Pivot chart - Auto change Data source (3 replies)
  22. Application to enter data from columns that are in the various documents (0 replies)
  23. VBA to Add ListItems to a ListView (7 replies)
  24. Duplex printing of specific sheets in workbook? (1 replies)
  25. Look at Sheets that begin with Shop* then see if data exists in Range... (1 replies)
  26. hi im new to VBA need some help copy and pasting with a twist. (2 replies)
  27. Solved: copy ranges (tables) separated for separate tabs (3 replies)
  28. google spreadsheet help (0 replies)
  29. google spreadsheet help (1 replies)
  30. How to code a boolean expression parser? (10 replies)
  31. Show formula and absolut reference (6 replies)
  32. Solver in VBA- Project Dependencies (2 replies)
  33. loop to fill different cells regarding an Data base (8 replies)
  34. Help to extract data between tags in webpage html (3 replies)
  35. Solved: Making two cells date and placing them with a hyphen in a cell (3 replies)
  36. Find the max and min from a range of cell given a criteria (4 replies)
  37. Solved: Stepping through Userform VBA code (2 replies)
  38. Kick off macro at 8:15 am central time (1 replies)
  39. Solved: (VBA) Export to .txt only specific columns without empty cells (7 replies)
  40. Solved: VBA to replace specific alphabets with blanks (2 replies)
  41. Solved: Renaming modules (3 replies)
  42. Using a variable to as criteria in autofilter (3 replies)
  43. Solved: Auto-populate column with hyperlink code (2 replies)
  44. Solved: Mouse over a particular column in ListView to display a message (7 replies)
  45. Write Res Password - Force ReadOnly unless Macros Enabled (11 replies)
  46. VB Code partially working (1 replies)
  47. edit code for display In Exponential (0 replies)
  48. text help (1 replies)
  49. Solved: Selection.Find Error handling (3 replies)
  50. Out of memory when saving file (9 replies)
  51. VBA Macro to Count Rows across Multiple Workbooks (5 replies)
  52. Input Box: Ranges... (7 replies)
  53. Solved: Copy and Paste to new row/column IF values exist in paste (2 replies)
  54. Help with macro code found on this forum (3 replies)
  55. RefreshAll complete event (1 replies)
  56. Solved: Trouble with syntax? (4 replies)
  57. Macro to count words (6 replies)
  58. Solved: Rename the name of files (1 replies)
  59. Solved: If Or Statement (4 replies)
  60. Solved: Subscript out of range when using name of workbook that exists (2 replies)
  61. edit vba code for display In Exponential Form (12 replies)
  62. Solved: Parsing an array, calculating cumulative sum and spitting some output (5 replies)
  63. Solved: Conditional Format (2 replies)
  64. Solved: Accurate specific cells must be maintained in the concrete columns on another sheet (2 replies)
  65. Application object names, true, false etc (4 replies)
  66. If formula - Can't get to work properly (3 replies)
  67. Excel VBA control loop with Find (0 replies)
  68. Not Copying the Value of an equation from range. (11 replies)
  69. Building a Call Tree (work in progress) (6 replies)
  70. A bit of Help with an array code (4 replies)
  71. [SOLVED:] Interpolation function with empty data (2 replies)
  72. Understanding Code - Check If Named Range Exists (13 replies)
  73. Solved: Auto Fit Selected Row Plus 10 (2 replies)
  74. Run Autoit File from Excel File Location (3 replies)
  75. Solved: If in particular column written text then other column should be numeric (7 replies)
  76. extracting a single row from a multi row/column range (5 replies)
  77. Simple but not for me :( (5 replies)
  78. Automating distribution of emails with excel attachments with VBA (4 replies)
  79. if find matched data, delete the column data (2 replies)
  80. Solved: Trouble with copying in a loop... (1 replies)
  81. Run time error '429': ActiveX component can't create object (11 replies)
  82. Compare and delete duplicated data from several columns (6 replies)
  83. Run time error '429': ActiveX component can't create object (1 replies)
  84. Excel, send emails, vba, question (1 replies)
  85. I need VBA code to update log worksheet and maintain a history of all orders. (16 replies)
  86. Trying to open Excel 2010, auto-open Excel 2003 (1 replies)
  87. Combining multiple columns into 1 for pivot table (0 replies)
  88. External Workbook Lookup and Match (0 replies)
  89. Create orders log and monthly report for all orders (0 replies)
  90. Loop thru FTP sub-folders, downloading, renaming & uploading their files. (20 replies)
  91. Solved: finding row and skipping over data (2 replies)
  92. connect to the Internet with a click of a button (2 replies)
  93. Is there an Easier way to do this? Sum Sheets based on Name * (1 replies)
  94. Macro to print chart (1 replies)
  95. Solved: Pivot Chart Help (14 replies)
  96. Break Text at First Space Before Char 75, Insert Line and Move Char 75+ to New Line (10 replies)
  97. Loop Issues (1 replies)
  98. Solved: AddIn - Unhelpful Error Message - please illuminate! (4 replies)
  99. Solved: How update tow Chart after import by VBA finish (7 replies)
  100. Does not work if there is only 1 entry in column, works for more than one enteries (3 replies)
  101. Complex-ish macro including averageing and choosing-data-by-identifier (2 replies)
  102. Message box pop up for command button (6 replies)
  103. Solved: extract row from multi row range (2 replies)
  104. Stopwatch In Excel (12 replies)
  105. working with ranges in custom function (2 replies)
  106. Building a formula using VBA (7 replies)
  107. Solved: Conditional Formatting: Copy Formats (4 replies)
  108. Solved: Extend selection to next three cells (2 replies)
  109. VBA to collect internet search term hyperlinks (2 replies)
  110. [SLEEPER:] VBA to ungroup only selected values (1 replies)
  111. Solved: Allowing time for the SQL query to fully run (3 replies)
  112. VBA not doing Mathmitical calculation when its ran (8 replies)
  113. Solved: VBA logical test (3 replies)
  114. Excel 2010 Slicer selection range (1 replies)
  115. [SOLVED:] Row Number of Cell (2 replies)
  116. Date format,crosstab in SQL statement (5 replies)
  117. Basic: Copy-Paste Data using xlDown multiple times (1 replies)
  118. Capturing Data from a user form (14 replies)
  119. Excel add multiple radio buttons (4 replies)
  120. How to test Querytable connection before actually executing SQL query (1 replies)
  121. Unable to set visible property of the pivotitem class (3 replies)
  122. Solved: 5 small subs into 1 sub. HELP! (6 replies)
  123. [SOLVED:] Could this be a buffering problem? (14 replies)
  124. Project Analyzer - Procedure call tree (1 replies)
  125. Solved: VBA to go the sheets specified and run the macro. (12 replies)
  126. Sumif to VBA (4 replies)
  127. As Integer datatype allows fractions (1 replies)
  128. Solved: Read Sheet name from a Cell (10 replies)
  129. Creating an Object Model (8 replies)
  130. I need help secure a workbook with a password (2 replies)
  131. [SOLVED:] VBA Code or Forumula (3 replies)
  132. How to Link 2Combo Box select Date and Cell name (7 replies)
  133. VLook Up with Multiple criteria (2 replies)
  134. [SOLVED:] Reference to same word in excel (8 replies)
  135. multiple condition if statement (5 replies)
  136. Character symbols for file types (7 replies)
  137. Help with Loop (10 replies)
  138. Solved: Unlock Row If cell Equals Specific Value (8 replies)
  139. [SOLVED:] Subtotals (3 replies)
  140. [SOLVED:] Autosum error (1 replies)
  141. Date format problem (4 replies)
  142. Small VBA program - fast (1 replies)
  143. Populate Listbox in "alpabetic order" (2 replies)
  144. [SOLVED:] excel automate copying cells from row (6 replies)
  145. [SOLVED:] How to format differently 2 parts of same string? (5 replies)
  146. [SOLVED:] CLearcontent or delete rows: Keep proper count of used row (2 replies)
  147. How to access a Checkbox in a ListView per row? (15 replies)
  148. Coding not works sometime (11 replies)
  149. Solved: PIVOT FILTER (2 replies)
  150. delete the duplication value between 2 WS (2 replies)
  151. Encrypt a worksheet in a workbook using VBA (0 replies)
  152. Having a problem debugging using SendKeys (6 replies)
  153. lock autofilter range or autofilter part of range (6 replies)
  154. Copy,Paste,Transpose in VBA loop -Thank you so much! (1 replies)
  155. Help with SendKeys (9 replies)
  156. Finding a specific text string within a cell (3 replies)
  157. Data Validation List Macro (14 replies)
  158. Solved: Convert time (5 replies)
  159. Solved: Find row above and below searchvalue, VBA (4 replies)
  160. Help with VB code please? (9 replies)
  161. Calling DLL function from Excel VBA doesn't return value (9 replies)
  162. Copying values from a dynamic range (4 replies)
  163. [SOLVED:] VBA Copy data based on name & paste into workbook w/ named tab (8 replies)
  164. Work on table while filtering (2 replies)
  165. fitler by keyword (2 replies)
  166. Solved: Split 2 Column to 2 columns with 85 record (2 replies)
  167. Solved: Output of DOS command to excel using VBA (4 replies)
  168. Solved: worksheetfunction.vlookup (8 replies)
  169. help find target !! (1 replies)
  170. SQL Select * (7 replies)
  171. Solved: Clearing Value in ComboBox (5 replies)
  172. Empty Fields (1 replies)
  173. [SOLVED:] Update Cell Value Based on Match to Outside Workbook (19 replies)
  174. VBA programming assistance (2 replies)
  175. Solved: Add an Auto increment number in blank cell in column A (4 replies)
  176. Update Progress Bar at EXACTLY 1 second Interval (4 replies)
  177. How to get around userform inability to "remember" (3 replies)
  178. Insert CheckBox to a SubItem of ListView Control (2 replies)
  179. Change tab colour when condition is met (3 replies)
  180. Solved: Writing in any cell in the range and check the remaining sheets replay (5 replies)
  181. Solved: excel 2013 conflicting with 2010 vba (10 replies)
  182. code_montecarlo (2 replies)
  183. If row 55 is not on page 1, then keep reducing the bottom margin by 0.1 (1 replies)
  184. Evoid Registering with duplications (5 replies)
  185. Copy col help (3 replies)
  186. Trying to save on computers with different FileFormats (6 replies)
  187. Solved: VBA to update source data for excel charts (13 replies)
  188. [SOLVED:] Creating Index Items with Dynamic Hyperlinks to Cells in Workbook (23 replies)
  189. Solved: How to let Excel "monitor" for opening or closing a random file? (4 replies)
  190. Better solution for stock charts (2 replies)
  191. Solved: Copy From One Sheet to Another (2 replies)
  192. Solved: Formatting help (12 replies)
  193. Sleeper: Screen scraping (2 replies)
  194. [SOLVED:] Range Concatenation Help Needed (6 replies)
  195. Sum get error (10 replies)
  196. Improper Drill-down format (3 replies)
  197. [SOLVED:] Create a Table Using Listobject without Generating Autofilters (4 replies)
  198. Subtract adjacent values based on a condition (1 replies)
  199. Reference #N/A (4 replies)
  200. Solved: Time as string with decimals? (4 replies)
  201. calculate only when macro has been enable. (6 replies)
  202. With Selection.Format.TextFrame2. Run Error (6 replies)
  203. Recursive Procedure/Function Caller Tree (1 replies)
  204. VBA web query java Timer with limited time (0 replies)
  205. VBA query to SQLServer 2012 times out - Solved (1 replies)
  206. Solved: Pivot Table Is Not Consolidating (2 replies)
  207. vba for replacing the charater in cell (3 replies)
  208. Solved: Convert file (7 replies)
  209. Solved: Help with comparison please (6 replies)
  210. To Compare two cells in row and insert column (6 replies)
  211. Send outlook (1 replies)
  212. Calculate between two spreadsheets (1 replies)
  213. Solved: VBA "Lookup" (10 replies)
  214. For loop help (7 replies)
  215. Delete ** in end of each cell of right (1 replies)
  216. [SOLVED:] Just Keep 1 Row for each Account (19 replies)
  217. [SLEEPER:] Prevent Copy & Paste From Overwriting Data Validation (8 replies)
  218. Solved: Another countdown query (9 replies)
  219. Solved: Delete Column that do not have headers "XYZ" (3 replies)
  220. Solved: Name #? error (4 replies)
  221. Solved: Selection reference (3 replies)
  222. Populate Excel Template from another worksheet (2 replies)
  223. Problem with the VBA code to copy cell and paste in new workbook (1 replies)
  224. [SOLVED:] SQL query format (6 replies)
  225. [SOLVED:] Simple Printer Control (5 replies)
  226. print userform (2 replies)
  227. Solved: Non-Continuous Range with Pivot Table (2 replies)
  228. obtain current SSID's (0 replies)
  229. ExecuteExcel4Macro(String) (1 replies)
  230. Copy Range Based on Condition (3 replies)
  231. VBA or Possible with Excel Functions ? (1 replies)
  232. [SLEEPER:] VBA code to search XPS document (0 replies)
  233. Delete the dash from first and end of cell (2 replies)
  234. Creating Pop-Up Calendar: How to do in Excel 2010?Hi, I've been researching into add (0 replies)
  235. VBA to record the field settings of a pivot (0 replies)
  236. Solved: multiple font colors (2 replies)
  237. Today's date and following 6 working days (9 replies)
  238. 1 Userform and 60 ComboBoxes (4 replies)
  239. Solved: Counting by Vehicle number (2 replies)
  240. VBA code to delete certain rows. (7 replies)
  241. Multiselect listbox values to a textbox (4 replies)
  242. [SOLVED:] save certain sheets as a pdf from a closed wb (4 replies)
  243. Combine print with dynamic print areas (0 replies)
  244. VBA to append 0000 to string dependent upon state (3 replies)
  245. Tick Mark (2 replies)
  246. help save worksheet to new wb (9 replies)
  247. Sleeper: Code is not copying correct cells (2 replies)
  248. Auto Update (without clicking on scrollbar (on worksheet) every second! (0 replies)
  249. Opening a New Instance Of Excel (0 replies)
  250. Solved: How to edit field values in ADO recordset ? (7 replies)