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. [SOLVED:] Compare and replace- Long Sentences (14 replies)
  2. DTPicker - select date, then continue automatically (2 replies)
  3. Ways to optimize VBA loop (17 replies)
  4. [SOLVED:] Error 1004 with method "Columns" - only when opening the file (2 replies)
  5. Save file to folder with variable (3 replies)
  6. [SOLVED:] How to disable "traditional" Save and Save As functionality (4 replies)
  7. [SOLVED:] Hiding Rows (3 replies)
  8. errore (1 replies)
  9. [SOLVED:] VBA - Moving files (2 replies)
  10. Custome Date Picker! Duplicate value (3 replies)
  11. Copy from worksheet to worksheet in different workbooks with IF condition (6 replies)
  12. Connect via ODBC to Access FE on remote server from Excel (0 replies)
  13. cant figure out compile error: do without loop (2 replies)
  14. [SOLVED:] Forms, Formulas and Dropdowns. Difficult (16 replies)
  15. Sum for a certain criteria (9 replies)
  16. Code for Vlook up (0 replies)
  17. [SOLVED:] Code is dropped when sheet is copied and emailed (3 replies)
  18. [SOLVED:] Open Window in 64 Bit Excel VBA 7 using Windows API (1 replies)
  19. [SOLVED:] Delete Rows in Table (2 replies)
  20. Merge two pdf files with partly same name in 2 different flders (0 replies)
  21. Add a row below an activebutton, keeping the format without resizing the button (2 replies)
  22. [SOLVED:] Random Select Rows and Copy to Next Sheet based on user input value (2 replies)
  23. Change Direction (1 replies)
  24. Copy paste with VBA (1 replies)
  25. code for the filerting and copy n pasting in another sheet (0 replies)
  26. [SOLVED:] Overflow Error in Array Assignment (20 replies)
  27. [SOLVED:] CDO Email, specific cells in the body (6 replies)
  28. [SOLVED:] Chart Title and Axis Title positioning (2 replies)
  29. Storing Previous Cell Value in Historic List (7 replies)
  30. Addins and CustomUI, OnAction to only run Subs in book? (4 replies)
  31. Text stretched in inserted word object (1 replies)
  32. [SOLVED:] Range(Cells()) and the 1004 Error (6 replies)
  33. Looping Macro (7 replies)
  34. [SOLVED:] Generate Text Files (4 replies)
  35. [SOLVED:] Array Indexing - Please help, at a loss for words... (3 replies)
  36. Attemping to loop data/extract/compare (4 replies)
  37. How to avoid hardcoding a filepath (7 replies)
  38. [SOLVED:] HTML href cutting off URL at first space (1 replies)
  39. SSL connection to external source (0 replies)
  40. Run-time error 438: Object doesn't support this property or method (2 replies)
  41. I want to make change in data model in manage data model of powerpivot by vba code (2 replies)
  42. Finding out leaves and exits (2 replies)
  43. [SOLVED:] Excel MACRO that make variable sheets with conditional information (3 replies)
  44. [SOLVED:] Setting the width of an inserted word document (1 replies)
  45. Userform on Mac (2 replies)
  46. Hiding Quick Access Toolbar (QAT) (0 replies)
  47. VBA in Excel to search for PDF's and report if exist yes/No (4 replies)
  48. Results changing from a drop down selection - understanding VBA code (1 replies)
  49. Deleting rows which consists cell value PM and CM and remain cell value intact. (1 replies)
  50. function with paramarray help (1 replies)
  51. [SOLVED:] Code that opens a file and uses data from that file to replace data in another (13 replies)
  52. Automatic Hyperlink documents in excel workbook using a command button (6 replies)
  53. [SOLVED:] Force opening a file as a .XML (2 replies)
  54. [SOLVED:] Auto copy range data and paste on last empty row (4 replies)
  55. [SOLVED:] Help with vlookup in VBA (2 replies)
  56. Huge working excel document (3 replies)
  57. [SOLVED:] Find row index where max value is located (8 replies)
  58. [SOLVED:] Removing end elements of an array (they are all 0) (8 replies)
  59. CommandButton button in Excel 2016 does not work (1 replies)
  60. comparing elements of 2 arrays (3 replies)
  61. [SOLVED:] Set value to variable in vba to use different sub (3 replies)
  62. [SOLVED:] Take absolute value of all array elements - Please Help! (3 replies)
  63. [SOLVED:] Match Overlap Date Range and multiple criterias (2 replies)
  64. Smart View - Connect to a Shared Database (1 replies)
  65. [SOLVED:] Ribbon customization issures (2 replies)
  66. Print Charts to pdf (2 replies)
  67. Every possible combination (0 replies)
  68. Parsen/Scripting web-pages with Excel-VBA - no refresh data (2 replies)
  69. [SOLVED:] Vba Code for sorting date (8 replies)
  70. [SLEEPER:] I like to find next small value.. (2 replies)
  71. Ribbon Control not displayed at file open (2 replies)
  72. [SOLVED:] Adding batches of serial numbers (6 replies)
  73. TextToColumns FieldInfo ignored (4 replies)
  74. [SOLVED:] VBA - uppercase of the first letter in each word, while the rest remains intact (9 replies)
  75. VBA Cells update vica-versa using VBA code - Level 100 Can somebody solve this? (5 replies)
  76. How can I find next small value(look up value) in a range? (2 replies)
  77. VBA Code->copying sheet from mutiple sheets excel into single excel with diff sheets (2 replies)
  78. macro save as (8 replies)
  79. Transferring Excel data into Word (3 replies)
  80. VBA - inserting picture on from clipboard to userform image (0 replies)
  81. [SOLVED:] UDF to count colored cell pairs fails with #VALUE! (3 replies)
  82. Copy partial rows with criteria to new workbook identified sheet (8 replies)
  83. Catching fatal VBA errors (1 replies)
  84. [SOLVED:] Retain excel cell format when copying to word bookmark (2 replies)
  85. Excel Macro pulling data from Word 2013 form - formatting question (0 replies)
  86. [SOLVED:] Limiting Window Size to the used Column range (5 replies)
  87. Macro - Mail every worksheet using A1 as address (4 replies)
  88. Splitting data into other worksheets based on data in ROW (1 replies)
  89. compare dynamic arrays and copy data from another array into a cell in WS (2 replies)
  90. Slicer vba code (3 replies)
  91. [SOLVED:] Dashboard prepration (2 replies)
  92. Import Multiple txt files (0 replies)
  93. [SOLVED:] ForEach Loop Trouble (7 replies)
  94. VBA for Setting Min and Max Axis for Scatter Plot Graph (0 replies)
  95. Vba view active ie window and mouse over text and pull to text box (0 replies)
  96. [SOLVED:] Arrays using MMULT Function (3 replies)
  97. Upon exit excel woorkbook save charts as picture (4 replies)
  98. Split to Files - adjustment (2 replies)
  99. Compare cells (4 replies)
  100. VBA help solving assignment (2 replies)
  101. [SOLVED:] VBA- how can i have a userform behaviours just like controltiptext? (17 replies)
  102. Copy from RDP (remote desktop) to local desktop (2 replies)
  103. [SOLVED:] Need help w/formula to show just some amounts (3 replies)
  104. [SOLVED:] Select data down to next empty cell in column (4 replies)
  105. VBA Table of Contents (0 replies)
  106. Add double quotes to cells that contain spaces (8 replies)
  107. [SOLVED:] Select range till last empty row (2 replies)
  108. [SOLVED:] Value & Formula - Export Sheet from xlsx to CSV (2 replies)
  109. [SOLVED:] VBA Coding Help (3 replies)
  110. Message when you try to open the file (1 replies)
  111. [SOLVED:] Can you Format as fraction in VBA -- Format(123.456, "# ??/16") (1 replies)
  112. [SOLVED:] Changing Multiple ranges to Dynamic ones (5 replies)
  113. VBA: website scraping in general and specific problem (0 replies)
  114. Download and open Excel file (3 replies)
  115. Senders Email Address: Outlook 2013 to Excel 2013 Not Working (0 replies)
  116. urldownloadtofile-is-downloading-files-to-inetcache (1 replies)
  117. Select data through 2 slider bars (0 replies)
  118. [SOLVED:] How to keep Inserting Rows Command from moving other cells in a sheet (29 replies)
  119. 2 selection critria in a WorkSheet form (1 replies)
  120. Mirroring of sheets to a single summary sheet (0 replies)
  121. [SOLVED:] Microsoft Object Library Reference Missing - Outlook to Excel (3 replies)
  122. VBA format Word (0 replies)
  123. Excel VBA: resizing a pasted image in word using excel VBA (0 replies)
  124. Yes/No Optionbuttons (0 replies)
  125. X-Y Scatter plot using VBA (3 replies)
  126. VBA to read text file and import specific data from it to excel columns (6 replies)
  127. How to run macro only selected rows (4 replies)
  128. Salary Structure Calculations (3 replies)
  129. Sum adjacent columns based on criteria (3 replies)
  130. Copy Paste VBA code Required with some additional requirements Button (2 replies)
  131. Compare list of values to rows in another sheet, copy row on first match (1 replies)
  132. [SOLVED:] Hide and Unhide Columns based on Cell Value (10 replies)
  133. Extract value from HTM file (1 replies)
  134. [SOLVED:] Deciphering VBA Code (4 replies)
  135. Help removing encryption from an excel template using VBA (4 replies)
  136. Function to list file names in a folder (0 replies)
  137. Two dropdown lists (0 replies)
  138. VBA Newbie question (0 replies)
  139. Help Looping through array (22 replies)
  140. Run-time error; Invalid procedure or arguement (2 replies)
  141. Macro listing files in folder, used to list all now only first (3 replies)
  142. Compile error argument not optional (7 replies)
  143. [SOLVED:] Help with renaming files (Name "xxxxxxx" As "yyyyyyyy" wont work) (2 replies)
  144. [SOLVED:] How to fix Compile error: Else without if (5 replies)
  145. Distance between 2 locations 2D array (3 replies)
  146. [SOLVED:] Find specific words in a worksheet and change the font color of those words (5 replies)
  147. [SOLVED:] Find zero (3 replies)
  148. [SOLVED:] Need help parsing subtext in cell (5 replies)
  149. [SOLVED:] Extracting intersecting values from two or more ranges (2 replies)
  150. Make Cell Blink 3 times (1 replies)
  151. [SOLVED:] Switching worksheets unexpectedly after exiting UserForm (6 replies)
  152. Run-time error "438" (11 replies)
  153. Checking for MULTIPLE duplicates on save_click (2 replies)
  154. [SOLVED:] Changing code from copy entire row to copy specific cells (2 replies)
  155. Auto update Form Text box with form editor name (0 replies)
  156. [SOLVED:] Filter between two dates on multiple ranges (2 replies)
  157. [SOLVED:] VBA to Copy / Paste into New Workbook With Different Layout by Column & Row Headings (9 replies)
  158. [SOLVED:] YTD SUM (4 replies)
  159. Search for Specific Text within a Cell (1 replies)
  160. Help with time diffrences (3 replies)
  161. [SOLVED:] Search using two ranges (4 replies)
  162. Change Check Box character to text (3 replies)
  163. Different Phone Number Formats from list of numbers (2 replies)
  164. Copying charts from all Excel worksheets onto Powerpoint slides (2 replies)
  165. data transfer through loop (3 replies)
  166. Aligning Columns and rows (3 replies)
  167. Turning Multiple Optionbuttons subs into one sub (2 replies)
  168. Eliminating Pop-up when using RemoveDuplicates (3 replies)
  169. VBA msgbox help (2 replies)
  170. Copy Data from one sheet to another IF cells are specific text colour (0 replies)
  171. excel help (3 replies)
  172. Excel VBA game help (0 replies)
  173. Force User to Enter Date but in UK format (10 replies)
  174. VBA variable url webquery (0 replies)
  175. Need help : fill listbox with search result (2 replies)
  176. VBA - Outlook to Excel (1 replies)
  177. How to change code for sheet to work whole book (2 replies)
  178. Code for Slicer (5 replies)
  179. Export specific sheet from a file to a specific sheet in many closed files (5 replies)
  180. [SOLVED:] Run time error -2147417848 (80010108) Method "_range" of object "_worksheet" failed. (6 replies)
  181. vba - vlookup on data stored in array (3 replies)
  182. Barcode Asterisks Around Date Formula (1 replies)
  183. Show column headings and corresponding values/text based on dropdown selection (39 replies)
  184. Numbers update as per Pivot table (2 replies)
  185. Moving data between sheets based on headers (2 replies)
  186. Data lookup formulas (4 replies)
  187. Else without IF error !!! (2 replies)
  188. Test to determine workload (3 replies)
  189. golf 4somes (22 replies)
  190. [Help] VBA for scheduling (1 replies)
  191. In work materials vs delivery date (2 replies)
  192. [SLEEPER:] Time formula (2 replies)
  193. Reading value from another application (1 replies)
  194. Hiding ribbon commands (3 replies)
  195. Extracting data from a variable length string (4 replies)
  196. Customized Footers with VBA (0 replies)
  197. [SOLVED:] Concatenate Transpose - Multiple with Multiple (2 replies)
  198. [SOLVED:] Hide/Unhide Rows Based on Cell Value (2 replies)
  199. automatically hide/unhide the row based another sheet cell value. (4 replies)
  200. [SOLVED:] Average and addtional conditions (4 replies)
  201. [SOLVED:] Import most recent xml file (3 replies)
  202. VBA breaks when it comes to deleting command button and selecting A1 cell (1 replies)
  203. [SOLVED:] Textjoin help needed (5 replies)
  204. [SLEEPER:] Help with Merge in Excel (2 replies)
  205. [SOLVED:] For Loop for 2 Range (3 replies)
  206. VBA: Internet Explorer zoom level (0 replies)
  207. Filtering data on multiple creterias (8 replies)
  208. [SOLVED:] Multiple Frames on A Excel UserForm and switch the visibility (6 replies)
  209. [SOLVED:] could not set the list property. Invalid property value error (8 replies)
  210. [SOLVED:] Saving worksheet range without formula to array (2 replies)
  211. Dynamic vlookup refering different workbooks through VBA (3 replies)
  212. Macro to recover an excel encrypted workbook (4 replies)
  213. [SOLVED:] Trim and LCase values in an array (3 replies)
  214. VBA Userform (Excel 2016) - Textbox date calculations: Date + No. of days=Expiry Date (2 replies)
  215. Is there a cleaner way to write this formula? (3 replies)
  216. Spell check stopped working (2 replies)
  217. How can you use a variable to reference a worksheet object? (8 replies)
  218. Assign exact dates of material availability to each production order (0 replies)
  219. VBA Script locks the excel sheet (2 replies)
  220. Looping through combo box (1 replies)
  221. Copy Cell Values Using If Statements through VBA Code (8 replies)
  222. [SOLVED:] How Do I Change The Date Format in VBA Code (11 replies)
  223. Copy rows with specific values and paste within the same worksheet (1 replies)
  224. Code for selecting data and paste in another tab (7 replies)
  225. Auto Updating Row for Sum Grand Total (1 replies)
  226. [SOLVED:] syntax problem with a While nested into a Loop (for an Array) (17 replies)
  227. Call data from another sheet based on multi critiria (7 replies)
  228. Copy Values if name of sheets in two different workbooks are equal (1 replies)
  229. Find Copy and Paste (2 replies)
  230. [SOLVED:] Code for Pivot (1 replies)
  231. Filtered data in Listbox based on Option buttons EXCEL VBA (0 replies)
  232. problem getting internet values (0 replies)
  233. [SOLVED:] Excel Optionbutton Calculations (4 replies)
  234. [SOLVED:] Wrong customer apprearing (2 replies)
  235. Automation of Drop Down list (1 replies)
  236. [SOLVED:] I need to create a macro, but unsure of what formulas to put into it (5 replies)
  237. How to disable the sheets protection (2 replies)
  238. Excel VBA (1 replies)
  239. Can VBA record multiple iteration wb results with for next loop from a range of data? (5 replies)
  240. MAcro Creation Date (1 replies)
  241. If and Index and Match against a couple of different conditions (2 replies)
  242. Change the list contents in a cell, when changing the contents in another cell. (17 replies)
  243. Out of places to turn for Time and date stamp help (2 replies)
  244. Copying specific fields of multiple txt files into one master excel (1 replies)
  245. Most efficient way of finding the last row. (4 replies)
  246. INDEX/MATCH formula with INDEX return being in row higher than MATCH value (xlUP) (1 replies)
  247. Code to copy row if two criteria match (1 replies)
  248. VBA code for plotting ternary in excel (0 replies)
  249. Draw line around page margins (6 replies)
  250. Copy data from excel which receive in outlook mail (0 replies)