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. vbObjectError Not Working as Expected (33 replies)
  2. VBA Beginer -Real Estate Industry (2 replies)
  3. [SOLVED:] Excel 365 - VBA to assign a formula (6 replies)
  4. [SOLVED:] run macro on range of cells only (0 replies)
  5. loop + Add value (1 replies)
  6. Move WordArts on others Sheets with a checkbox on the active sheet? (4 replies)
  7. Formula for finding unique values (7 replies)
  8. [SOLVED:] AND Cell value A minus Cell value B divided by Cell value A > 0.1 (2 replies)
  9. Work book with on time control to close in specified time (0 replies)
  10. Stop Importing file after 'End Records' (1 replies)
  11. Google Spread Sheet Search any part of the cell and display (0 replies)
  12. Sum Cell Values Until Blank Cells With VBA (5 replies)
  13. [SOLVED:] Color Cell based off of a Simple Range. (8 replies)
  14. Copy data column from a table to another (3 replies)
  15. [SOLVED:] Help. Macro works, but Excel is not responding well after running it (1 replies)
  16. Experiencing workbook with user form keeps closing upon opening (4 replies)
  17. Reading a SharePoint list using Excel VBA (8 replies)
  18. General about VBA (2 replies)
  19. [SOLVED:] Formula Modification Help with And/OR (2 replies)
  20. How to extract a specific data in a column and parse it in another column with VBA (3 replies)
  21. Copy & Paste from 1 WB to another WB (4 replies)
  22. [SOLVED:] Getting Error when calculating date value (3 replies)
  23. [SOLVED:] Listbox Multiselect (4 replies)
  24. [SOLVED:] Resolve changed filename in Excel shortcut Target attribute (1 replies)
  25. Run-time error ‘1004’: Method ‘Name’ of object ‘_Worksheet’ failed (2 replies)
  26. Adjusting VBA module (4 replies)
  27. [SLEEPER:] How to pop up message box even when editing a cell (0 replies)
  28. One OptionButton change state of another one in different group (1 replies)
  29. [SOLVED:] Transferring Wide Data to Long Data (5 replies)
  30. Combine All Data From one Worksheets in All Workbooks in a Specified Directory (0 replies)
  31. Concatenate with conditional and reference (2 replies)
  32. NumberFormat of a table column (1 replies)
  33. Add sheet and rename sheet and paste only value (4 replies)
  34. How to Run a Batch File Using VBA in Excel 2013 (11 replies)
  35. [SOLVED:] Payroll Formula Help (3 replies)
  36. [SOLVED:] Application-defined or object-defined error - Error in replicating code (9 replies)
  37. Excel version (3 replies)
  38. RAM does not get released when workbook is closed (3 replies)
  39. [SOLVED:] VBA Insert ROWs into table and continue index value based on last row (2 replies)
  40. [SOLVED:] Dynamic column Add and names (3 replies)
  41. Do not update range if cell is not empty (4 replies)
  42. [VBA] Edit and Move my diagram (2 replies)
  43. [SOLVED:] Linear Interpolation (5 replies)
  44. Extract record based on company (9 replies)
  45. [SOLVED:] UserForm Button That Loops Through Various Table Styles on the Table Design Ribbon (3 replies)
  46. [SOLVED:] Copying data to another sheet in a particular format and Auto-adjustment (2 replies)
  47. [SOLVED:] VBA Create Diagramms (1 replies)
  48. VBA to Paste Text into Ppt as Title (3 replies)
  49. VBA Addition to existing cell (0 replies)
  50. Excel UDF with IF (10 replies)
  51. vba - Sendkeys Crtl+C and clipboard (4 replies)
  52. [SOLVED:] VBA formula not working because array formula needed (10 replies)
  53. How to Bring up the Table Design Dialogbox (VBA) for the User to Select Table Designs (4 replies)
  54. How can I create product keys for VBA add-ins and store it in the system? (19 replies)
  55. [SOLVED:] Use Inputbox to Add Column in Excel Table with Multiple Criteria (4 replies)
  56. [SOLVED:] Fill in blank cells with the data listed above it (8 replies)
  57. Changing shapes in footers (0 replies)
  58. [SOLVED:] VBA to export data with altered format to a csv (10 replies)
  59. Extract Excel Outlook Attcahments (2 replies)
  60. [SOLVED:] Download files from excel multiple links (0 replies)
  61. Excel VBA to delete Email String from Picked Folder (1 replies)
  62. Text File processed into Excel (8 replies)
  63. [SLEEPER:] Conditional Formatting in Listview (3 replies)
  64. complex excel formula (16 replies)
  65. [SOLVED:] why is my 'find and replace' function automatically set to look in formulas? (9 replies)
  66. For Next lop ends on x +1 (5 replies)
  67. update final sheet with data from existing sheets (2 replies)
  68. 6 columns to 6 sheets in same workbook and 6 sheets charts pasted to PowerPoint slide (0 replies)
  69. Bar charts in pivot (0 replies)
  70. Map SharePoint drive using VBA (3 replies)
  71. Listbox fill via recordset (6 replies)
  72. Select only cells with visible values (1 replies)
  73. vba userform move listbox1 item to listbox2 (2 replies)
  74. Pop up windows asks what name the folder should have (1 replies)
  75. hex to color (9 replies)
  76. [SOLVED:] Move Select Rows and Columns to Sheet 2 (19 replies)
  77. Userform needs to be "moved" to show objects. (0 replies)
  78. VBA Code to copy value in a cell and paste in at the first row of the Table (4 replies)
  79. Interact with cloud-based storage using VBA (0 replies)
  80. [SOLVED:] VBA VLOOKUP BETWEEN TWO NAMED TABLES (4 replies)
  81. [SOLVED:] Pick and Chose which Workbook(s) to Close from a UserForm (4 replies)
  82. Function that converts cell into just the value of its formula (5 replies)
  83. Spread Sheet - Automatic Reset a Cell to 0 'Zero' (6 replies)
  84. Nested IFs (4 replies)
  85. Sharepoint- persons and groups field (0 replies)
  86. How to end the last row and save the new file? (0 replies)
  87. [SOLVED:] Hide Worksheet Selection From two Different ListBox in a UserForm (2 replies)
  88. Copy data from 1 row to other Sheet (1 replies)
  89. [SOLVED:] 2 ListBox/ Can't Show Column Headers on 2nd Listbox When Sheets are Selected on 1st (2 replies)
  90. Copy data from 1 row to canvas (0 replies)
  91. vba searchble dropdown (8 replies)
  92. Macro crash when extending date range (3 replies)
  93. [SOLVED:] Fill first Empty cell in column When second column has an entry inserted (4 replies)
  94. [SOLVED:] Offset Rows (4 replies)
  95. Casting Couch (1 replies)
  96. VBA for multiple files with date - maximum values (17 replies)
  97. Help with loop and MID function (5 replies)
  98. [SOLVED:] Cumuative Sum (2 replies)
  99. [SOLVED:] VBA - Formatting Height of two Merged rows (3 replies)
  100. InsertVBComponent not working (4 replies)
  101. How to get mainserver ping response on userform (0 replies)
  102. VBA to Extract digit and text from two different columns of excel (5 replies)
  103. Drop down multi select while also changing what is shown in the cell (0 replies)
  104. Move csv file to new folder (0 replies)
  105. Can't output values to cell (3 replies)
  106. [SLEEPER:] Checking for duplicates when creating macro to move data into master sheet (1 replies)
  107. VBA to Hide and Show rows based on multiple ranges provided (4 replies)
  108. for loop in vba (4 replies)
  109. extract OLE image from access to file by running sql adobd from vba excel (8 replies)
  110. [SLEEPER:] Hide column base on cell value of zero and 1 (4 replies)
  111. [SOLVED:] VBA to use Selection.Address in a formula (3 replies)
  112. Remember selected cells in other worksheet (7 replies)
  113. Tracking equipment run times with multiple starts/stops (3 replies)
  114. Exporting from Word Textboxes to Excel (0 replies)
  115. ODBC Refresh Connection String Error in VBA / Run Time Error 1004 (4 replies)
  116. Print a sequence of sheets (0 replies)
  117. VBA Add slide to the end of the presentation (1 replies)
  118. Printing multiple workbooks into pdf (7 replies)
  119. Using Excel to send e-mails through IBM Notes (0 replies)
  120. VBA Clipboard Statement (0 replies)
  121. VBA to loop through sheets in workbooks in a file directory and add missing columns (1 replies)
  122. variable = worksheet (=>expected identifier) (2 replies)
  123. [SOLVED:] VBA to Print the Comments of a single cell (5 replies)
  124. One PDF with Print Page Order - A variation (0 replies)
  125. [SOLVED:] Save Worksheet Tabs as Seperate PDF Files to Folder (2 replies)
  126. assistance from experts to fixing theses codes (4 replies)
  127. Using SumIF with Cell.Interior.ColorIndex on another WorkSheet (0 replies)
  128. [SOLVED:] Macro removes editing options selected when re-protecting worksheet after macro runs (1 replies)
  129. [SOLVED:] VBA To Insert A new Row with Specific formatting (4 replies)
  130. Help to filter list (18 replies)
  131. How to Declare Object Variable with Direct Memory Access? (6 replies)
  132. [SOLVED:] Take subheading and move to front of each row (8 replies)
  133. HinstancePtr vs Hwnd? (5 replies)
  134. [SLEEPER:] Removing Specific Fill Colors (6 replies)
  135. VBA Code to Disable Insert Header & Footer on Ribbon (2 replies)
  136. [SOLVED:] Multiple errors in VBA trying to get HTML elements by Class & Tag (5 replies)
  137. Display succeeding column data while skipping blank cells (4 replies)
  138. Paste Excel Range into Powerpoint (2 replies)
  139. [SOLVED:] Help Required : Random Sampling of Data (65 replies)
  140. [SOLVED:] Date -Time not populating correctly (8 replies)
  141. [SOLVED:] Add between 10% to 20% random to numbers in cloumn F (6 replies)
  142. [SOLVED:] VBA Loop Control Variable Issue / Question (8 replies)
  143. VBA how do you change the thickess of a line using AddLine (1 replies)
  144. Sleeper: How to dynamically add data into a new column to the right (5 replies)
  145. [SOLVED:] ORDER OF PDF MERGING - PLEASE HELP (6 replies)
  146. [SOLVED:] VBA Code for IndexMatch Function not working without error (2 replies)
  147. Extract data from automatic pivot table (0 replies)
  148. [SOLVED:] Range("R1C1") gives error (6 replies)
  149. [SOLVED:] Help : Highlight the row basis of a cell selection and restore on selectin change (8 replies)
  150. [SOLVED:] Export to single PDF from matrix of range and sheets (15 replies)
  151. Conditional If in VBA (0 replies)
  152. Concatenate with ";" if values of 3 columns are same (14 replies)
  153. VBA Excel - Conditional Formatting in Table based on group (3 replies)
  154. VBA: ActiveSheet started spitting out 1004 out of nowhere (13 replies)
  155. To automatically create a variable number of worksheets, name them and the enter the (15 replies)
  156. RE: SAP scripts VBS loop - Help required (4 replies)
  157. [SLEEPER:] How to close it (0 replies)
  158. vba help - Count only Alphabets from a string using Regular expression (5 replies)
  159. Automate a Pivot Using VBA (0 replies)
  160. What's wrong with this code? (2 replies)
  161. what's going wrong with the code (5 replies)
  162. VBA Bold Text (1 replies)
  163. Excel Formula : =MIN(IF) (2 replies)
  164. [SOLVED:] To Copy and Split the Name to First and Surname from Another Workbook (5 replies)
  165. [SOLVED:] Date Increasing (17 replies)
  166. EXCEL VBA - Dependent FORM Drop Downs & Excel Tables (7 replies)
  167. Vba if iserror issue with vlookup (3 replies)
  168. Merge Workbooks based on Number of Row of Data (14 replies)
  169. Need Help Finding Specific Cells and Determining if there are values in it or not (6 replies)
  170. Script not Running (6 replies)
  171. [SOLVED:] Excel cannot access 'ExcelVB' (17 replies)
  172. [SOLVED:] Counting the occurrence of each entry in a column (2 replies)
  173. listview background color (0 replies)
  174. [SOLVED:] Shared Workbooks with Hidden Tabs (2 replies)
  175. Shift pattern conversion (1 replies)
  176. Efficient Way of Copying Data from an Input Sheet to a Database (7 replies)
  177. Vba : copy Transpose in 2 differents rows (2 replies)
  178. [SOLVED:] Need help fixing/understanding Macro (3 replies)
  179. [SOLVED:] Close All Instances Of Excel Without Saving Any Changes (27 replies)
  180. Conditionally Filter chart categories according to the x-axis labels (0 replies)
  181. Macro to Look for Specific text in other workbook and report value in cell beneath it (3 replies)
  182. [SOLVED:] Cannot control the popup window (4 replies)
  183. Copying sheets and updating values from a main sheet (1 replies)
  184. Matching the data. (1 replies)
  185. show and hide photos with formula (0 replies)
  186. VBA Macro Causing Excel to Freeze When 2nd Copy of Sheet Added to Workbook (1 replies)
  187. VBA to merge multiple workbooks with demarcation (9 replies)
  188. Worksheet_Change multiple ranges and different formulas (19 replies)
  189. [SOLVED:] VBA to Delete Duplicate Info on Same Date (1 replies)
  190. delete folders on search (10 replies)
  191. Close and save changes in one workbook from another. (1 replies)
  192. Selection Change where a merged cell is involved (6 replies)
  193. [SOLVED:] Count Dates in a List of dates for every employee for every month (3 replies)
  194. Help VBA CODE to include negatives in the loop calculation (1 replies)
  195. Auto Update Excel Data (0 replies)
  196. Find Form Controls with Value not set (7 replies)
  197. [SOLVED:] copy data with pushbutton (5 replies)
  198. Copying and pasting values into a table below the previous entry for many days (3 replies)
  199. Sumif with integer and from another sheet (1 replies)
  200. [SOLVED:] Change sheet tab color automatically based on cell values (5 replies)
  201. Import XML to worksheet with mapped schema (0 replies)
  202. [SOLVED:] Exel crash when VBA frames manipulation (5 replies)
  203. How to get the number of instances of a class (5 replies)
  204. how can i create userform using simpson rule for a function in excel vba (0 replies)
  205. [SOLVED:] VBA “folder” sorter (8 replies)
  206. Click IE Popup window (0 replies)
  207. Copy some data from one Sheet to another and create a list (7 replies)
  208. [SOLVED:] Select Sheets Starting with "XXXX" and Remove Macro from Sheet (7 replies)
  209. VBA Formula for Splitting Property Address to Multiple Columns (4 replies)
  210. [SLEEPER:] VB Editor Menu Keyboard Shortcut Assignments Change with Macro / Code … (1 replies)
  211. [SOLVED:] Protect Workbook (Lock Certain Cells) and still have VBA run on unlocked cells?? (3 replies)
  212. Statistical confidence plot in Excel (1 replies)
  213. Sensitivity Analysis (0 replies)
  214. [SOLVED:] Office 365 - Remove All Tables, ListBox & Macros from a Dynamic Range of Worksheets (5 replies)
  215. Office 365 - Select Dynamic Sheet Names in Array (15 replies)
  216. [SOLVED:] Need Help Creating a Macro (9 replies)
  217. Remove duplicated rows with VBA (1 replies)
  218. [SOLVED:] Cannot get two subs to run together (5 replies)
  219. [SLEEPER:] Excel VBA - causing issues (3 replies)
  220. Office 365 - Using ComboBox / Text Box & Lists from Dynamic Tables (10 replies)
  221. [SLEEPER:] Take out numbers from a string after a specific word till next space or comma (11 replies)
  222. CREATE WORKBOOKS FROM TEMPLATE WORKSHEET AND TABLE OF DATA (3 replies)
  223. Concatenate in VBA? (5 replies)
  224. [SOLVED:] ClearContents of merged cells? (5 replies)
  225. [SOLVED:] Syntax error - can't see why! (12 replies)
  226. [SOLVED:] Simple read file macro in Excel VBA on Mac OS X (0 replies)
  227. [SOLVED:] pushbutton and countif/deletes (22 replies)
  228. [SOLVED:] Userform with calendar month code to bold 2 inputbox result day label value (1 replies)
  229. Keeps overwriting my output (2 replies)
  230. VBA Application.Run for Running Macros-with-Parameters Stored Inside an Excel Cell (20 replies)
  231. How to apply VBA formula to stop row height from readjusting ? (Excel File) (1 replies)
  232. [SOLVED:] Format date within formula in VBA (18 replies)
  233. Combination data types (7 replies)
  234. Compare with two column and return value or highlight match word(s) (2 replies)
  235. [SOLVED:] Not Working : Load data from excel in user form and update / delete (5 replies)
  236. [SOLVED:] Help required to extract data from rows to column in Excel2013 (3 replies)
  237. VBA Code/Macro for Extracting data from Sheet 1 to Sheet 2 (1 replies)
  238. [SOLVED:] Vba Array Shuffle Giving an Error and Lost Datas! (3 replies)
  239. [SOLVED:] convert cells in worksheet to values (11 replies)
  240. [SOLVED:] Calculate the SUM from One Place to Another (2 replies)
  241. [SOLVED:] Slow Calculation of Sum Row (10 replies)
  242. Create a loop in VBA to copy data out of different files (11 replies)
  243. [SOLVED:] Not Working : Sum of Hours (6 replies)
  244. [SOLVED:] Change format of ConvertDegrees function (11 replies)
  245. VBA Command (6 replies)
  246. product csv from sheets (1 replies)
  247. [SOLVED:] Searching for multiple texts within a cell (InStr) (7 replies)
  248. VBA help to stop one code from affecting another (6 replies)
  249. [SOLVED:] Comma separated list from columns (7 replies)
  250. [SOLVED:] Formula to collect charges (4 replies)