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. Replace characters in array (6 replies)
  2. VBA .Find - not returning the first value in the searched range (3 replies)
  3. [SOLVED:] combining texts in a row in one cell macro (4 replies)
  4. blank rows (1 replies)
  5. [SOLVED:] bizarre "object required" (3 replies)
  6. Hide columns that contain 0 value (4 replies)
  7. How to pass used range to a function in a cell (2 replies)
  8. Count of Records IF (18 replies)
  9. [SOLVED:] How to enable data to be filtered based of values in Data valuation cells (23 replies)
  10. [SLEEPER:] Help needed in VBA (5 replies)
  11. Trouble when using the weekday function (1 replies)
  12. Assign worksheet to Global variable. Possible? or Worth it? (9 replies)
  13. [SOLVED:] Help Needed with 64 Bit Declarations (13 replies)
  14. [SOLVED:] Compile error about multiline initializtion of date array (12 replies)
  15. SumIf and SumIfs Help (3 replies)
  16. [SOLVED:] How create border in excel vba (6 replies)
  17. VBA copy last row of a sheet of a workbook to last row of sheet in another workbook (2 replies)
  18. PQ privacy level (1 replies)
  19. [SOLVED:] "IF" statement isn't reading binaries properly (8 replies)
  20. [SOLVED:] VBA Double Click Macro dependent upon a range (column) (3 replies)
  21. How to merge two different csv files by Macro (4 replies)
  22. [SOLVED:] Transpose from columns only found items (7 replies)
  23. [SOLVED:] Record change of value in cell/s (6 replies)
  24. [SOLVED:] Prevent code from moving a picture in cell outside of specified range (5 replies)
  25. How can I create a VBA macro to automatically consolidate data (3 replies)
  26. [SOLVED:] I think its a string problem? (2 replies)
  27. Drop down list help needed. Want lists that only shows selections from another list. (9 replies)
  28. Strange behavior and errors I think ????? (3 replies)
  29. getting started series on creating office-js add-ins (0 replies)
  30. [SOLVED:] Custom Ribbon fails to load sometimes (9 replies)
  31. Ron de Bruin website (2 replies)
  32. [SOLVED:] Multiple Criteria in a Filter command (6 replies)
  33. [SOLVED:] Filter in a secondary workbook (3 replies)
  34. Excel 2016 Buttons in Print Preview Disabled (4 replies)
  35. [SOLVED:] Visitor registry with signatures, excel the way to go ? (18 replies)
  36. Excel link to Access Table (3 replies)
  37. All macros quit working (5 replies)
  38. [SOLVED:] Move picture in cell to a specified number of cells away, without losing focus (2 replies)
  39. [SOLVED:] Vlookup or similiar within a GETPIVOTDATA Statment (2 replies)
  40. [SOLVED:] Trying to automatically add attachments to emails (16 replies)
  41. Multiple references (4 replies)
  42. All of a sudden my VBA no longer works in ANY workbook, old or new ?????? (4 replies)
  43. Excel VBA Code Help (3 replies)
  44. Janela Para Controle de Registros (VBA) (2 replies)
  45. Copy rows based on specific criteria and pasting values to another sheet. (2 replies)
  46. Sort data in one column based on value in another issue (2 replies)
  47. [SOLVED:] VBA macro to sort and ROUNDUP and save sheet to file (7 replies)
  48. [SOLVED:] I created my own dropdown.. (5 replies)
  49. [SOLVED:] Look if values exist seperately and together, then write Yes or No in cell (8 replies)
  50. Need assistance to calculate each name based on DATE (6 replies)
  51. Help - Powershell to VBA (2 replies)
  52. [SOLVED:] VBA removing table rows with current macro (15 replies)
  53. [SOLVED:] How to look up a text word within multiple cells with Specific Criteria in EXCEL (5 replies)
  54. [SOLVED:] Run-time error '-2147024809 (80070057)': The query name contains invalid characters (8 replies)
  55. merge files in folders (2 replies)
  56. probability of getting a pair in poker in excel (1 replies)
  57. max and min values and change the currency (2 replies)
  58. Where did the Dodgy Brothers go?! (1 replies)
  59. Compare two sheets and Conditions (4 replies)
  60. [SOLVED:] Pulling data from multiple sheets (19 replies)
  61. [SOLVED:] How to stop an Excel table being oversized if transferring to a Word document table (9 replies)
  62. [SOLVED:] VBA Excel - identify duplicates and rearrange them (6 replies)
  63. Partial qualifying references (8 replies)
  64. [SOLVED:] Create sophisticated loop (13 replies)
  65. [SOLVED:] Sort running sum in descending order using excel formula (2 replies)
  66. [SOLVED:] Send multiple columns and rows by e-mail vba (4 replies)
  67. Conditional formatting by specific rule through many rows. (5 replies)
  68. Have this code/query select what ever the current table is as a range & process? (2 replies)
  69. Extract Members of an Outlook Dynamic Distribution List to excel worksheet (3 replies)
  70. VBA - Copy & insert the currently selected row of data multiple times (2 replies)
  71. [SOLVED:] Remove duplicates macro for a table ? (4 replies)
  72. [SLEEPER:] Help (2 replies)
  73. [SOLVED:] vba - select and copy multiple rows in different columns (4 replies)
  74. [SOLVED:] New to VBA and require assistance modifying code. (17 replies)
  75. multiple e-mail links over 255 characters. (5 replies)
  76. [SOLVED:] Problem with VBA in Excel - following code giving me an error (2 replies)
  77. Unrelated User Entry Pause (6 replies)
  78. [SOLVED:] Button to copy cells from A4 to A13 to the clipboard (3 replies)
  79. [SOLVED:] Multiple Date matches (9 replies)
  80. function that will set a specified cell to a specified value. (2 replies)
  81. [SOLVED:] Automatically filter a report with date and time, with other criteria (9 replies)
  82. [SOLVED:] Count matching criterias only if duplicate values are found formula ? (5 replies)
  83. [SOLVED:] Automatically rename a template sheet with today's date. (12 replies)
  84. format help (3 replies)
  85. reports the distance between values with respect to a given value (14 replies)
  86. [SOLVED:] Match and then Copy/Paste based on dates (11 replies)
  87. [SOLVED:] Sum (column) value across multiple column criteri (9 replies)
  88. [SOLVED:] Split specific hours at the start of the week (9 replies)
  89. I see there's a new function in Excel (9 replies)
  90. [SOLVED:] Finding data (12 replies)
  91. VBScript deprecated (6 replies)
  92. How to search based on text in website to get element info? (0 replies)
  93. Happy Birthday VBAX (1 replies)
  94. Fix for BOM issue in first cell of imported txt file in Excel 2019? (3 replies)
  95. VBA - Way to recreate chart from excel in powerpoint (not paste or embed) (3 replies)
  96. [SOLVED:] conditional formatting to be macro on specific rows and colums (18 replies)
  97. Average value (3 replies)
  98. To declare or not to declare (18 replies)
  99. Power Query: Which technique will get me the same results as XLOOKUP? (8 replies)
  100. [SOLVED:] Assignment Vs Condition (17 replies)
  101. Searching for special characters (8 replies)
  102. [SOLVED:] Sending Charts to Power Point. (7 replies)
  103. [SOLVED:] Defining Variables (2 replies)
  104. [SOLVED:] Runtime error: 13 mismatch in complicated VBA array (19 replies)
  105. Simulating a function 1000 times for a given integer (easy) (1 replies)
  106. [SOLVED:] Is it possible to chart hidden figures (data) (6 replies)
  107. [SOLVED:] A more simple or efficient way of entering header row text & formatting ? (8 replies)
  108. VBA code help (3 replies)
  109. Simulating Futures trade outcome with 0-100% liquidity buffer (HELP!) (0 replies)
  110. [SOLVED:] Converting Column To Specific Date Format (18 replies)
  111. Standard deviation of a subset in VBA (10 replies)
  112. [SOLVED:] I would like to calculate equilibrium price and quantity using VBA but I can't. Help! (4 replies)
  113. [SOLVED:] Opening and extracting data from another workbook (5 replies)
  114. [SOLVED:] How to distinguish data from html (4 replies)
  115. [SOLVED:] Multi choice data source select for a chart (21 replies)
  116. [SOLVED:] Count the number if times a unique number appears in a list (38 replies)
  117. Excel VBA Open Word Doc and Save as New Word Doc (8 replies)
  118. [SOLVED:] Creating a logging column and fill out missing values (4 replies)
  119. Question How to put slash with word and ascending numbers in excel with VBA (12 replies)
  120. [SOLVED:] Download Multiple tables following URLs list in an Excel's worksheet Through VBA (8 replies)
  121. Experts Help (3 replies)
  122. Create screenshot with macro (4 replies)
  123. [SOLVED:] When should code be broken down into proceedures (7 replies)
  124. [SOLVED:] How to close all .csv or .xlsx type file (5 replies)
  125. [SOLVED:] Selecting Cells Advanced (16 replies)
  126. Open DXF file from a button on the toolbar or userform is not working, Need help? (19 replies)
  127. [SOLVED:] Debug this code. (12 replies)
  128. [SOLVED:] Case Select vs. Switch (10 replies)
  129. Is there a limit to how many terms you can stick in a Case Selection? (10 replies)
  130. VBA Code Needed (7 replies)
  131. [SOLVED:] save vba process data time (7 replies)
  132. [SOLVED:] JsonConverter question (8 replies)
  133. Extract and Copy Data from an Array to a Cell with Criteria (4 replies)
  134. [SOLVED:] VBA Date Filtering Issue (3 replies)
  135. Turn Excel Object Broswer into a 4-column long list, in Excel (2 replies)
  136. [SOLVED:] Multiple chart combined into one (12 replies)
  137. Plausibility check via VBA (2 replies)
  138. [SOLVED:] Renaming File Name (4 replies)
  139. [SOLVED:] Offset value as ".Text" use (5 replies)
  140. [SOLVED:] Update cell value for all files in a folder (3 replies)
  141. [SOLVED:] Excel Image Viewer and Rename its File Name (17 replies)
  142. Issue saving Excel Worksheet to .pdf (8 replies)
  143. Let and Lambda (10 replies)
  144. [SOLVED:] How to list dates defined by a data validation process (26 replies)
  145. [SOLVED:] Chart data for a selected range (12 replies)
  146. [SOLVED:] Converting numbers to text by macro (3 replies)
  147. [SOLVED:] vba get html table value into excel sheet (9 replies)
  148. Excel VBA Find macro fails to find a string even when the string is present in sheet! (9 replies)
  149. Need Help with Excel Macro (5 replies)
  150. [SOLVED:] Need help on VBA (13 replies)
  151. Excel - find a specified value in word document table and move it (2 replies)
  152. userform - help needed (2 replies)
  153. How to Delete Rows Based on Given text (3 replies)
  154. Excel VBA, copy 8 columns of data, paste "stacked" into 4 colums (4 replies)
  155. Excel VBA Repeating and Merging Data Into Some Columns (1 replies)
  156. [SOLVED:] Rename Excel files in folder with VBA (12 replies)
  157. spilt date and time to new columns (11 replies)
  158. Excel 365 Crashing on a 64 bit system (9 replies)
  159. How to share an Excel file with VBA code online? (1 replies)
  160. Macro that converts 1000pdf files from folder to jpgs (1 replies)
  161. getdetailsof - method or data member not found (9 replies)
  162. Selecting a cell in a given Range Not working (2 replies)
  163. VBA Code Help Bounty 1/5 Star Difficulty (27 replies)
  164. Excel Not Enough memory error into a export to pdf (4 replies)
  165. Sleeper: Writing File Address to Save File Directly to a Shared Folder (1 replies)
  166. [SOLVED:] Capturing Sort order.. (11 replies)
  167. [SOLVED:] List of Categories/Units given in a table of data (2 replies)
  168. Excel 2007 and Acrobat Reader VBA code to combine multiple PDF files into one PDF (4 replies)
  169. How to combine many ranges into one big table with vba? (and remove all of the headin (9 replies)
  170. [SOLVED:] Error 50290 on Selection Macro (17 replies)
  171. [SOLVED:] Iterating through a range of cells with a message at the end (11 replies)
  172. Excel 2007 Macro to convert more pdf files to 1 single pdf file (5 replies)
  173. [SOLVED:] Using a VBA code to change another VBA code (4 replies)
  174. [SOLVED:] Special combinations (10 replies)
  175. [SOLVED:] Copy/Paste/Count String Data from LookUp List with VBA (11 replies)
  176. [SOLVED:] Take Focus Away From UserForm After Initializing It (2 replies)
  177. [SOLVED:] Close a UserForm Via Code Only (12 replies)
  178. Message Boxes, Routines and how prevent Message boxes until an event happens (19 replies)
  179. [SOLVED:] Prevent Macro From Activating Upon Selecting Cells For Printing (2 replies)
  180. [SOLVED:] Power Query Custom Column Formula (6 replies)
  181. [SLEEPER:] Goalseek loop (1 replies)
  182. [SOLVED:] Macros run in spreadsheet but produce errors when run in vba editor (9 replies)
  183. [SOLVED:] Restructuring data from html output to excel worksheet with vba (8 replies)
  184. Is there a way to speed up my code which copy a heavily formula infested worksheet (14 replies)
  185. S: Select all slicers on a sheet and arrange them vertically IN ALPHA ORDER by NAME? (6 replies)
  186. [SOLVED:] "Translation" help for a bit of code (where year is identified) (6 replies)
  187. Adding an asterisk (5 replies)
  188. [SOLVED:] VBA script to open files based on criterias (14 replies)
  189. VBA script to monitor folder and change file to csv (3 replies)
  190. [SOLVED:] Disable Save Notification Upon Closing Excel (2 replies)
  191. Better to create PDF file from Excel or from Word? (7 replies)
  192. VBA code to move data from Pivot Table to unhidden columns on a different sheet? (1 replies)
  193. Name Manager for Excel on-line, now available! (0 replies)
  194. [SOLVED:] Solutions for Text Boxes in Excel (6 replies)
  195. [SOLVED:] Copying (downloading) a file knowing its URL (With VBA). (8 replies)
  196. VBA - character counting analysis (5 replies)
  197. [SLEEPER:] Physical Counting (1 replies)
  198. [SOLVED:] VBA Arrays with References to Multiple Sheets (14 replies)
  199. [SOLVED:] Calculation of all combinations by taking a min Max quantity from multiple data set (7 replies)
  200. [SOLVED:] Open an Excel on OneDrive (2 replies)
  201. [SOLVED:] Edit with VBA on Startup: File > Options > Customize Ribbon (2 replies)
  202. Excel VBA Macros (1 replies)
  203. VBA code to create OUTLOOK email (8 replies)
  204. [SOLVED:] problem change Office365 for creating a calendar in Outlook. (9 replies)
  205. [SOLVED:] Addition to VBA code (10 replies)
  206. macros (2 replies)
  207. Copying chart from Excel to PowerPoint (2 replies)
  208. VBA - matching and adding value with conditions - please help (7 replies)
  209. [SOLVED:] How to quickly filter out blank cells in multiple rows & columns? (10 replies)
  210. Help editing a current piece of VBA (6 replies)
  211. Help! VBA codiing is not my expertise... (3 replies)
  212. MSG Box (6 replies)
  213. [SOLVED:] Advanced Filter for Dates (4 replies)
  214. Extracting Multiple data points from single Pivot Table (7 replies)
  215. [SOLVED:] Excel Track changes in Excel vba code (3 replies)
  216. how to exchange Multidimesional Arrays' datas? (3 replies)
  217. VBA Macro - invoice - add data to the record fail (1 replies)
  218. [SOLVED:] Search 2 Columns For A Value and Retrieve Values Needed (2 replies)
  219. [SOLVED:] Service Géoplateforme d'images WMS-Raster (3 replies)
  220. [SOLVED:] Macro, how to SaveAs a file with a new name in the same directory where the main file (17 replies)
  221. Create Chart by VBA (2 replies)
  222. [SOLVED:] Lock and unlock conditional on specific cells (6 replies)
  223. [SOLVED:] Using named cell range in a formula (10 replies)
  224. [SOLVED:] Help with code to copy cell value before change event (18 replies)
  225. Speed up Looping through subfolders (1 replies)
  226. VBA - protect sheet and allow grouping/ungrouping (outline) (6 replies)
  227. [SOLVED:] List all formulas in a worksheet on a separate worksheet (2 replies)
  228. delete blank rows in excel using VBA (1 replies)
  229. Excel Macro (2 replies)
  230. [SOLVED:] Make VSTACK(FilterFunctionA,FilterFunctionB) show parent (6 replies)
  231. [SOLVED:] Filter formula include argument (4 replies)
  232. [SOLVED:] Removing redundant code (4 replies)
  233. [SOLVED:] Close VBA form (10 replies)
  234. [SOLVED:] Removing a Users access to a Shared Workbook (6 replies)
  235. Sleeper: Edit VBA code to let it automaticlly create Folder (3 replies)
  236. [SOLVED:] Help With Save All Sheets Except First VBA Code (7 replies)
  237. [SOLVED:] ADODB Get actual displayed values (9 replies)
  238. [SOLVED:] Big Crash (11 replies)
  239. [SOLVED:] stamp duty tax (6 replies)
  240. Sleeper: CheckBoxes (3 replies)
  241. Sleeper Form to populated Selected Cell with Code depending on Radio Option and value (1 replies)
  242. Sleeper: Looping through pivot (and copying data to another sheet) (8 replies)
  243. [SOLVED:] Conditional formatting and wildcards (to apply CF to a string of text) (3 replies)
  244. [SOLVED:] VBA Code Need it to Copy Formulas (6 replies)
  245. Sleeper: Old Windows user in first cell and New Windows user in second cell (VBA) (7 replies)
  246. [SOLVED:] Confusion about XLOOKUP (4 replies)
  247. [SOLVED:] VBA Code to Copy Info (6 replies)
  248. [SOLVED:] Combining VBA Code--Some Help (2 replies)
  249. [SOLVED:] VBA Code to copy 4 cells from one worksheet to another Worksheet (6 replies)
  250. Sleeper: Help with VBA code and XLOOKUP (2 replies)