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:] Help with a msgbox :) (4 replies)
  2. Adding Item to Reference Library (5 replies)
  3. [SOLVED:] Calculate sub shift hours (22 replies)
  4. [SOLVED:] Help With Worksheet Change event (3 replies)
  5. [SOLVED:] Correct Row/Column Numbers with INDEX and MATCH (4 replies)
  6. [SOLVED:] Find every instance of a word, then find previous instance of another word (14 replies)
  7. [SOLVED:] Clearing contents of all worksheets in a excel workbook (3 replies)
  8. [SOLVED:] Help me improve some old code (13 replies)
  9. Help with VBA Events - some work and some don't (34 replies)
  10. Automatically Inserting Rows with Date, Each Worksheet (1 replies)
  11. [SOLVED:] Runtime Error 1004 on 2nd run (9 replies)
  12. [SOLVED:] Problem deleting a legendEntry (5 replies)
  13. Help Require in VBA (16 replies)
  14. creating Parameters in Excel using VBA (13 replies)
  15. [SOLVED:] Code works in Macro, but not in Function (7 replies)
  16. Update workbook data from another workbook (2 replies)
  17. [SOLVED:] Worksheet not updating with data from VBA (4 replies)
  18. Searching information in different bases (7 replies)
  19. VBA Code - Novice Here, Sorry! (7 replies)
  20. [SOLVED:] Remove Text (2 replies)
  21. trouble selecting sheet (1 replies)
  22. Merge Single Worksheets from Different Files into One Workbook AND Replace Formulas (2 replies)
  23. Excel 2003, worksheet_change to insert current date when a cell is colored yellow (3 replies)
  24. Merged mulitple sheets of existing workbook into one sheet (1 replies)
  25. [SOLVED:] Need Help Removing quotes and double quotes from my Excel Spreadsheet (11 replies)
  26. multiple word files tables to excel vba (5 replies)
  27. remove an item from a combobox. (21 replies)
  28. I Can't change <SELECT> html tag using VBA (6 replies)
  29. VBA - Rounding Goal Seek result (2 replies)
  30. Userform submitting a date in format "mmm-yy", but a small problem arises. (6 replies)
  31. [SOLVED:] When does a Chart object become a ChartObject object (8 replies)
  32. VBA combo boxes (6 replies)
  33. [SOLVED:] Trying to add variables into Worksheet statements and can't get the right syntax (6 replies)
  34. Runtime error copying value from one worksheet to another in same workbook (4 replies)
  35. Iterate values through calculation using VBA and record results (16 replies)
  36. [SOLVED:] Iterate values through cell using VBA and record result (3 replies)
  37. Issues getting data in PowerPivot from Access (3 replies)
  38. [SOLVED:] Download file, how do I know when the file is downloaded? (13 replies)
  39. How to send email from excel using VBA with Cell Range (Including Images) as Email Bo (3 replies)
  40. [SOLVED:] Writing and Reading the Same Set of Ranges (3 replies)
  41. Autofilter based on content in cells (6 replies)
  42. [SLEEPER:] Run-time error when using OraOLEDB.Oracle Provider (0 replies)
  43. [SOLVED:] ListView Run-time erro "13"; Type mismatch (9 replies)
  44. [SOLVED:] Put data from userform into specific place. (6 replies)
  45. [SOLVED:] Print a changing range based on date values (6 replies)
  46. How modal forms work (4 replies)
  47. Slow Import from Web (5 replies)
  48. [SOLVED:] Userform for Entering Data in Excel VBA (7 replies)
  49. Lookup column value and find value (7 replies)
  50. VBA Userform (for Entering Data) (3 replies)
  51. Automating the use of translation.babylon.com (5 replies)
  52. How to Avoid Formatting Cells When Protected? (7 replies)
  53. Multiple Column Listbox (with headers) = the bain of my existence (5 replies)
  54. How to add row into another worksheet based on multiple cell values? (10 replies)
  55. Printing an Selected Sheets (2 replies)
  56. Excel VBA to Unhide rows with a specific value in a Range (5 replies)
  57. How to compare text in 2 cells and highlight incorrect text (3 replies)
  58. [SOLVED:] Directly Copy A Range from One Sheet to Another (2 replies)
  59. [SOLVED:] macro button for copying excel data into multiple word docs (8 replies)
  60. [SOLVED:] Increase number every nth year (2 replies)
  61. [SOLVED:] Trying to find the next empty cell in a range Using With and Set method - Help (7 replies)
  62. Array for ActiveX Controls (7 replies)
  63. [SOLVED:] Case Senerio and Offset That Creates A Data Validation Box (4 replies)
  64. Compiling and Exporting Information (2 replies)
  65. automation error (3 replies)
  66. Hiding Cols With VBA (3 replies)
  67. [SOLVED:] Acceptable to use Goto (27 replies)
  68. [SOLVED:] Creating an Array from a Table with only one row in it (15 replies)
  69. Optimize a VBA loop (3 replies)
  70. VBA - Change Decimal Separator (10 replies)
  71. String length mismatch (3 replies)
  72. [SOLVED:] Adding New Chart Series with Loop (3 replies)
  73. [SOLVED:] Date range (6 replies)
  74. Format search results in a Multicolumn Listbox With Headings (3 replies)
  75. [SOLVED:] Automatic Generate random unique time From 8 AM till 21 PM in range (8 replies)
  76. [SOLVED:] Kill Files that Begin With Something (7 replies)
  77. Sales Returns for FIFO (8 replies)
  78. Question regarding loops sum and average (2 replies)
  79. [SOLVED:] Increment Column Selection with InputBox (12 replies)
  80. Mathematical Excel Optimisation Challenge (production of units) (5 replies)
  81. [SOLVED:] VBA Scientific Format. Can I reduce a digit? (6 replies)
  82. Runtime error 445, need help (3 replies)
  83. Excel record aggregation with VBA macro (2 replies)
  84. New to VBA Coding (3 replies)
  85. Merging Word Documents From VBA (4 replies)
  86. Trouble setting pivot page filter using VBA (3 replies)
  87. VBA Auto generate numbering (4 replies)
  88. [SOLVED:] Subscript out of Range (5 replies)
  89. SaveasUI - Save as .xls not XLSM (2 replies)
  90. Hidden worksheet codes not working (6 replies)
  91. Help in VBA (3 replies)
  92. [SOLVED:] Changing formatting by writing all cells to an array (25 replies)
  93. Importing data from Header and table in Word to Excel. (6 replies)
  94. Check whether numbers are sequential? (1 replies)
  95. [SOLVED:] Allow only choose 4 colors (2 replies)
  96. [SOLVED:] Parse Text And Read Into Cells (12 replies)
  97. [SOLVED:] Error: Overflow (8 replies)
  98. [SOLVED:] VBA Auto SAVE - need help! (5 replies)
  99. Loop through subfolders (1 replies)
  100. [SOLVED:] fill months following (3 replies)
  101. import txt. file to excel with vba (0 replies)
  102. Copy Paste from multiple worksheets into one based on multiple criteria (20 replies)
  103. FORCE TO POPULATE CELL (2 replies)
  104. [SOLVED:] Need a little help with "totals" (4 replies)
  105. Create Sheet if Workbook name contain some text (1 replies)
  106. Create a simple chart in a sheet where a pivot table already exists (6 replies)
  107. Edit VBA to prevent paste but allow copy and save the file with a file name derived (0 replies)
  108. [SOLVED:] Help to Improve Double Loop Code (8 replies)
  109. Excel as Notify Icon (1 replies)
  110. find matching entry, then copy and paste (2 replies)
  111. [SOLVED:] Range, Columns, and Copy (12 replies)
  112. Help with code (2 replies)
  113. [SOLVED:] struggling with excel combo boxes macro (0 replies)
  114. Sumifs and dates (1 replies)
  115. [SOLVED:] Sum from previous sum formula in a column to active cell (9 replies)
  116. Exel Crashes with Form Control (14 replies)
  117. Code to Group Worksheets when Printing and Print Preview - 2003 vs 2010 (6 replies)
  118. XML Data I/O (0 replies)
  119. [SOLVED:] RunTime Error 53 : File Not Found error (10 replies)
  120. Bill of Material (2 replies)
  121. Fill a combobox with data found in a range based on worksheet chosen in another cbx (3 replies)
  122. Copy data from different workbook and consolidate into one masterfile workbook (0 replies)
  123. [SOLVED:] Help with Loops (4 replies)
  124. [SOLVED:] User input to delete value in named range: (8 replies)
  125. VLOOKUP returns #N/A (2 replies)
  126. Find a "zero" of an implicit function (1 replies)
  127. [SOLVED:] Date overlap (9 replies)
  128. [SOLVED:] copy not contiguous cells via VBA (3 replies)
  129. Barcode fonts (3 replies)
  130. blank row (2 replies)
  131. trasfer data from Lotus macro to Excal VBA macro (2 replies)
  132. Change Cell Color on Sheet "Statistic" if value is negative (2 replies)
  133. PivotFields class returns an error when .Function property is set (2 replies)
  134. [SOLVED:] 2013 CalcPad.xlsm in XLStart folder. Open Excel - "CalcPad.xlsm is already open." (1 replies)
  135. Total data if salary each month is the same - VBA (0 replies)
  136. How to copy format of a column using spin button (0 replies)
  137. Extract values of a certain format (10 replies)
  138. Rename Code Modules Programmatically (17 replies)
  139. VBA Calendar (5 replies)
  140. Search for a string on all excel files inside a ZIp folder (6 replies)
  141. help with copy range (4 replies)
  142. [SOLVED:] Creating a unique id (13 replies)
  143. [SOLVED:] Populating Listbox (8 replies)
  144. [SOLVED:] Ie Automation (3 replies)
  145. Unable to set FormulaArray Property of the Range Class - Using Replace Function (3 replies)
  146. [SOLVED:] RTE Error (6 replies)
  147. Rename buttons using loop and "i + 1" (6 replies)
  148. Call previous dictionary entry (3 replies)
  149. [SOLVED:] Change the macro to search for a specific word (as written) and not close to it (8 replies)
  150. Information sheet or message in xlam? (2 replies)
  151. VBA Script to Average Amplitude Values in Each Bin Range of a Frequency Histogram (4 replies)
  152. Have Macro run when cell is updated (13 replies)
  153. Percentage Difference for Two Percentage (1 replies)
  154. [SOLVED:] Copy sheet into another workbook and put in alphabetical order (7 replies)
  155. Excel slideshow and data query help (5 replies)
  156. Help to use an array for this little section of code (2 replies)
  157. Worksheet change clears selection(s) on MultiSelect type listbox. (4 replies)
  158. vba code move cell to next cell (9 replies)
  159. if find string copy that cell to right column (3 replies)
  160. Copy & Pasting Overwrites My Data Validation (4 replies)
  161. [SOLVED:] Need: VB code to get values from different closed workbooks (4 replies)
  162. html problem with vba (1 replies)
  163. [SOLVED:] Adjust error calculation in VBA (2 replies)
  164. Wrong line in the macro. (5 replies)
  165. Workbook -macros query (1 replies)
  166. [SOLVED:] GetElementsByClassName With IE8 (3 replies)
  167. [SOLVED:] Consolidate spreadhseets (1 replies)
  168. Filtercopy does not return records listed with criteria value below 7 characters (7 replies)
  169. savecopyas in event (1 replies)
  170. Check 2 column and Combine Data (0 replies)
  171. [SOLVED:] Call Sub in module from userform (5 replies)
  172. [SOLVED:] VBA conditional formatting (9 replies)
  173. Excel VBA - Delete last row containing data (4 replies)
  174. [SOLVED:] Updating sheet with data from another sheet (6 replies)
  175. Help on Shell and Class module (1 replies)
  176. Excel VBA - vLook-Up if match first 2 characters of one column with another column (3 replies)
  177. Copy range of cells between workbooks with same named sheets (1 replies)
  178. Varible help? (5 replies)
  179. Move various duplicate rows to new sheet (3 replies)
  180. Using Min() in VBA (3 replies)
  181. [SOLVED:] Transfer values from sheet to textbox (4 replies)
  182. [SOLVED:] Finding non-zero minimum in a dynamic array (6 replies)
  183. search for data and delete rows containing it (1 replies)
  184. [SOLVED:] compare date in number and product (4 replies)
  185. [SOLVED:] Automating Date Entry (9 replies)
  186. [SOLVED:] Open CSV File Automatic Separating Comma (2 replies)
  187. VBA to change column to row and store the result in new column (4 replies)
  188. VBA Change ODBC Connection String (Excel) (7 replies)
  189. [SOLVED:] range copy with paste (4 replies)
  190. [SOLVED:] In a workbook in several sheets - each sheet several macro at once (3 replies)
  191. [SOLVED:] Find vs Match (9 replies)
  192. [SOLVED:] how to copy the visible cells of a table to another tab? (4 replies)
  193. [SOLVED:] Access records via Excel VBa between dates (12 replies)
  194. Is it possible to display information from 3 cells side by side in a single cell? (3 replies)
  195. Run time error 424 (2 replies)
  196. I Need Help Vba Code Automatically Sort Rows Largest To Smallest (7 replies)
  197. [SOLVED:] Function data type issue (12 replies)
  198. Copying & pasting the Data from Multiple sources to corresponding multiple destinatio (1 replies)
  199. Closing Excel when UserForm closed (only if not an admin) (4 replies)
  200. vba excel populate textbox into listbox (3 replies)
  201. Barcode Scanner Excel Lookup (2 replies)
  202. Select multiple worksheets using list contained in worksheet (4 replies)
  203. [SOLVED:] Automatically sum cell values from new sheets (that are not created yet) (3 replies)
  204. [SLEEPER:] Extracting Image information using Data Modified from Folders & Subfolders (1 replies)
  205. [SOLVED:] Referece to Formulas R1C1 (8 replies)
  206. [SOLVED:] time calculation problem (5 replies)
  207. [SOLVED:] Removing web address references / placing ... on a cell after 397 characters. (6 replies)
  208. [SOLVED:] Macros - dates in a column and display months in another column (2 replies)
  209. find and move the duplicate values in another sheet (3 replies)
  210. [SOLVED:] Automatically give new sheet name (created frm template w/macro) the value of a cell (14 replies)
  211. Help for transferring the raw computation to Excel VBA in financial situation (0 replies)
  212. [SOLVED:] Check sheet1 Copy duplicate items rows on sheet2 to sheet3 (4 replies)
  213. Can not run VBA use data from other excel file (10 replies)
  214. Need Help For Excel VBA Coding Convert to Addins (or) dll (1 replies)
  215. Filter specific data to a new workbook (6 replies)
  216. [SOLVED:] Merge and Combine data (1 replies)
  217. [SOLVED:] Delete File In Use error (5 replies)
  218. [SOLVED:] Please help with my ListBox (10 replies)
  219. [SOLVED:] Export and import CSV Date format proble in Excel2010 (3 replies)
  220. I Need Eidt Code Copy And Paste (7 replies)
  221. Setting print area and borders. (5 replies)
  222. [SOLVED:] UnProtect al files in a folder (2 replies)
  223. Opening Excel Automatically (3 replies)
  224. Updating Access from Excel UF (7 replies)
  225. VBA and NumberFormat (2 replies)
  226. [SOLVED:] Footers question in VBA (1 replies)
  227. [SOLVED:] What to do with my Excel .xml file (3 replies)
  228. [SOLVED:] Macro in 2003 works, in 2010 doesnt work (part 2) (4 replies)
  229. vba macro code for finding the common entry names (0 replies)
  230. [SOLVED:] Replace Cell Date with text (4 replies)
  231. Excel 2003 Macro, no longer working in 2010 (4 replies)
  232. [SOLVED:] Find and replace question (6 replies)
  233. Combo Box Data Validation Macro (5 replies)
  234. Simple excel macro help required (1 replies)
  235. Using vba to populate data into a master workbook (1 replies)
  236. Use of operators in Text Boxes inconsistent? (21 replies)
  237. [SOLVED:] Working With Subset Of Data (2 replies)
  238. [SOLVED:] Using a Variable in creating a Validation List (2 replies)
  239. date falls on monday display the date of saturday (4 replies)
  240. Combine macros (3 replies)
  241. [SOLVED:] Search all open workbook and if find the match data , clean the cell on Column A (11 replies)
  242. advanced replace macro (7 replies)
  243. [SOLVED:] Remove the limitation 65536 rows (4 replies)
  244. [SOLVED:] Handling Strings with seperators (2 replies)
  245. [SOLVED:] MID Formula help - when last digit value is 0 (3 replies)
  246. [SOLVED:] Unable to use Validation (10 replies)
  247. Fill in between the points on a scatter plot (0 replies)
  248. Worksheet to find values of a sheet and copy the column (1 replies)
  249. if find the matched data in another workbook copy the complete row (15 replies)
  250. Overflow error. (4 replies)