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. Two-Way Editable Links Over Different Worksheet (0 replies)
  2. [SOLVED:] Change Long Date to Short (8 replies)
  3. macro does not run (4 replies)
  4. VBA code to generate letters in one cell (14 replies)
  5. Multiple criteria comparing (5 replies)
  6. [SOLVED:] Checking a Range for a Value, If another cell has a specific value (11 replies)
  7. [SOLVED:] Changing tab colors based on a list of tabs and cell value (3 replies)
  8. Making a Histogram (Grade Distribution) (0 replies)
  9. Extract and Recombine Multivalue Path Parts Using RegEx UDF (0 replies)
  10. [SOLVED:] trying to build an array from a userform listbox (7 replies)
  11. VBA code to delete row that meets certain condition (3 replies)
  12. [SOLVED:] auto filter blanks (1 replies)
  13. [SOLVED:] Check string length (1 replies)
  14. Updates on Vlookup/VBA regarding scan components (6 replies)
  15. Excel Formula for the below conditions (3 replies)
  16. Making an Auxiliary Table For Grade Distibution (17 replies)
  17. [SOLVED:] Highlight Cell Based on Number of Times its Value changes (5 replies)
  18. VBA code to fill in a combo-box of an IE site linked from another IE site (5 replies)
  19. DELETE COLUMS (2 replies)
  20. [SOLVED:] Some incorrect results from a formula (1 replies)
  21. User Form textbox mismatch (2 replies)
  22. User Form help (2 replies)
  23. Use of Indirect or other method to pass data between sheets (1 replies)
  24. [SOLVED:] Formula Help (3 replies)
  25. [SOLVED:] my old code is strange today (3 replies)
  26. Auto Picture Insert in Excel 2007 (25 replies)
  27. [SOLVED:] Text outcome coming out reversed (4 replies)
  28. Excel Macro to make Bloomberg refresh Data? (1 replies)
  29. Excel to return looked up values from drop down list? (9 replies)
  30. Sum Alphanumeric (Multiple selection) (0 replies)
  31. [SOLVED:] Hiding Rows from a Function (11 replies)
  32. Ned help with vba error (9 replies)
  33. VBA to import excel data in word document (1 replies)
  34. Internet Explorer VBA Automation - Help with one issue needed (1 replies)
  35. Mscomm32 (using Netcomm) reading issue with USB to serial comport (1 replies)
  36. Protecting a Sheet But Allowing Certain Features (1 replies)
  37. [SOLVED:] How to Speed up Code without Excel falling down - EXCL 2013 (34 replies)
  38. sumif criteria based on cell color (3 replies)
  39. Applying If statement to string (1 replies)
  40. Linking a textbox to a worksheet sub (17 replies)
  41. Textbox number of digits allowed (3 replies)
  42. [SLEEPER:] Code to Force Macros Not working WHEN extended (0 replies)
  43. Solved (0 replies)
  44. Help with ComboBox In userform (10 replies)
  45. Extract files as a object into excel from folder path (11 replies)
  46. [SOLVED:] Next without For Compile Error (3 replies)
  47. Match values from different columns (1 replies)
  48. Reconciliation Macro Help (5 replies)
  49. [SOLVED:] Sum a range across multiple Worksheets (5 replies)
  50. [SOLVED:] Calculate time spent in each job role. (12 replies)
  51. [SOLVED:] rearranging the rows and columns (5 replies)
  52. Find cells containing A two letter string by itself (5 replies)
  53. [SOLVED:] Advanced filter help (4 replies)
  54. VBA color index (4 replies)
  55. Count checked fieldform and content control boxes from word using excel (1 replies)
  56. [SOLVED:] Attempting to extract 3 column listbox values after adding new row (2 replies)
  57. [SOLVED:] Change a worksheet's code name to Sheet1 (6 replies)
  58. Need help in aligning data in different rows (7 replies)
  59. Identifying Object that initiated VBA sub-routine (2 replies)
  60. Creating a Folder in Sharepoint, if it does not already exist from an excel userform (1 replies)
  61. [SOLVED:] Calculated field in Pivot help (2 replies)
  62. [SOLVED:] Worksheet Activation and Change issues (6 replies)
  63. Reading data from one spreadsheet into another using VBA (1 replies)
  64. code does run too slaow and too long (8 replies)
  65. VBA: Detect whether Office 365 subscription or purchased Office version (14 replies)
  66. Loop through code, move across a columns (2 replies)
  67. [SOLVED:] Change macro to produce PDF's instead of workbooks (3 replies)
  68. Sleeper: VBA Saving a Word Document with a reference to an Excel Cell (1 replies)
  69. [SOLVED:] Macro from this pseudo code? (5 replies)
  70. [SOLVED:] Worksheet change event help (10 replies)
  71. VBA code to run other macros (3 replies)
  72. Vba Code for data set passed with each press of a button. (4 replies)
  73. [SOLVED:] Delete Scooby (Shape) (4 replies)
  74. Match and statements in sheets (5 replies)
  75. VBA to block black filled cells as sheet updated (2 replies)
  76. Excel cell value as string won't store (2 replies)
  77. Sum problem help for a novice (2 replies)
  78. Interaction on Child IE Window (0 replies)
  79. Running macros on files on SharePoint Server (4 replies)
  80. Decode vertical text file to horizontal text file (8 replies)
  81. Highlight Row Based on Cell Value (1 replies)
  82. VBA Transpose every 4th row, loop until empty column (1 replies)
  83. Use VBA to output file automatically (1 replies)
  84. [SOLVED:] Range Selection Then apply formula with third column over (4 replies)
  85. VBA code problem with random numbers generations (25 replies)
  86. [SOLVED:] How to trim a string from both sides? (3 replies)
  87. VBA second half repeats twice (3 replies)
  88. Input Box to Sort by row (1 replies)
  89. [SOLVED:] Copy Rows and Paste Values (5 replies)
  90. Code to select current open workbooks under ComboBox n Userform (0 replies)
  91. Find the Max of s Subset within a Subset (2 replies)
  92. Help with worksheet loop (15 replies)
  93. Find the duplicate and create a pivot using VBA (0 replies)
  94. Copy & Paste to new sheet if cell contains data? (4 replies)
  95. VBA using IF to populate msgbox (4 replies)
  96. runtime error 13 (2 replies)
  97. Sleeper: Code not deleting shape (0 replies)
  98. [SOLVED:] Modify code to look for certain sheetnames (0 replies)
  99. Merging multiple excel file into one (4 replies)
  100. [SOLVED:] ASSISTANCE NEEDED PLEASE. If..Then.. ElseIf statement that loops. (1 replies)
  101. Add row if text is not identical to above cell (2 replies)
  102. VBA Extract Matching Data from Worksheet Named Range (2 replies)
  103. How to add an Pop-up message (6 replies)
  104. Trying to return value deep within the Locals window (8 replies)
  105. Making key binds to vba userform buttons (0 replies)
  106. Import large text file. Please help me to fix this code. (1 replies)
  107. [SOLVED:] Non-Contiguous columns in multiple workbooks into New Workbook - Efficiency? (9 replies)
  108. Loop thru excel workbook and send sheets not working (2 replies)
  109. [SOLVED:] Run-time Error 1004 (2 replies)
  110. Code to be used for all the ranges in the column (4 replies)
  111. [SOLVED:] Copy pivot table and paste it in to next available column in same sheet (9 replies)
  112. Split on cell into various rows with VBA (5 replies)
  113. [SOLVED:] Combine data in two column if sum of column is same (4 replies)
  114. [SOLVED:] Changing the Value of the ComboBox (1 replies)
  115. How to fast read/write Excel VBA array contents to and from text file! (3 replies)
  116. How to fast read/write Excel VBA array contents to and from text file! (0 replies)
  117. Sleeper: VBA Best practice (0 replies)
  118. [SOLVED:] Custom Object Self-referential Events (16 replies)
  119. [SOLVED:] Help with Worksheet_Change (6 replies)
  120. Loop through every auto filter drop down, copy result cell and paste to another sheet (8 replies)
  121. variable email title in outlook while sending in vba (1 replies)
  122. Autofilter with more than two criteria (11 replies)
  123. Extract data from between two dates.. (3 replies)
  124. Macro / VBA help for a complete newbie, please? Auto-delete data/helper cell (0 replies)
  125. Extracting data from a table (0 replies)
  126. Help With a Sub (12 replies)
  127. [SOLVED:] Issue with Basic If statement code to change data in a column (4 replies)
  128. Loop help (3 replies)
  129. For Each digit in a multi-digit number (0 replies)
  130. Copy Cell Color to Another Cell & Changing Graph Color to Match Cell Color (18 replies)
  131. Enabling Macro to Active When Multiple Cells In Column Change (2 replies)
  132. VBA, Looping directory with calculation Error. (0 replies)
  133. [SOLVED:] Macro copy & paste into new sheet if condition is met? (6 replies)
  134. [SOLVED:] Specific formulas not working in Loop_all_files_in_folder macro (1 replies)
  135. Email through excel from lotus notes 9 (4 replies)
  136. VBA Files "clashing" (0 replies)
  137. [SOLVED:] input msg error when "Cancel" button is clicked -- (3 replies)
  138. Loop thru sheet and send emails (0 replies)
  139. Remove bits from a byte (3 replies)
  140. [SOLVED:] find "w" instance in column and count within range then change the next "Daily" val. (20 replies)
  141. [SOLVED:] Passing variables from userform to normal module based on command button clicked (7 replies)
  142. Need to generate ID when pulling files from shared folder (0 replies)
  143. Add new project number to user form (1 replies)
  144. Need assistance in the code (0 replies)
  145. VBA to collate information from 3 workbooks into one Ranked Table using filter (0 replies)
  146. [Help]Export ListBox contents to new workbook via CommandButton! (2 replies)
  147. [SOLVED:] vba array into combobox userform (10 replies)
  148. Using Option button in userform (3 replies)
  149. Compile Error Regarding If Statement (4 replies)
  150. Help with "dim as" (5 replies)
  151. The query did not run, or the database table could not be opened (1 replies)
  152. [SOLVED:] Help With Option Buttons in VBA UserForm (4 replies)
  153. [SOLVED:] Userform Appearence (2 replies)
  154. Help With Applying Numeral Limitations in VBA Forms (10 replies)
  155. VBA auto copy-paste from Excel to Word works but no source formatting! (3 replies)
  156. Run-time error '438': Object doesn't support this property or method. (5 replies)
  157. Sending Text to an existing Batch Script to be used as variables (Encoding) (5 replies)
  158. [SOLVED:] Is there a way to add music by vba code? (0 replies)
  159. Tagging Type based on Criteria in the file (12 replies)
  160. [SOLVED:] VBA Userform Issue (4 replies)
  161. Copy Hyperlink from Image to Text (3 replies)
  162. Consolidating Multiple With Statements to Run Faster (25 replies)
  163. [SOLVED:] Convert-Calculate and Convert Again (20 replies)
  164. Simple VBA macro - move cells, pull data from adjacent cell (1 replies)
  165. form question (3 replies)
  166. VBA code required to delete Right click menu over SHAPES (1 replies)
  167. [SOLVED:] Name Manager question (2 replies)
  168. [SOLVED:] Show Message Box for Limited Time Period before continuing with remainder of code (12 replies)
  169. [SOLVED:] VBA Function - Portfolio Volatility using Co-variance Matrix (4 replies)
  170. Formula Last Cell value in row but placed in the same column (6 replies)
  171. [SOLVED:] Recording data from outlook to an open spreadsheet (2 replies)
  172. Closing workbook without close button (13 replies)
  173. RecordSet in Excel VBA (2 replies)
  174. [SOLVED:] Exclude Dir dot & dotdot from listbox (4 replies)
  175. Related to Thread: Colour Entire Row Base on the Value of Two Other Cells in Excel (1 replies)
  176. [SOLVED:] PivotTable Error (2 replies)
  177. Verifying emails have been sent (1 replies)
  178. Extracting ContentControl Data from a Word Doc into an Excel Sheet for analyzing (3 replies)
  179. Dynamic form question (0 replies)
  180. VBA Code to deploy plots (0 replies)
  181. VBA/ Call Function and sum from different sheets (0 replies)
  182. Finding Alpha Numeric in string and delete row (4 replies)
  183. [SOLVED:] Simple VBA code to calculate ColumnWidth (7 replies)
  184. Dynamic Linked Ranges (Format & Content) (0 replies)
  185. Combining Data from Multiple Tables & Refreshable (1 replies)
  186. [SOLVED:] Recursive File Search (2 replies)
  187. Macro/vba to merge data (2 replies)
  188. copy data and paste to different sheet (0 replies)
  189. Monitoring Emails Sent From VBA (2 replies)
  190. finding variations in the data base (4 replies)
  191. [SOLVED:] Combining of data (0 replies)
  192. Auto Hyperlinking VBA that auto matches? (1 replies)
  193. Extend the dates and compare the date with other rows (5 replies)
  194. [SOLVED:] Iterate Sheets In Workbook (2 replies)
  195. Unique positioning of data on excel (2 replies)
  196. [SOLVED:] Loop autofilter through multiple combinations, calculate and paste (14 replies)
  197. Import Picture With Same Dimensions As Picture Already On Sheet (2 replies)
  198. [SOLVED:] Copy down if font = bold (4 replies)
  199. Copy and paste data from one worksheet to another with a unique criteria (5 replies)
  200. Excel Addin (1 replies)
  201. [SOLVED:] Columnheads does not display in listbox! (4 replies)
  202. automatic macro initiation under conditions (1 replies)
  203. Compare the values in the column and display the results in another column (4 replies)
  204. [SOLVED:] Copy From 1 Workbook To Others (3 replies)
  205. [SOLVED:] VBA No Longer Enabled for XLA or XLAM (6 replies)
  206. [SOLVED:] Write and Read on cmd with VBA (4 replies)
  207. [SOLVED:] Macro to segregate data in different sheet with some criteria (0 replies)
  208. Sleeper: Script remove the toolbar from excel (0 replies)
  209. Image Embedded ? How to access (1 replies)
  210. VBA to open list of hyperlinks in non-default browser? (4 replies)
  211. Update Row with Visible cells in Column (0 replies)
  212. MACRO Help (1 replies)
  213. Help finding Table after text in Word Document (0 replies)
  214. [SLEEPER:] Code to automatically generate new worksheet (6 replies)
  215. [SOLVED:] HLOOKUP not in all columns or something else? (1 replies)
  216. Copy specific worksheets to a new workbook and save based on Assoc name (4 replies)
  217. Finding a Search String in Multiple Sheets and copying Rows to a new sheet (6 replies)
  218. Macro to split one file into many based on criteria !!! (11 replies)
  219. [SOLVED:] budget calendar, help handeling February date overlaps (10 replies)
  220. so my data starts on row 7 (headers row 6)....i first filter for "M" in column B then (1 replies)
  221. Open excel template in existing workbook (2 replies)
  222. Extracting data from word to excel (2 replies)
  223. [SOLVED:] formula to calculate difference between 2 days excluding weekend or other holidays (15 replies)
  224. Hide/ unhide specific number of cells in a known range. (4 replies)
  225. [SOLVED:] Macro to Segregate values from cell and copy paste (4 replies)
  226. [SOLVED:] calculate date after 34 days and if attended clinic (10 replies)
  227. How to copy a picture from Excel to word (2 replies)
  228. [SOLVED:] Retreive row numbers back into userform (4 replies)
  229. [SOLVED:] Button action invoking specific cells (7 replies)
  230. Excel VBA nested if statements (5 replies)
  231. File Multi - User password (4 replies)
  232. Unable to set the visible property of the pivot item class (1 replies)
  233. [SOLVED:] Loop to next different range (2 replies)
  234. End time button gets Inactive when workbook closed and reopened (5 replies)
  235. Calender control (8 replies)
  236. run-time error 91 (1 replies)
  237. [SOLVED:] Help with Sentence Case (17 replies)
  238. VBA clearing cells based on a selection (3 replies)
  239. [SOLVED:] Produce a word doc for each unique record in a worksheet (18 replies)
  240. Scrape data from HTML/Javascript dynamic tables using VBA (0 replies)
  241. VBA Find (5 replies)
  242. Filter using VBA (9 replies)
  243. [SOLVED:] SQL Query giving crazy results when executre from VBA ( Excel ) (6 replies)
  244. [SOLVED:] Searching for duplicates in column (5 replies)
  245. Excel VBA to tick a checkbox in the website if condition are met. (1 replies)
  246. Search multiple columns in another Workbook for value (25 replies)
  247. Looping through a range and assigning the row # to a variable when found (1 replies)
  248. Delete Workbook_Open code before Saving (0 replies)
  249. Drop Down list Show/hide rows (3 replies)
  250. copy cells with just text not the formulas (2 replies)