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. [SOLVED:] ASSISTANCE NEEDED PLEASE. If..Then.. ElseIf statement that loops. (1 replies)
  2. Add row if text is not identical to above cell (2 replies)
  3. VBA Extract Matching Data from Worksheet Named Range (2 replies)
  4. How to add an Pop-up message (6 replies)
  5. Trying to return value deep within the Locals window (8 replies)
  6. Making key binds to vba userform buttons (0 replies)
  7. Import large text file. Please help me to fix this code. (1 replies)
  8. [SOLVED:] Non-Contiguous columns in multiple workbooks into New Workbook - Efficiency? (9 replies)
  9. Loop thru excel workbook and send sheets not working (2 replies)
  10. [SOLVED:] Run-time Error 1004 (2 replies)
  11. Code to be used for all the ranges in the column (4 replies)
  12. [SOLVED:] Copy pivot table and paste it in to next available column in same sheet (9 replies)
  13. Split on cell into various rows with VBA (5 replies)
  14. [SOLVED:] Combine data in two column if sum of column is same (4 replies)
  15. [SOLVED:] Changing the Value of the ComboBox (1 replies)
  16. How to fast read/write Excel VBA array contents to and from text file! (3 replies)
  17. How to fast read/write Excel VBA array contents to and from text file! (0 replies)
  18. Sleeper: VBA Best practice (0 replies)
  19. [SOLVED:] Custom Object Self-referential Events (16 replies)
  20. [SOLVED:] Help with Worksheet_Change (6 replies)
  21. Loop through every auto filter drop down, copy result cell and paste to another sheet (8 replies)
  22. variable email title in outlook while sending in vba (1 replies)
  23. Autofilter with more than two criteria (11 replies)
  24. Extract data from between two dates.. (3 replies)
  25. Macro / VBA help for a complete newbie, please? Auto-delete data/helper cell (0 replies)
  26. Extracting data from a table (0 replies)
  27. Help With a Sub (12 replies)
  28. [SOLVED:] Issue with Basic If statement code to change data in a column (4 replies)
  29. Loop help (3 replies)
  30. For Each digit in a multi-digit number (0 replies)
  31. Copy Cell Color to Another Cell & Changing Graph Color to Match Cell Color (18 replies)
  32. Enabling Macro to Active When Multiple Cells In Column Change (2 replies)
  33. VBA, Looping directory with calculation Error. (0 replies)
  34. [SOLVED:] Macro copy & paste into new sheet if condition is met? (6 replies)
  35. [SOLVED:] Specific formulas not working in Loop_all_files_in_folder macro (1 replies)
  36. Email through excel from lotus notes 9 (4 replies)
  37. VBA Files "clashing" (0 replies)
  38. [SOLVED:] input msg error when "Cancel" button is clicked -- (3 replies)
  39. Loop thru sheet and send emails (0 replies)
  40. Remove bits from a byte (3 replies)
  41. [SOLVED:] find "w" instance in column and count within range then change the next "Daily" val. (20 replies)
  42. [SOLVED:] Passing variables from userform to normal module based on command button clicked (7 replies)
  43. Need to generate ID when pulling files from shared folder (0 replies)
  44. Add new project number to user form (1 replies)
  45. Need assistance in the code (0 replies)
  46. VBA to collate information from 3 workbooks into one Ranked Table using filter (0 replies)
  47. [Help]Export ListBox contents to new workbook via CommandButton! (2 replies)
  48. [SOLVED:] vba array into combobox userform (10 replies)
  49. Using Option button in userform (3 replies)
  50. Compile Error Regarding If Statement (4 replies)
  51. Help with "dim as" (5 replies)
  52. The query did not run, or the database table could not be opened (1 replies)
  53. [SOLVED:] Help With Option Buttons in VBA UserForm (4 replies)
  54. [SOLVED:] Userform Appearence (2 replies)
  55. Help With Applying Numeral Limitations in VBA Forms (10 replies)
  56. VBA auto copy-paste from Excel to Word works but no source formatting! (3 replies)
  57. Run-time error '438': Object doesn't support this property or method. (5 replies)
  58. Sending Text to an existing Batch Script to be used as variables (Encoding) (5 replies)
  59. [SOLVED:] Is there a way to add music by vba code? (0 replies)
  60. Tagging Type based on Criteria in the file (12 replies)
  61. [SOLVED:] VBA Userform Issue (4 replies)
  62. Copy Hyperlink from Image to Text (3 replies)
  63. Consolidating Multiple With Statements to Run Faster (25 replies)
  64. [SOLVED:] Convert-Calculate and Convert Again (20 replies)
  65. Simple VBA macro - move cells, pull data from adjacent cell (1 replies)
  66. form question (3 replies)
  67. VBA code required to delete Right click menu over SHAPES (1 replies)
  68. [SOLVED:] Name Manager question (2 replies)
  69. [SOLVED:] Show Message Box for Limited Time Period before continuing with remainder of code (12 replies)
  70. [SOLVED:] VBA Function - Portfolio Volatility using Co-variance Matrix (4 replies)
  71. Formula Last Cell value in row but placed in the same column (6 replies)
  72. [SOLVED:] Recording data from outlook to an open spreadsheet (2 replies)
  73. Closing workbook without close button (13 replies)
  74. [SLEEPER:] RecordSet in Excel VBA (2 replies)
  75. [SOLVED:] Exclude Dir dot & dotdot from listbox (4 replies)
  76. Related to Thread: Colour Entire Row Base on the Value of Two Other Cells in Excel (1 replies)
  77. [SOLVED:] PivotTable Error (2 replies)
  78. Verifying emails have been sent (1 replies)
  79. Extracting ContentControl Data from a Word Doc into an Excel Sheet for analyzing (3 replies)
  80. Dynamic form question (0 replies)
  81. VBA Code to deploy plots (0 replies)
  82. VBA/ Call Function and sum from different sheets (0 replies)
  83. Finding Alpha Numeric in string and delete row (4 replies)
  84. [SOLVED:] Simple VBA code to calculate ColumnWidth (7 replies)
  85. Dynamic Linked Ranges (Format & Content) (0 replies)
  86. Combining Data from Multiple Tables & Refreshable (1 replies)
  87. [SOLVED:] Recursive File Search (2 replies)
  88. Macro/vba to merge data (2 replies)
  89. copy data and paste to different sheet (0 replies)
  90. Monitoring Emails Sent From VBA (2 replies)
  91. finding variations in the data base (4 replies)
  92. [SOLVED:] Combining of data (0 replies)
  93. [SLEEPER:] Auto Hyperlinking VBA that auto matches? (1 replies)
  94. Extend the dates and compare the date with other rows (5 replies)
  95. [SOLVED:] Iterate Sheets In Workbook (2 replies)
  96. Unique positioning of data on excel (2 replies)
  97. [SOLVED:] Loop autofilter through multiple combinations, calculate and paste (14 replies)
  98. Import Picture With Same Dimensions As Picture Already On Sheet (2 replies)
  99. [SOLVED:] Copy down if font = bold (4 replies)
  100. Copy and paste data from one worksheet to another with a unique criteria (5 replies)
  101. Excel Addin (1 replies)
  102. [SOLVED:] Columnheads does not display in listbox! (4 replies)
  103. automatic macro initiation under conditions (1 replies)
  104. Compare the values in the column and display the results in another column (4 replies)
  105. [SOLVED:] Copy From 1 Workbook To Others (3 replies)
  106. [SOLVED:] VBA No Longer Enabled for XLA or XLAM (6 replies)
  107. [SOLVED:] Write and Read on cmd with VBA (4 replies)
  108. [SOLVED:] Macro to segregate data in different sheet with some criteria (0 replies)
  109. Sleeper: Script remove the toolbar from excel (0 replies)
  110. Image Embedded ? How to access (1 replies)
  111. VBA to open list of hyperlinks in non-default browser? (4 replies)
  112. Update Row with Visible cells in Column (0 replies)
  113. MACRO Help (1 replies)
  114. Help finding Table after text in Word Document (0 replies)
  115. [SLEEPER:] Code to automatically generate new worksheet (6 replies)
  116. [SOLVED:] HLOOKUP not in all columns or something else? (1 replies)
  117. Copy specific worksheets to a new workbook and save based on Assoc name (4 replies)
  118. Finding a Search String in Multiple Sheets and copying Rows to a new sheet (6 replies)
  119. Macro to split one file into many based on criteria !!! (11 replies)
  120. [SOLVED:] budget calendar, help handeling February date overlaps (10 replies)
  121. so my data starts on row 7 (headers row 6)....i first filter for "M" in column B then (1 replies)
  122. Open excel template in existing workbook (2 replies)
  123. Extracting data from word to excel (2 replies)
  124. [SOLVED:] formula to calculate difference between 2 days excluding weekend or other holidays (15 replies)
  125. Hide/ unhide specific number of cells in a known range. (4 replies)
  126. [SOLVED:] Macro to Segregate values from cell and copy paste (4 replies)
  127. [SOLVED:] calculate date after 34 days and if attended clinic (10 replies)
  128. How to copy a picture from Excel to word (2 replies)
  129. [SOLVED:] Retreive row numbers back into userform (4 replies)
  130. [SOLVED:] Button action invoking specific cells (7 replies)
  131. Excel VBA nested if statements (5 replies)
  132. File Multi - User password (4 replies)
  133. Unable to set the visible property of the pivot item class (1 replies)
  134. [SOLVED:] Loop to next different range (2 replies)
  135. End time button gets Inactive when workbook closed and reopened (5 replies)
  136. Calender control (8 replies)
  137. run-time error 91 (1 replies)
  138. [SOLVED:] Help with Sentence Case (17 replies)
  139. VBA clearing cells based on a selection (3 replies)
  140. [SOLVED:] Produce a word doc for each unique record in a worksheet (18 replies)
  141. Scrape data from HTML/Javascript dynamic tables using VBA (0 replies)
  142. VBA Find (5 replies)
  143. Filter using VBA (9 replies)
  144. [SOLVED:] SQL Query giving crazy results when executre from VBA ( Excel ) (6 replies)
  145. [SOLVED:] Searching for duplicates in column (5 replies)
  146. Excel VBA to tick a checkbox in the website if condition are met. (1 replies)
  147. Search multiple columns in another Workbook for value (25 replies)
  148. Looping through a range and assigning the row # to a variable when found (1 replies)
  149. Delete Workbook_Open code before Saving (0 replies)
  150. Drop Down list Show/hide rows (3 replies)
  151. copy cells with just text not the formulas (2 replies)
  152. Current dates in cells C2:U65000 when values in cells range A2:A65000 changes (7 replies)
  153. Delete Rows that meet a Criteria (1 replies)
  154. vba code to find row base on some conditions without using a loop or filter (3 replies)
  155. Excel exceeding maximum number of connections to outlook (3 replies)
  156. Rolling Average in VBA with multiple columns (7 replies)
  157. [SOLVED:] Exporting Multiple Sheets as Excel & PDF (7 replies)
  158. Ontime vba opens another workbook that is not requested (42 replies)
  159. Square to link (5 replies)
  160. [SOLVED:] xlsm or xltm file extension (4 replies)
  161. Before Print Issue (2 replies)
  162. Breaking out a pivot table to new workbooks (6 replies)
  163. Copy fields from workbooks to a master workbook (2 replies)
  164. repetative code (11 replies)
  165. [SOLVED:] Offscreen print (3 replies)
  166. If Statements in VBA (3 replies)
  167. [SOLVED:] Conditional Formatting with three criteria (2 replies)
  168. VBA to Test Outcomes of Drop Down Selections (4 replies)
  169. [SOLVED:] Finding last row with data to send Mass Email (4 replies)
  170. [SOLVED:] All of code is not being executed (1 replies)
  171. error 1004 unable to get pastespecial property of range class (6 replies)
  172. [SOLVED:] Find values within strings from a predefined list (6 replies)
  173. [SOLVED:] [Excel VBA] Run-time Error 91 : Object variable or With block variable not set (0 replies)
  174. [SOLVED:] Advance Filter Criteria (3 replies)
  175. Poor display in listbox (4 replies)
  176. copying row + 1 row above and copying row + 1 row below (6 replies)
  177. [SOLVED:] Colour Entire Row Base on the Value of Two Other Cells (75 replies)
  178. Complicated Macro Help Required! (4 replies)
  179. [SOLVED:] Excel Macro - Copying data from one workbook to another (16 replies)
  180. filter response (convolution) (6 replies)
  181. Replacing text in the formula in one part of a worksheet (1 replies)
  182. For Existing and New files: CREATE & UPDATE file on different USB drives (6 replies)
  183. [SOLVED:] Search String in Text Files (6 replies)
  184. [SOLVED:] ExportAsFixedFile Error (3 replies)
  185. Looking for a way to export sheet with pictures/shapes (0 replies)
  186. [SOLVED:] Storing wav files in a workbook. (7 replies)
  187. [SOLVED:] Delete First Duplicate Row (2 replies)
  188. [SOLVED:] Excel VBA Automation with the use of .BAT File - Task Scheduling your work (9 replies)
  189. Maclaurin Series (4 replies)
  190. [SOLVED:] Returning Row number in data sort (4 replies)
  191. [SOLVED:] Re-arrange a columns data without sorting. (7 replies)
  192. [SOLVED:] Symbol - VBA reference - Need help! (2 replies)
  193. Unable to capture all the rows (2 replies)
  194. [SOLVED:] Copy matching data from many workbooks to summary workbook (6 replies)
  195. Problems with formatting a scatter chart using macros (0 replies)
  196. How to delete each empty row in a spreadsheet (20 replies)
  197. [SOLVED:] Excel VBA Code to Open a .txt file and loop through every single words (5 replies)
  198. [SOLVED:] Delete Cell contents when data is added to another cell within a range (7 replies)
  199. [SOLVED:] Extracting Date from a string of Text - VBA Coding Help (5 replies)
  200. Lookup from unique data (2 replies)
  201. VBA help! drop down selected - copy and paste data (7 replies)
  202. [SOLVED:] hide, unprotect, unhide, protect (15 replies)
  203. [SOLVED:] Merge Excel Files in Folder into Bottom of Current Worksheet (5 replies)
  204. Find seven columns that come before last column. (1 replies)
  205. [SOLVED:] Saving Selection Ranges on difrant sheets as One PDF (7 replies)
  206. Saving Excel Selection as A PDF document (5 replies)
  207. [SOLVED:] appear pictures in userform (17 replies)
  208. [SOLVED:] Set Integer to a Value (2 replies)
  209. How to concatenate several cells (4 replies)
  210. interpolation (4 replies)
  211. External Links - How to remove user name? (5 replies)
  212. Log date time and user (6 replies)
  213. [SOLVED:] Copy Paste Data from Sheet 1 to Sheet 2 (12 replies)
  214. Excel Userform VBA code to submit to worksheet (3 replies)
  215. [SOLVED:] Excel to return looked up values from drop down list? (8 replies)
  216. add/fix vba reference (5 replies)
  217. Editing text in a SmartArt shape via a drop-down list (3 replies)
  218. [SOLVED:] Summing growing range (4 replies)
  219. [SOLVED:] Need help with a loop (6 replies)
  220. VBA : SEARCHING problem (12 replies)
  221. [SOLVED:] Create different file (3 replies)
  222. [SOLVED:] Macro Autofill with Loop and Delay (2 replies)
  223. Saving Worksheet as PDF (1 replies)
  224. Excel Addin Compatibility Problems with 2013, Invisible ActiveX Control (2 replies)
  225. VBA Code to Rename Folders (25 replies)
  226. [SOLVED:] Hide Unhide with a twist (2 replies)
  227. VBA Excel 2010 - interact with a website done in java (0 replies)
  228. Web selector (2 replies)
  229. VBA web warning messages (0 replies)
  230. [SOLVED:] Finding Duplicate in Long Numbers (17 replies)
  231. [SOLVED:] how to save excel sheet in a text file? (3 replies)
  232. HELP_Excel chart with X and Y values in the same series. (0 replies)
  233. [SOLVED:] Set an object as the outlook inbox (9 replies)
  234. Increase range size by one cell each run (1 replies)
  235. [SOLVED:] Delete Duplicate data (4 replies)
  236. Temp Lock Workbook while form data is submitted to worksheet (0 replies)
  237. [SOLVED:] Macro to copy data based on criteria - Percentage - For sampling (35 replies)
  238. USERFORM COMPLICATED (5 replies)
  239. [SOLVED:] Copying Formulas into a range where blanks exist. (8 replies)
  240. eliminate part of formula via macro (1 replies)
  241. Search for multiple values (4 replies)
  242. VBA USERFORM : listbox show data only ID selected (3 replies)
  243. VBA vertical major grid lines do not want to format as stated below (0 replies)
  244. Extract xml elements from mutiple urls into Excel (1 replies)
  245. [SOLVED:] XIRR Problem (7 replies)
  246. close MAPI session using VBA (0 replies)
  247. Referencing location based on Cell data (4 replies)
  248. Smoothing data (1 replies)
  249. Search and match data from multiple workbooks (8 replies)
  250. Using XMLHTTP to upload a file to API (12 replies)