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. IF and Then range based upon number rather than string - code inside. Help! (4 replies)
  2. [SOLVED:] Insert New Row issue...doesn't work when the worksheet is protected (16 replies)
  3. offset one row (1 replies)
  4. vba to clear values in an excel pivot table (1 replies)
  5. Importing from Web problems (0 replies)
  6. loop not working for next file in same folder (3 replies)
  7. Import data from Word to Excel - School Assignment (1 replies)
  8. [SOLVED:] Extracting Home Value Estimates from Website (4 replies)
  9. Copy unique column values to a new column in a different worksheet (2 replies)
  10. [SOLVED:] Combine All Workbooks from One Folder to One Master file (15 replies)
  11. In an excel sheet some column cells are blank then corresponding blank cell (3 replies)
  12. Gradation - Quantile Performence (18 replies)
  13. 32x to 64x error (4 replies)
  14. Deleting ony those rows in excell sheet in which entire row cell is blank . (1 replies)
  15. Output Required Horizontally in Excel Sheet separated each by semi colon. (1 replies)
  16. [SOLVED:] VBA to filter a column starting at row 2 to Lastrow (17 replies)
  17. [SOLVED:] Please help with Array comparison to trigger email (7 replies)
  18. [SOLVED:] Parsing XML Help (2 replies)
  19. Pass Sheet Range to a SelectionChange Event (15 replies)
  20. [SOLVED:] Add default Outlook e-mail signature with Excel without displaying e-mail first (7 replies)
  21. Search and Paste (0 replies)
  22. In a cell Vertically entered mobile number , I want to extract all mobile number. (4 replies)
  23. Filtering multiline data prior to dumping into cell (0 replies)
  24. vba subtract time from date (4 replies)
  25. [SOLVED:] Problem with code (2 replies)
  26. how to track precedents and dependents. (0 replies)
  27. Function that uses a variable number of arguments (8 replies)
  28. [SOLVED:] CheckCompatibility statment (2 replies)
  29. CreateObject("InternetExplorer.Application") (8 replies)
  30. VBA Data from an access database using a variable (2 replies)
  31. [SOLVED:] AfterUpdate not triggered (3 replies)
  32. [SOLVED:] VBA to sum data on another worksheet (1 replies)
  33. Table Changing Name After Macro (1 replies)
  34. [SOLVED:] entries in column A (4 replies)
  35. [SOLVED:] Set default value of combo box (7 replies)
  36. VBA With Excel to Merge PDF Based on Filename Oldest to Newest (0 replies)
  37. Help Needed: Listing Files & Folders-VBA Coe Error (0 replies)
  38. Please help me with (0 replies)
  39. [SLEEPER:] Adding subfolders into routine (4 replies)
  40. HELP WITH MACRO PROBLEM (3 replies)
  41. Macro to copy Codes in rows when Criteria's are met (0 replies)
  42. Pass value from excel to IE form (1 replies)
  43. [SOLVED:] How to get my macro to click a button in a dialog (2 replies)
  44. [SOLVED:] Delete all data on sheet except certain range (9 replies)
  45. [SOLVED:] How do I combine two statements in Excel? (1 replies)
  46. SCHEDULE help please (7 replies)
  47. Search external file for a value then print each row of data found using VBA (0 replies)
  48. pass data from excel to web form (0 replies)
  49. [SOLVED:] Running a macro based on a list (8 replies)
  50. Looping through txt file and returning a section to excel (9 replies)
  51. [SOLVED:] Update code for inserting data in all closed file in folder (1 replies)
  52. Web Browser Automation: favorite all items on page, move to next page (2 replies)
  53. [SLEEPER:] Hyperlinks created on sheet (not VBA) work for some users but not others - Any Reason (1 replies)
  54. Overlap Dates (0 replies)
  55. Variable type change for XValues in charted data (0 replies)
  56. [SOLVED:] Formatting a date in word document from excel using VBA (2 replies)
  57. Excel crashes during VBA cell copy (3 replies)
  58. HELP: Find, Filter, copy and then send mail from outlook (1 replies)
  59. How to find available rows, columns and bits from matrix definition in spreadsheet (1 replies)
  60. Splitting a cell with "/" delimeter and use first part as new line heading (1 replies)
  61. Cut/Paste data, code only works on first 4 rows (1 replies)
  62. Excel to Email with Attachment (1 line only at a time with button push) (11 replies)
  63. [SOLVED:] Copy data from sheet to a table (object) (2 replies)
  64. [SOLVED:] Inserting non default signature with picture in Outlook e-mail (3 replies)
  65. Navigate in an application thanks to VBA (0 replies)
  66. [SOLVED:] named range tracking via VB (10 replies)
  67. [SOLVED:] Trying to delete cells with specific terms, Runtime 424 Object Required error (12 replies)
  68. another code apart from ( target.address) (9 replies)
  69. [SOLVED:] Need help integrating checkboxes into existing (simple) macro (2 replies)
  70. export to txt file (3 replies)
  71. [SOLVED:] How to replace/move data from ons sheet into a workbook in a specific sheet. (4 replies)
  72. Sample post so I can look at some code (0 replies)
  73. incorporating Bank Holiday into formula (9 replies)
  74. Populate a list box with worksheet names (2 replies)
  75. MsgBox Display Offset Value (1 replies)
  76. Need help fixing a VBA code to show the correct date when time is being converted. (18 replies)
  77. [SOLVED:] Macro Button Color (4 replies)
  78. difference between (2 replies)
  79. Personal.xlsb ..... or ? (5 replies)
  80. Sum Column B based on Column A and format it (2 replies)
  81. [SOLVED:] Macro to Create Individual Workbook and Remove Colors (2 replies)
  82. Incremental numbers with a special format (12 replies)
  83. Miror margins (11 replies)
  84. Downloading pdf using vba, IS IT POSSIBLE? (2 replies)
  85. Scrape data Using getElementsbyTagName NOT WORKING (0 replies)
  86. String comparison and highlight... a bit different requirement. (6 replies)
  87. How do I disable a macro button if file name is a date? (4 replies)
  88. Alternative to copy / paste (2 replies)
  89. Fill in form on website and submitting multiple values in new tabs (1 replies)
  90. Importing data tables from the WEB (2 replies)
  91. [SOLVED:] How to speed up my macro? (2 replies)
  92. [SLEEPER:] Make Tiny URL link of hyperlink in cell (2 replies)
  93. [SOLVED:] Automate - manual made macro (22 replies)
  94. [SOLVED:] Combining workbooks with varying names (8 replies)
  95. Choices from User Form (1 replies)
  96. Log in on a website thanks to VBA (1 replies)
  97. VBA code is not working in win7_64 (6 replies)
  98. [SOLVED:] Copy Current Row and paste to the next couple hundred rows (2 replies)
  99. Excel 2002 to Excel 2013 (5 replies)
  100. [SOLVED:] Start Looping Through Range from the Middle (4 replies)
  101. VBA code of Excel 2013 is not working in Excel 2010 (5 replies)
  102. VBA Macro Progress Message (0 replies)
  103. Calculating elapsed time between starting and closing excel (6 replies)
  104. HELP - Code not working (My old boss has retired and this was his code) (1 replies)
  105. Quick Help with adding "MSG Box" into code (1 replies)
  106. User cannot select items in a Listbox (3 replies)
  107. Type mismatch error, code previously worked (2 replies)
  108. Help Importing XML files - VBA (1 replies)
  109. VBA Mails workbook as attachment - need to remove path from filename (5 replies)
  110. Find row number of maximum value found in a given column? (1 replies)
  111. VBA copy data to matching workbook (12 replies)
  112. [SLEEPER:] VBA Error Referencing Excel Spreadsheet (7 replies)
  113. MULTIPLE PDF TO SINGLE EXCEL WITH OVERWRITE (1 replies)
  114. Tool to automatically feed database (2 replies)
  115. VBA Error Referencing Spreadsheet (2 replies)
  116. slowdown in performance when I write the result of the macro in cell (5 replies)
  117. [SOLVED:] Store individual cell contents in arrays, match terms and highlight when found (5 replies)
  118. [SLEEPER:] Need help with this review problem (4 replies)
  119. Need help with homework problem (1 replies)
  120. Extract string from multiple files using vba (5 replies)
  121. Loop through worksheet and create a new column based on cell values in another column (2 replies)
  122. [SOLVED:] Need some help pls. How to color cell A if cell B is an even number (4 replies)
  123. VBA to do something 5 times then go back (5 replies)
  124. Copy random numbers and sort. (2 replies)
  125. Need a formula to show the cell coordinates (2 replies)
  126. Model cell colours (0 replies)
  127. Audit Log - track changes to all cells in a workbook (0 replies)
  128. Userform Help - Adding more than one record. (5 replies)
  129. Vlookup in vba for dynamic range on data (0 replies)
  130. How to catch the duplicate number in excel (1 replies)
  131. [SOLVED:] My filter by Invoice number skipping part of code (1 replies)
  132. MACRO or VBA Required (26 replies)
  133. Lock Cells after date passed - VBA Code (9 replies)
  134. [SOLVED:] Software Library from .nessus files (13 replies)
  135. [SOLVED:] Macro to update columns depending on row identifier (5 replies)
  136. How to email a pivot table using VBA (4 replies)
  137. [SOLVED:] Extracting data in "Treeview" from web using VBA (2 replies)
  138. Putting a Variable into a formula (2 replies)
  139. [SOLVED:] catching malformed data before sub runs (4 replies)
  140. [SOLVED:] Using VBA to rename files - from Auotgenerated microscope to multiple array location. (4 replies)
  141. Use ShellExecute to do a programmatic string search in an opened PDF file (9 replies)
  142. Help with Importing Part of a text readable file into Excel worksheet via Macro (2 replies)
  143. Use SaveAs to create new workbook (2 replies)
  144. Using worksheet function randbetween for non-contiguous number ranges (6 replies)
  145. [SLEEPER:] Help Calculating averages based on options selected in user form (7 replies)
  146. Delete row based on 3 conditions (3 replies)
  147. Import MS Project to Excel 2000 (5 replies)
  148. Help switching between two images (1 replies)
  149. VBA to override all upcoming code for certain users?? (2 replies)
  150. VBA old test question help (1 replies)
  151. How to concatenate ComboBox name (4 replies)
  152. Quick VBA Rows Question (4 replies)
  153. GPIB to USB Controller (1 replies)
  154. [SOLVED:] Running multiple VBA functions within one sub (2 replies)
  155. Auto fill Cells Down if other cells have information (1 replies)
  156. [SOLVED:] Method 'Open of object 'Workbooks'Failed (3 replies)
  157. [SOLVED:] Else without If statement compiling error (2 replies)
  158. [SOLVED:] help needed with Vlookup and IF function (32 replies)
  159. Prevent user edits to a workbook without making the workbook dirty (7 replies)
  160. [SOLVED:] HELP -- Hyperlink Question (18 replies)
  161. [SOLVED:] Transpose Nested Data (3 replies)
  162. 3DES encryption using VBA (0 replies)
  163. Need to match every reference in sheet 2 column A for a match in Sheet 1 Column A (2 replies)
  164. Download files from URL, unknown file names (20 replies)
  165. [SOLVED:] Simple Date to Text Conversion (3 replies)
  166. VBA:comboboxes to present same date in different formats...ADAPT WITH CHANGE IN DATE (1 replies)
  167. [SOLVED:] Preventing VBA converting cell value to date when printing as .txt (5 replies)
  168. Save As button using VBA Code (7 replies)
  169. ListBox size issue (3 replies)
  170. How to Optimize 6 nested loop coding in VBA. (0 replies)
  171. [SOLVED:] Add password to togglebutton code? (3 replies)
  172. [SOLVED:] Worksheet change code (18 replies)
  173. Tidy up old verbose coding (0 replies)
  174. userform not behaving properly (3 replies)
  175. [SOLVED:] VBA FollowHyperlink (31 replies)
  176. Hire Help (0 replies)
  177. Colour pattern matching (10 replies)
  178. [SOLVED:] How To Write A Macro To Compare Active Row With Specific Columns In Above Row (20 replies)
  179. To Trigger an Event based on Certain Time and Certain Date (19 replies)
  180. Delete row with same ID but if found B2B-111 in column C of that ID. (10 replies)
  181. Fill Online Application - Acknowlegement number not generated (4 replies)
  182. [SOLVED:] filling combobox's issue (2 replies)
  183. Closing a program without killing other workbooks / "Wait please" pop up window (3 replies)
  184. UDF To Concatenate (9 replies)
  185. Challenging VBA Web scraping coding (0 replies)
  186. [SOLVED:] Toggle cell value on single click (6 replies)
  187. VBA macro to delete all empty rows and columns (1 replies)
  188. Converting an Excel macro to run from Word (2 replies)
  189. google translator vba code stop working (3 replies)
  190. Saving Excel 97-2002 file to Excel 2013 warning about Script Objects (1 replies)
  191. [SOLVED:] Make specific text bold in cells (5 replies)
  192. adapting number code to incorporate () - - (0 replies)
  193. change code to incorporate other textboxes (0 replies)
  194. [SOLVED:] Go To Previous Worksheet / Go To Next Worksheet {Problem} (16 replies)
  195. [SOLVED:] regular expression in excel (10 replies)
  196. Multi-Dimensional Array Sort (2 replies)
  197. Pasting a function to be in edit mode in a cell in excel (0 replies)
  198. [SLEEPER:] Importing all outlook folders to excel using VBA (0 replies)
  199. [SOLVED:] copy cell value from one workbook to another based on two criterias (21 replies)
  200. [SOLVED:] Preserve line breaks when inserting/pasting into a single Excel cell (7 replies)
  201. Run Java code for web page via VBA (1 replies)
  202. Saving information from the user form (3 replies)
  203. 2nd time a freefile is opened, exception is thrown (2 replies)
  204. VBA UserForm: Updating Existing Data (0 replies)
  205. [SOLVED:] Vlookup a text and MsgBox it thanks to VBA (9 replies)
  206. [SLEEPER:] Scatterplot Illustration Help (1 replies)
  207. [SLEEPER:] Re-indexing Excel Sheets (0 replies)
  208. [SOLVED:] Help, loop finds overlaps, then adds not overlapped items, but misses the first match (2 replies)
  209. [SOLVED:] Date value error, need help (3 replies)
  210. [SOLVED:] Print Array (17 replies)
  211. [SOLVED:] Is necessary "Set Object = Nothing" (3 replies)
  212. Exel Power View worksheet (0 replies)
  213. Userform Filter Search (1 replies)
  214. Day/Time difference VBA (1 replies)
  215. Add Chart to constantly changing stats table (2 replies)
  216. Transfer data from one list box to another in a userform (1 replies)
  217. Combobox from one form filters another combobox in another form (0 replies)
  218. Select Cells based on values in another cell (2 replies)
  219. When/why does the VBIDE remember/forget its window state/position? (0 replies)
  220. boolean variable (1 replies)
  221. variable counter (1 replies)
  222. Specific Sheets Very Hidden (2 replies)
  223. [SOLVED:] Hide rows based on multiple criteria (5 replies)
  224. Running Macros in other Spreadsheets (2 replies)
  225. Adding a search box to an Excel sheet using VBA (very novice) (2 replies)
  226. [SOLVED:] Exporting Data to .txt - Need Help Setting Directory! (0 replies)
  227. Multiple Pivot Generation (0 replies)
  228. [SLEEPER:] Run-time error '6': Overflow (0 replies)
  229. Create a dialogue prompt to filter down data? (0 replies)
  230. loop through cells (2 replies)
  231. Help with worksheet and workbook objects (1 replies)
  232. How do I mark my post as 'SOLVED'? (1 replies)
  233. "Subscript out of range" ... Issue (3 replies)
  234. VBA Macro Summary Sheet (1 replies)
  235. [SOLVED:] Dynamically modify Chart source data? (5 replies)
  236. Compare values between 2 tables (8 replies)
  237. Decreasing time by 1 hour (3 replies)
  238. Private Sub Worksheet_Calculate() - Not running when workbook opens (4 replies)
  239. [SOLVED:] Setting ranges that could change in VBA (3 replies)
  240. VBA Download File From Link (0 replies)
  241. Mismatch error (0 replies)
  242. [SOLVED:] Copy a block of lines/rows and paste to another worksheet (24 replies)
  243. Selecting dynamic range in Excel VBA (4 replies)
  244. [SOLVED:] Network days in VBA Calculation (0 replies)
  245. [SOLVED:] VLOOKUP Workbook Reference Asking For Data Updates (3 replies)
  246. [SOLVED:] working code inside - need to add a delete the row after the data has been copied (2 replies)
  247. [SOLVED:] How to put Cursor in text box and move to next text box? (2 replies)
  248. Excel - Sort data after report refresh and certain cell changes? (0 replies)
  249. [SOLVED:] Adding range values to email (2 replies)
  250. Formula excel Combining to cells (13 replies)