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:] Pass the range from userform to sub of module (2 replies)
  2. [SOLVED:] HELP!! GETTING MULTIPLE VARIANTS INTO ONE RANGE!!!! (1 replies)
  3. RUNTIME 13: TYPE MISMATCH ERROR (2 replies)
  4. Inset formula into last cell of table column (3 replies)
  5. [SOLVED:] HARD:MADE A FUNCTION - HOW DO I LOOP THAT FUNCTION IN MY SUBROUTINE???? (8 replies)
  6. VBA loop copy & paste range to same worksheet name of another workbook (1 replies)
  7. VLookup VBA Code & Elseif troubles (13 replies)
  8. Ranking with conditions (2 replies)
  9. [SOLVED:] Copy/Paste Loop is only transferring rows 1,2, and 4, but not row 3? (6 replies)
  10. Copying spreadsheet into 120 sub-folders (3 replies)
  11. How to Merge Two Worksheet_Change Codes (6 replies)
  12. VBA Help - Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range' (2 replies)
  13. [SOLVED:] Using an array to transfer file names into workbook with multiple sheets (8 replies)
  14. Select case using a collection of values (1 replies)
  15. [SLEEPER:] VBA - Seperating Column data based on Criteria..... (4 replies)
  16. Insert Two Blank Row if Condition Met (5 replies)
  17. [SOLVED:] FINDING LAST ROW IN COLUMN NOT WORKING (4 replies)
  18. Replace multiple repeated texts in multiple word documents from excel with excel vba (2 replies)
  19. Pull data from overall sheet to new sheet based on criteria (8 replies)
  20. Run-Time Error 13 (4 replies)
  21. Modifying COMport Code (3 replies)
  22. VBA - Unhiding a Worksheet and setting Sheet1 as current view (1 replies)
  23. Transferring Data from Multipage Userform to Separate, Subsequent Rows in Excel (14 replies)
  24. VBA - Merging and Bordering of cells if condition met.... (6 replies)
  25. [SOLVED:] Protected cells - want to enable comments (4 replies)
  26. Copying an active range (4 replies)
  27. [SOLVED:] Sending Email Drafts from secondary outlook email account (1 replies)
  28. VBA from access to excel (1 replies)
  29. XLSX-XML Conversion through Macro (0 replies)
  30. Add rows to existing table (0 replies)
  31. Show Sheets which have links to other sheets (0 replies)
  32. XLSX to XML Macro (0 replies)
  33. Force Excel Macro With Some Sheets Remain Hidden (3 replies)
  34. Excel Macro Copying Information From Many Folders (9 replies)
  35. [SOLVED:] Saving Current Worksheet as Text in Current Directory (20 replies)
  36. [SOLVED:] Listing Conditional Formatting on Separate Sheet or Workbook (1 replies)
  37. Help Creating Macro for Selection, copying ranges (2 replies)
  38. Converting countif to frequency (2 replies)
  39. Restructuring of data without a standardized format (1 replies)
  40. [SOLVED:] RUN TIME ERROR FOR A VARIANT! DONT KNOW MY MISTAKE HELP (6 replies)
  41. Number of days inventory held (2 replies)
  42. Hide / Unhide Rows and Columns based on selected cell value (drop-down) (9 replies)
  43. [SOLVED:] ADDING A SHEET USING VBA BUT GETTING ERROR (2 replies)
  44. Update data from one sheet to another sheet with header mapping (2 replies)
  45. [SOLVED:] HELP GETTING DIMENSIONS OF A VARIANT ARRAY (2 replies)
  46. Excel VBA UserForm not working. Need help pls! (4 replies)
  47. VBA to copy paste data in Master File........and adjust row as per data size.. (9 replies)
  48. [SOLVED:] Find string in multiple rows (17 replies)
  49. Search for Numbers (2 replies)
  50. [SOLVED:] Source and target cells specification in a macro (2 replies)
  51. match cells based on a string provided (2 replies)
  52. Macros to highlight three or more consecutive numbers entered in a set row (1 replies)
  53. [SOLVED:] Event Handler for external DLL events not triggering (8 replies)
  54. Need help writng macro to insert Spanish accented characters into a line of text (6 replies)
  55. [SOLVED:] Log to generate tracking numbers (4 replies)
  56. MULTIPLE FIND AND REPLACE FROM USERFORM INPUT (3 replies)
  57. Need to delete a workbook (34 replies)
  58. Heading Row Returns NULL (11 replies)
  59. insert sum or =+ formula based on value in another column for variable rows (1 replies)
  60. [SOLVED:] loop thru every sheet and filter out a specific name and create a new sheet (9 replies)
  61. Listbox.Column (2 replies)
  62. [SOLVED:] VBA to provide search data from text box value (15 replies)
  63. insert sum formulas based on worksheet data (8 replies)
  64. [SOLVED:] Extract Matching Cell Values in Two Columns and Paste in New Columns (22 replies)
  65. [SOLVED:] DATE VALIDATION IN TEXTBOX (2 replies)
  66. Find specific cell and insert page break - repeat till end of sheet (2 replies)
  67. [SOLVED:] automating calculations and adding to existing table (7 replies)
  68. [SOLVED:] Match code is not returning the desired field (3 replies)
  69. How do I check values on 4 columns simultaneously on two different workbook? (0 replies)
  70. Extract data from string to new sheet (2 replies)
  71. VB Code Help " Error Variable not Defined " and Run time Error "438"" (2 replies)
  72. Map cells based on text (3 replies)
  73. run time error '9' subscript out of range (5 replies)
  74. [SOLVED:] URGENT! GETTING DATA FROM ONE WORKBOOK TO ANOTHER USING VARIANT (2 replies)
  75. [SOLVED:] TABLE OF CONTENTS NOT USING TABS (6 replies)
  76. Based on Cell value, from next cell has to move to 2nd row (4 replies)
  77. [SOLVED:] RUNTIME 13: TYPE MISMATCH ERROR (3 replies)
  78. Filter and sum the column values (4 replies)
  79. List (Sort by) Birthday Anniversaries in .txt file (1 replies)
  80. Move to right column after return when I press enter (3 replies)
  81. vba import data from another workbook with auto filtered of specified name (7 replies)
  82. [SOLVED:] Calling a function (4 replies)
  83. Combining three different tables in a chart (0 replies)
  84. Sleeper: Can anyone help me with this code ? (14 replies)
  85. Need Help to modify this Macro (5 replies)
  86. Sleeper: Create table array for Vlookup with match and count to next blank row (1 replies)
  87. Delete columns in spreadsheet based on list of column names specified in listed range (7 replies)
  88. [SOLVED:] Improving Cell Change Macro (2 replies)
  89. [SOLVED:] i want VBA to display values greater than or equal to the given number (9 replies)
  90. [SOLVED:] Macro For Re-Coding Variables after a Specified Cut-off (2 replies)
  91. Charts and forms freeze after VBA macro execution (5 replies)
  92. [SOLVED:] Run-Time error '91' Object variable or With variable not set (5 replies)
  93. [SOLVED:] Excel macro, combine cells based on same merged row i different column (2 replies)
  94. [SOLVED:] How to use an Array instead of a Loop to clear contents of blank cells? - Speed Issue (7 replies)
  95. Excel Userform with Checkbox value, How to return to Checkbox value in Winword (3 replies)
  96. Modifying datasource using VBA in Power Pivot (3 replies)
  97. vba excel dir loosing file name in looping (4 replies)
  98. Slicer changing chart styles (1 replies)
  99. Sorting table with Duplicates (8 replies)
  100. [SOLVED:] Split text in different cells after each Dash (9 replies)
  101. Speed up the loop process (Copy paste Value) (5 replies)
  102. Trying to replicate MAX function in SAS (1 replies)
  103. [SOLVED:] if find specify word copy all the row to anther sheet (4 replies)
  104. [SOLVED:] In merged file, re-name sheets to include part of workbook name that they came from? (2 replies)
  105. Search multiple keywords to filter column (17 replies)
  106. Double run problem (3 replies)
  107. [SOLVED:] For Loop goes thru all sheets but doesn't execute code? (3 replies)
  108. [SOLVED:] VBA Copy & Paste Based on a Condition in Another Column (5 replies)
  109. Sorting arrays (2 replies)
  110. Nested if statement, loop or something else (4 replies)
  111. vlookup separate workbooks and sum the results (8 replies)
  112. VBA Userform match issue (2 replies)
  113. [SOLVED:] Execute Macro on Cell Change (5 replies)
  114. Calendar userform ( datepicker ) (5 replies)
  115. [SOLVED:] Stuck trying to figure out this macro (8 replies)
  116. [SOLVED:] Using End(xlToLeft) in Sheets with Tables (3 replies)
  117. Multiple conditional formatting to the same range (2 replies)
  118. Assistance resolving Runtime 1004 error (5 replies)
  119. Creating a VBA code for a cell with a dropdown list to allow multiple selections (2 replies)
  120. Chart series don't extend (3 replies)
  121. Add and Sort (8 replies)
  122. FILTER EXCEL PER COUNTRY & CREATE MULTIPLE WORKBOOKS (9 replies)
  123. Protect radio buttons on a sheet with VBA (5 replies)
  124. Write selected items on form to range (6 replies)
  125. "Run-Time Error 91" trying to run Login Code (1 replies)
  126. Rank for Top 5 after two criteria match excel formula (10 replies)
  127. Hiding columns based on cell values in column (3 replies)
  128. HELP! - Print All Options (Loop) On A Drop Down List after Refreshing Excel Add In (0 replies)
  129. Hiding and then Unhiding Rows on Excel sheet based on if a checkbox is unchecked? (1 replies)
  130. [SOLVED:] Help needed resolving Compile Error: Expected End Sub issue (4 replies)
  131. [SOLVED:] Help to build a data collecti searching from many Workbooks (16 replies)
  132. Need help with INDIRECT formula (0 replies)
  133. [SLEEPER:] Problem with DCOUNT + Problem while copying data from range to listbox (0 replies)
  134. Looking for a free software/tool to perform analysis on excel data.... (1 replies)
  135. Change Color If Selected Cells Edited (5 replies)
  136. Table (12 replies)
  137. Worksheet_Change ( No Responese ) (3 replies)
  138. Format Column Labels (2 replies)
  139. Linking multiple sheet columns into one master sheet column (1 replies)
  140. VBA macro for dependents (15 replies)
  141. Simple and Basic VBA question. (4 replies)
  142. VBA adding numbers up to a certain range (7 replies)
  143. Code to detect duplicate cells in Excel (3 replies)
  144. VBA to save excel file (downloaded from server) to specific folder (0 replies)
  145. VBA Copy Sheets to New Workbook (6 replies)
  146. [SOLVED:] Numbering Duplicates Consecutively (3 replies)
  147. Excel automation error on VBA Code modification using VBA (0 replies)
  148. Activate sheet which contains date (1 replies)
  149. [SOLVED:] Form selection (10 replies)
  150. [SOLVED:] When stepping through, code doesn't stop after this "paste" command...why? (24 replies)
  151. Condition should applied if columns total value is not match (3 replies)
  152. VBscript for data matching (19 replies)
  153. convert gregorian date (3 replies)
  154. Copying real time data in excel using VBA (2 replies)
  155. [SOLVED:] using conditional format to change font if column has a number greater than or equal (8 replies)
  156. [SLEEPER:] MonthView DatePicker default to current date (4 replies)
  157. Mails from excel (4 replies)
  158. [SOLVED:] Template (6 replies)
  159. Converting Excel File to CSV (3 replies)
  160. [SOLVED:] Function to get list of Excel files in a folder (4 replies)
  161. [SOLVED:] help for homework (2 replies)
  162. [SOLVED:] Optimizing Copying Sheets & Printing (4 replies)
  163. Still Stuck On A loop (24 replies)
  164. Exporting an multidimensional array from an Ecxel file to a new Excel file (.xls) (1 replies)
  165. VBA: How to use listbox properly. (1 replies)
  166. [SOLVED:] Spell Check in Excel-Auto Select First Recommendation Using VBA (5 replies)
  167. [SOLVED:] Help with macro to set vertical alignment in Excel without affecting text indents (2 replies)
  168. Auto click OK button (1 replies)
  169. Excel report generation and export to pdf (1 replies)
  170. Minsweeper VBA code Problem (7 replies)
  171. [SOLVED:] Data Validation (3 replies)
  172. Export Crystal Report to pdf (0 replies)
  173. Moving different rows data to one row based on criteria to optimise on printing (22 replies)
  174. [SOLVED:] Message bar detection. (9 replies)
  175. [SOLVED:] Vba code to copy and paste dynamic range from mulitple workbooks to one workbook (8 replies)
  176. Skip heading rows with Range Offset (2 replies)
  177. Sleeper: How do I break a link after saving to new workbook (7 replies)
  178. How do I move files into latest created subfolder (3 replies)
  179. [SOLVED:] Need help with Macro VBA code in Excel (2 replies)
  180. VBA for binking Text inside a Shape in Excel (1 replies)
  181. Filter Pivot table by each customer and auto email invoices unpaid (1 replies)
  182. [SLEEPER:] Using Marlett for optional selections - multiple ranges (2 replies)
  183. [SOLVED:] Date filter in table (2 replies)
  184. Locking Cell Format (1 replies)
  185. [SOLVED:] How to modify this code to place the checkbox in the first cell of each column? (9 replies)
  186. [SOLVED:] Save workbooksheet as .CSV with some variables (2 replies)
  187. [SOLVED:] Copy/paste values in column if condition is met (2 replies)
  188. [SOLVED:] Isolating errors 2 (9 replies)
  189. Hi , how to select sheets (17 replies)
  190. [SOLVED:] Database or object is read-only (1 replies)
  191. Adjust macro (problem) (1 replies)
  192. [SOLVED:] Cell selection issue (6 replies)
  193. Get data from two worksheets using form (0 replies)
  194. [SOLVED:] NEED A LOOP TO COPY DATA (3 replies)
  195. Can I “include” another file or module in a sub or function? (9 replies)
  196. How to correct this error (7 replies)
  197. Excel to Pdfs Not saving correctly (6 replies)
  198. [SOLVED:] Renaming inserted Object (2 replies)
  199. Numbering a unique sort (2 replies)
  200. [SOLVED:] Even Vectors - Panel Data (9 replies)
  201. VBA code to generate report based on criteria (4 replies)
  202. ActiveX Combo Box and Pivot Table using Visual Basic Issue (4 replies)
  203. [SOLVED:] De-selecting cells after Paste (8 replies)
  204. move files from one folder to another whose file names are listed in an excel file (2 replies)
  205. [SOLVED:] Find and Replace based on Selection only (3 replies)
  206. Modification of VBA code (1 replies)
  207. VBA to relocate XML blocks (7 replies)
  208. Create Summary sheet from multiple tabs & run macro on certain tabs (1 replies)
  209. ICOLOR TAB (0 replies)
  210. [SOLVED:] VBA to dynamically select EACH block/range of cells on a worksheet, then copy/paste? (14 replies)
  211. Help with VBA code in data entry form (3 replies)
  212. Subtotal at each PageBreak (2 replies)
  213. How to copy an entire row from 1 sheet to another (2 replies)
  214. VBA code to determine if a specific excel-based tool is used as add-in and locked? (5 replies)
  215. Excel Table of Contents/Summary Help (3 replies)
  216. [SOLVED:] Coding Efficiency (2) (3 replies)
  217. [SOLVED:] VBA User Form To Select Column To Copy Cells Into If Destination Is Blank (2 replies)
  218. [SLEEPER:] Work hours between 2 dates(not working -VBA) (22 replies)
  219. [SOLVED:] Highlight duplicate data blocks (4 replies)
  220. [SOLVED:] Highlight the first row in every data block (4 replies)
  221. [SOLVED:] Print Userform (5 replies)
  222. [SOLVED:] Want to load Red colored text from a cell into an array (16 replies)
  223. Copy data from another worksheet if it doesn't exist in current worksheet (6 replies)
  224. [SOLVED:] Subscript out of range problem (14 replies)
  225. [SOLVED:] Extract matching data values and copy to new location (2 replies)
  226. [SOLVED:] Autofill Destination Offset (0 replies)
  227. [SOLVED:] Need Help With Show/Hide Check Boxes (2 replies)
  228. [SOLVED:] VBA copy and paste Vlookup (7 replies)
  229. Method 'SaveAs' of object '_Workbook' failed (2 replies)
  230. VBA code for determing if worksheets (OR) cells within a worksheets are protected? (4 replies)
  231. select item with macro (1 replies)
  232. Transpose Data Blocks To the Right (5 replies)
  233. [SOLVED:] Workbook open from specific folder (7 replies)
  234. [SOLVED:] Function in VBA (Excel) - Want a dynamic behavior depending on parameter (3 replies)
  235. [SOLVED:] Excel and splwow64.exe issues (9 replies)
  236. Creating and Save new workbook based on cell value (0 replies)
  237. [SOLVED:] Range changes values unexpectedly as code executes (2 replies)
  238. copy and paste into next blank cell of table (7 replies)
  239. Help creating a file joining different other files (10 replies)
  240. [SOLVED:] Need Help in making minor modification to an excel vba code. (6 replies)
  241. [SOLVED:] find/retrieve price from closed WB and copy to current workbook (4 replies)
  242. [SOLVED:] Generate multiple TXTs files (6 replies)
  243. [SOLVED:] "orientaion" parameter in vba SORT (9 replies)
  244. [SOLVED:] Display MsgBox "Macro is running" when macro is running (2 replies)
  245. [SOLVED:] Shared excel userform (1 replies)
  246. Alternative for sendkey (0 replies)
  247. Sleeper: Matching Algorithm - Gale Shapley, Almost complete - Excel Matching (2 replies)
  248. [SOLVED:] DATE DIFF function in years (6 replies)
  249. How to analyze big data with Excel (59 replies)
  250. [SOLVED:] Format decimal places based on columns from same row (8 replies)