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. Help Converting Early Binding to Late Binding VBA Code (5 replies)
  2. Refine code to combine multiple CSV files into single workbook (7 replies)
  3. [SOLVED:] Search Matched File Names in Col A - Import the Text in Col B (4 replies)
  4. [SOLVED:] sorting data by cell value (2 replies)
  5. [SOLVED:] Filtered List - loop through only counting "visible" rows based on Criteria (3 replies)
  6. Close excel file if open (2 replies)
  7. Sleeper: VBA for copy from one sheet to another (1 replies)
  8. Conditional Formatting static “Applies To:” field (0 replies)
  9. Conditional Formatting static “Applies To:” field (0 replies)
  10. How to find if a date exists within 30 days of other dates in a date range in Excel (7 replies)
  11. [SOLVED:] Create an Hyperlink if cell value and file name match (6 replies)
  12. [SOLVED:] VBA compare two columns and list cells that match and the ones that don't (6 replies)
  13. Copy And Past On To Next Empty Row (6 replies)
  14. [SOLVED:] Unload all userforms except main userform (6 replies)
  15. VBA: Pulling data from files in the folder & skipping already processed ones (2 replies)
  16. VBA to export images from cells to a folder with a specific name (MSO 2011 or 2016) (3 replies)
  17. [SOLVED:] For loop for different userform (2 replies)
  18. Data Validation List generating with VBA getting 1004 error (3 replies)
  19. VBA coding program (2 replies)
  20. infinite series for the sine using VBA command button and input boxes (3 replies)
  21. Button updates cells with Spin Button (3 replies)
  22. VBA to download Crystal Reports (0 replies)
  23. Efficient way to run sub if change via slicer is detected (0 replies)
  24. BeforeDoubleClick trouble (2 replies)
  25. [SOLVED:] Extract Word into Next Row From DataSet - From Searching WordList In Another Sheet (4 replies)
  26. [SOLVED:] Copying data to a specific location, not last available empty row (6 replies)
  27. [SOLVED:] Issue with the Auto Run Macro under Workbook Open (3 replies)
  28. unable to set the formulaarray property of the range class - IF AND (2 replies)
  29. [SOLVED:] Count Rows EntireColum one Shot in VBA CountA IsNumber, IsEmpty, Istext, HasFormulas (5 replies)
  30. VBA/Macro Help: Copy and Paste x rows above, then find and replace, repeat (1 replies)
  31. Merge similar rows... (6 replies)
  32. VBA Send Email From Excel Spreadsheet (5 replies)
  33. [SOLVED:] Loop through all rows with data not just first row (2 replies)
  34. [SOLVED:] Question about Pivot Tables and Filtering Functionality (3 replies)
  35. [SLEEPER:] Filter data to another sheet with VBA calculation (1 replies)
  36. Excel VBA text file parsing help (5 replies)
  37. [SOLVED:] Dividing a column by a range of numbers (2 replies)
  38. Disconnect Slicers without using slicer name. (1 replies)
  39. EXCEL VBA SHAPE OBJECT, BUTTON, WORKSHEET HELP (2 replies)
  40. Multiple Spreadsheet data combined into one, and then again output into one workbook (0 replies)
  41. Change cells value base on other cell value by worksheet event (2 replies)
  42. Creating two lists from Multiple Columns (5 replies)
  43. Macro Subcript Out of Range Error 9 Due to Worksheet Names have a Space (6 replies)
  44. [SOLVED:] Center text vertically inside a combo box or textbox (1 replies)
  45. Excel VBA UserForm TxtBox Calulations (4 replies)
  46. VBA dilemma - Passing Variable from Input box (1 replies)
  47. [SOLVED:] Thousands and Decimal Separator Check (9 replies)
  48. [SOLVED:] Concatenate multiple cells by vba (2 replies)
  49. Userform field changes not detected when userform invoked from userform (7 replies)
  50. [SOLVED:] Find and rename Table in Workbook if it is present (6 replies)
  51. Help Keeping a running tally (5 replies)
  52. Can files residing on a slow network cause VBA to 'skip'? (4 replies)
  53. [SOLVED:] Hyperlink to Files in Directory - Filter for Specific File Types ONLY to link to (4 replies)
  54. VBA Code to Loop, Find Missing Data and Perform Calculation (8 replies)
  55. How do I set/get a range from a certain cell to the last row in that same column (2 replies)
  56. [SOLVED:] Save Application Current States. Recall them when needed. (Rescue Workbook) (6 replies)
  57. [SLEEPER:] How to run the VB in all Excel Files (0 replies)
  58. Error VBA in Excel 64-bits (6 replies)
  59. Copying from 1 Workbook and multisheets to Another Workbook and multisheets (7 replies)
  60. Print all invoices macro (1 replies)
  61. [SLEEPER:] Range SpecialCells Union LastRow (18 replies)
  62. [SOLVED:] Cant delete contents of a cell ... VBA issue (5 replies)
  63. [SLEEPER:] Copy to next cell blank (2 replies)
  64. Find and rename Column Header using VBA (3 replies)
  65. Copy & Pasting in VBA (5 replies)
  66. Sum by Colour Vba clarification please (8 replies)
  67. [SOLVED:] Protect/Unprotect (2 replies)
  68. Is it possible to automatically create a "Microsoft equation" from an excel formula? (3 replies)
  69. Error 430 - C# .dll - Reference VBA (4 replies)
  70. Grab file size from URL (7 replies)
  71. [SOLVED:] VBE Line continuation for Range definition (5 replies)
  72. [SOLVED:] Lock cell after macro got runed (12 replies)
  73. VBA MS Excel MySQL Connection with ODBC (1 replies)
  74. [SOLVED:] Look up in three columns (3 replies)
  75. [SOLVED:] Application.EnableCancelKey not working (3 replies)
  76. Lost Data formatting (7 replies)
  77. Gather emails from used range in sheet (0 replies)
  78. [SOLVED:] vba macro to run multiple macros in multiple workbooks (2 replies)
  79. Help with object shape name and colour (2 replies)
  80. VBA Work Sheet As Work Book Run Time Error (7 replies)
  81. Main characters to merge with Sub-characters in record (4 replies)
  82. [SOLVED:] Count number of dates mentioned more than 10 times in a column (4 replies)
  83. Trouble with Input Box (2 replies)
  84. Data form displays incorrect date format. (1 replies)
  85. [SLEEPER:] ReadProcessMemory - With a Base Adress + Pointers (9 replies)
  86. [SOLVED:] Blanks in Formula Treated as Zero's (8 replies)
  87. VBA new row based on last row and input box (4 replies)
  88. Outlook to Excel (7 replies)
  89. Dynamic hyperlink to folder Path problems (4 replies)
  90. [SOLVED:] Compare one worksheet to multiple worksheets (2 replies)
  91. [SOLVED:] What is yellow dot parameter of a shape VBA (8 replies)
  92. Translating Excel formula into VBA code (14 replies)
  93. excel workbook pulls data from another excel workbook (3 replies)
  94. Running a subroutine every half hour up to 5 times (5 replies)
  95. VBA Macros Help - NPV (3 replies)
  96. COPY FROM WORD TO EXCEL (1 replies)
  97. [SOLVED:] Macro for copying multiple cells from one worksheet to another (8 replies)
  98. [SOLVED:] Vba+Excel - Pivot tables and Dynamic range (10 replies)
  99. [SOLVED:] (PDF VBA and Excel) export cover sheet w/ a loop, attach spec sheet from local drive. (17 replies)
  100. Macro enabled file will not open in Office 365 (1 replies)
  101. [SOLVED:] Deleting rows on filter (4 replies)
  102. Help - Run-time error '9': Subscript out of range (3 replies)
  103. [SOLVED:] Save sheet - New copy - Modify code witout formulas (1 replies)
  104. Run time error '13' Type mismatch (3 replies)
  105. Run time error '13' type mismatch (2 replies)
  106. Bypass "Enable content" (2 replies)
  107. VBA : Help on Filtered Range (3 replies)
  108. Save each sheet as a text file (1 replies)
  109. timesheet Out of Hours enhanced payment values (8 replies)
  110. Trouble with pulling data from offline workbooks (2 replies)
  111. [SOLVED:] Copy/select specific row to last row (3 replies)
  112. Dynamic hyperlink in VBA (4 replies)
  113. [SOLVED:] Autofit inconsistent (5 replies)
  114. [SOLVED:] Excel VB to open an XML as read only (3 replies)
  115. [SLEEPER:] Why blanco lines after a copy ? (2 replies)
  116. Change macro to move rows to worksheets in all workbooks in a folder (4 replies)
  117. excel document problem (4 replies)
  118. VBA Loop problem (2 replies)
  119. Find the first cell in a column by criteria and replace with combobox value (3 replies)
  120. Web Automation (Excel+VBA) - Help checking element in table (0 replies)
  121. stop errors on a user form (2 replies)
  122. [SOLVED:] Rookie Question: Three Columns - Total, Sub-Total, Calculate Percentage...? (9 replies)
  123. [SOLVED:] getting the error "91 object variable or with block variable not set" (7 replies)
  124. how to make general range (4 replies)
  125. Formula Index, Match and Partial Match four columns (2 replies)
  126. Excel Send Rows of Data to Different Email Addresses Based upon Cell Values (2 replies)
  127. [SLEEPER:] Opening A Working Book and Using Copy & Paste (1 replies)
  128. Input Box and Msg box Help (1 replies)
  129. [SOLVED:] change row format to show 0 as first symbol (4 replies)
  130. [SOLVED:] Help with formula (5 replies)
  131. Save Sheet As New Work Book (6 replies)
  132. [SOLVED:] Help with code (2 replies)
  133. Header info on excel list (8 replies)
  134. Looking For A Programmer (1 replies)
  135. Make report summary using VBA arrays (5 replies)
  136. Tracking Changes to a worksheet using VBA (2 replies)
  137. Data validation query (6 replies)
  138. [SOLVED:] Move Up or Down A Rows Using VBA (4 replies)
  139. Need to correct a VLOOKUP/ INDIRECT combo formula (6 replies)
  140. [SOLVED:] VBA to assign & then access a workbook a variable (7 replies)
  141. [SLEEPER:] How to unzip files? (2 replies)
  142. compare value from notepad with value in excel (1 replies)
  143. [SOLVED:] picture not load after time sometimes (3 replies)
  144. Automatically determines what shift is working based on time (3 replies)
  145. Take a text string (user input) field and resolve/parse to use defined abbrevations (18 replies)
  146. Reformatting Images in Merged Cells (4 replies)
  147. How to extract zip files by looping through folders (5 replies)
  148. Combo Box Data Validation Macro not working (0 replies)
  149. VBA to save .xml file from selected Columns (2 replies)
  150. [SOLVED:] Reset data validation drop-down list via VBA linked button (4 replies)
  151. Highlight some of the cells in a row (3 replies)
  152. How can I do this differently and faster (9 replies)
  153. Allow copy and paste only (0 replies)
  154. Macro for Splitting Information Contained Within a Column (4 replies)
  155. [SOLVED:] Data lost when sending file as attachment (1 replies)
  156. [SOLVED:] compare workbooks version number (2 replies)
  157. Emailing Named Ranges Using VBA (6 replies)
  158. [SOLVED:] automatic E-mail using Arrays in VBA (2 replies)
  159. VBA IF STATEMENT HELP (0 replies)
  160. How to Merge/ Combine , three worksheets ? (13 replies)
  161. Reformat string (2 replies)
  162. autonumber a string within a cell (6 replies)
  163. Comparing 6 coloumn and highlighting the difference (3 replies)
  164. [SOLVED:] Expand rows automatically based on grouped rows (3 replies)
  165. Macro which auto runs when every excel workbook is opened (5 replies)
  166. save and Merge PDFs From Excel (2 replies)
  167. [SOLVED:] Search for files with ending ".csv" in a folder and work on it (5 replies)
  168. [SOLVED:] My first excel VBA project (5 replies)
  169. VBA help (0 replies)
  170. [SOLVED:] Change "Selection.CurrentRegion.Select" so macro captures cols A-Q, non-contiguous (9 replies)
  171. [SOLVED:] Reformat data in specific way (5 replies)
  172. [SOLVED:] VBA Vlookup Reflect Data to TextBox1 (12 replies)
  173. Dim - Compile Error: Syntax Error (4 replies)
  174. Use Bookmark To Fill in Word Document From Excel Data (8 replies)
  175. Vlookup or Index/Match code to find the value (5 replies)
  176. VBA code to find fraudulent activity in data (25 replies)
  177. Pattern Style (1 replies)
  178. Make custom formula with VBA's (11 replies)
  179. [SOLVED:] Trigger event when pressing F12 (3 replies)
  180. [SOLVED:] Multiple URL's to Get External Data (19 replies)
  181. Plot a AREA in a X,Y scatter plot (3 replies)
  182. Copy the entire row if the value in column R is greater than 1 and insert above (3 replies)
  183. How to transfer userform data to two diffirent sheets in diffirent cells? (0 replies)
  184. how to display Unicode Hindi characters into combobox from mysql database (4 replies)
  185. Macro to copy selected cells in a row and paste into new sheet at specified locations (2 replies)
  186. [SOLVED:] Move an excel file to another folder (7 replies)
  187. Copy single row from multiple workbooks to one main sheet (12 replies)
  188. read contents of pdf (1 replies)
  189. Run-Time Error '1004': Method 'HasRoutingSlip' of object '_Workbook' failed (1 replies)
  190. [SOLVED:] Disbale Shift Key on workbook Open (14 replies)
  191. VBA Delete for Shapes Range Very Slow (30 replies)
  192. [SOLVED:] Multiply two matrices (5 replies)
  193. [SOLVED:] join an merge cells in column A but at same time the same rows in columns B and C (20 replies)
  194. Excel 2007 3d animation engine - Tutorials (2 replies)
  195. Userform Help (2 replies)
  196. Interactive maps (4 replies)
  197. Open and Link Spreadsheet Using VBA (0 replies)
  198. Combine all text files from multiple folders into one worksheet (38 replies)
  199. Partial String Search cross sheet reference (12 replies)
  200. Comparing 2 Workbooks AND Their Worksheets (14 replies)
  201. [SOLVED:] Copy and paste data from a source file to destination file. (2 replies)
  202. Delete duplicate rows (3 replies)
  203. .Click in IE only works every few attempts (0 replies)
  204. "The Master" ,The one Book that rules them "ALL." (0 replies)
  205. [SLEEPER:] Need help with VBA Error (22 replies)
  206. RT Error 424 - Object Required, when UNIONing 2 ranges in order to sync 2 columns (13 replies)
  207. [SOLVED:] Help with a difficult sort (7 replies)
  208. [SOLVED:] Help with formula please (7 replies)
  209. [SOLVED:] Seperate unique accounts and manipulate data (4 replies)
  210. Duplicate value removal across sheets and rows and columns IN A FILE (2 replies)
  211. [SOLVED:] How to write last row update record in excel into txt file ? (6 replies)
  212. [SOLVED:] Highlighting every other row containing data (8 replies)
  213. [SOLVED:] Adding more drop down list with my macro? (6 replies)
  214. Opening and Saving spreadsheet (1 replies)
  215. [SOLVED:] IF statments with weekday (2 replies)
  216. [SOLVED:] Importing file with date that changes daily (10 replies)
  217. [SOLVED:] Rename Files By Adding Last Modified Date (19 replies)
  218. Encrypt Decrypt Excel cells/ colums (7 replies)
  219. calculating time display when the macro is running (the time is a lot while calcule) (2 replies)
  220. how to search the next value in excel (3 replies)
  221. VBA to centre range of images in cells (1 replies)
  222. Extracting resume data from word to excel (2 replies)
  223. delete text from word (1 replies)
  224. Get the shape's RGB value (4 replies)
  225. Separating data with VBA (8 replies)
  226. Problem with MkDir (4 replies)
  227. Sleeper: Lotus Email Attachments, How to better Optimize my Code? (0 replies)
  228. [SOLVED:] Using Countif formula in vb (7 replies)
  229. Use KB shortcut keys to return a value from a range (2 replies)
  230. transfer data from excel to word (7 replies)
  231. Remove Duplicates and Replace Content Cell (3 replies)
  232. Caculate Distance between 2 points on x y scatter plot chart (3 replies)
  233. [SOLVED:] How to save as txt file name depend on current date and time (1 replies)
  234. [SOLVED:] Using autofilter to loop and count visible cells (2 replies)
  235. [SLEEPER:] Macro flickering (15 replies)
  236. Macro(s) for importing txt-file (0 replies)
  237. Send data from excel with API (XMLHTTP in VBA) (4 replies)
  238. Please help _table update (6 replies)
  239. Copy and paste not working for macro (1 replies)
  240. Freeze one cell after data is entered (16 replies)
  241. [SOLVED:] Wanting to change the range in a Macro (4 replies)
  242. multiple times same control wit same function after click (5 replies)
  243. Easy Excel Formula Problem (4 replies)
  244. Whats wrong with my code, copy paste does not change Array formula (30 replies)
  245. VBA Excel - Macro simple - help needed (2 replies)
  246. [SOLVED:] Using VBA SUMIF with multiple conditions (5 replies)
  247. Designating Master file to excel (3 replies)
  248. Create ppt from Excel using macros (7 replies)
  249. email sending (1 replies)
  250. [SOLVED:] random unique images (4 replies)