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:] Help With Macro to Attach Multiple Items To Outlook (4 replies)
  2. VBA to save as not saving values. (10 replies)
  3. Copy and Insert Rows based on value in column R (3 replies)
  4. Combo Box selection = 2 values set (4 replies)
  5. [SOLVED:] Loop through the record and summarized (4 replies)
  6. Excel crashing after running macro to work with autocad and after deleting column (3 replies)
  7. [SOLVED:] Creating a history (7 replies)
  8. Loop through specific range of dates do something and then do it again for new date r (3 replies)
  9. [SOLVED:] Checkboxes (2 replies)
  10. [SOLVED:] Searching for date in array (4 replies)
  11. VBA to copy files ( list ) from location ( different locations ) to another folder (3 replies)
  12. [SOLVED:] add random picture to Image in Userform (1 replies)
  13. Remove cell data for numbers over an average amount (6 replies)
  14. [SLEEPER:] Index into specificied collection is out of bounds error (1 replies)
  15. Creating a database using a VBA code with user from (7 replies)
  16. Search in multiple workbooks to identify duplicate values (1 replies)
  17. Add sequential # to userform once saved (11 replies)
  18. parsing txt log to excel table (8 replies)
  19. [SOLVED:] Delete cell data if value is high (6 replies)
  20. A-Z processing of folders (8 replies)
  21. VBA not working (20 replies)
  22. [SOLVED:] Helping a student automate a couple of sheets (22 replies)
  23. [SOLVED:] Copy and paste loop help (4 replies)
  24. Triggering a VBA Sub with DDE/RTD (28 replies)
  25. [SOLVED:] Problem with .Find in Loop. (2 replies)
  26. Activex Controls Combo Box unique values (4 replies)
  27. Track updated data in table (1 replies)
  28. [SOLVED:] time degrees to decimal degrees (3 replies)
  29. Macro to Edit Links ? (12 replies)
  30. Pivot 1004 run error why? (2 replies)
  31. How to make excel vba crash proof? (8 replies)
  32. [SOLVED:] Macro not working while sending email (7 replies)
  33. Pivot table Error (1 replies)
  34. [SOLVED:] VBA to add series to graph only if data in column. (2 replies)
  35. Clear and restore conditional formatting of different cells before printing (3 replies)
  36. VBA code for Data Entry (13 replies)
  37. [SOLVED:] Vlookup or indirect,Help (8 replies)
  38. counting non numeric with pivot tables (4 replies)
  39. Delete duplicate rows based on 2 conditions using VBA Macro (Beginner) (2 replies)
  40. Acceleration of working Script. Ideas? (2 replies)
  41. Using Calculated Field to Return the Difference Between Two Columns (1 replies)
  42. Generate a series of column data with a condition (2 replies)
  43. VBA to help copy and paste few columns from pivot table 2 another table within sheet (10 replies)
  44. Formula visible cells (1 replies)
  45. Macro to format 2 cells adjacent to each other (9 replies)
  46. [SOLVED:] Sort using the active cell value (3 replies)
  47. Import data and remember file path (1 replies)
  48. [SOLVED:] Build parent/child hierarchy (5 replies)
  49. Pivot Table VBA (5 replies)
  50. Problems with Sum Function (5 replies)
  51. Get the reference from other sheet & go next row automatical (2 replies)
  52. [SOLVED:] Filtering data on multiple conditions (12 replies)
  53. [SOLVED:] Bulk Export Worksheet Code (11 replies)
  54. Deleting text after a specific character (1 replies)
  55. Copying table to another sheet on worksheet change (4 replies)
  56. [SOLVED:] Inserting Picture (2 replies)
  57. Send or data transfer multiple conditions (12 replies)
  58. Text Comparison between a column and a table is not working. (5 replies)
  59. Run time Error 1004 - Unable to get the Picture Class..(Inserting URL images) (4 replies)
  60. [SOLVED:] resize word pictures (3 replies)
  61. VBA insert formula based on another cell selection (1 replies)
  62. [SOLVED:] Need help constructing a vba code to show frequency of given values within delim data (2 replies)
  63. [SLEEPER:] RANDBETWEEN not stopping (2 replies)
  64. transfer data (9 replies)
  65. Visual Basic run-time error 1004 work around (13 replies)
  66. Using Input Box Variable (3 replies)
  67. Formulas with Minus (2 replies)
  68. [SOLVED:] Newbie help on row count as range (5 replies)
  69. Double Type error 13 (2 replies)
  70. Running Code in Visual Basic Window Versus in Excel (7 replies)
  71. Userform vlookup, copy row data, display each found in sequential order in same form (1 replies)
  72. Selecting the row with the highest value (4 replies)
  73. Creating and displaying 16 frames on a userform each frame two labels. (6 replies)
  74. [SOLVED:] Loop values from data validation list vba (12 replies)
  75. Count if vs a trade with 'todays date formula' help (2 replies)
  76. Filter ShapeCount for Grouped Shape (4 replies)
  77. [SLEEPER:] objFolder.GetDetailsOf not working (21 replies)
  78. Problem in converting charts in workbooks to pictureP (2 replies)
  79. How to get the name of USB port name (6 replies)
  80. Using Excel VBA to Scrape Web Table Data (0 replies)
  81. Find and Replace (2 replies)
  82. [Novice] VBA Looping Macro (6 replies)
  83. Email macro (0 replies)
  84. [SOLVED:] Show Area of Freeform Shape (7 replies)
  85. Mass Find and Replace VBA - Need Help (13 replies)
  86. Programatically Add Reference (1 replies)
  87. [SOLVED:] Speed up VBA code (8 replies)
  88. [SOLVED:] Modifications to macro that copies cells that contain the name of a worksheet (2 replies)
  89. Help in VBA to transfer data into multiple files in a folder (5 replies)
  90. Do tables work with well macros. (4 replies)
  91. Saving Autocorrect entries into different languages using VBA (0 replies)
  92. [SOLVED:] Send Data to Alternate Userform (2 replies)
  93. Run time error help (4 replies)
  94. Variable in Loop (6 replies)
  95. Link last Checkbox in Column to Cell below (3 replies)
  96. update date automatically hen saved (3 replies)
  97. How do I populate a listbox in Excel Userform with data from the non active sheet (7 replies)
  98. [SOLVED:] hh:mm:ss conditional formatting (7 replies)
  99. [SOLVED:] Need Help with this macro, please! need to return unque values from within range (7 replies)
  100. Pivot Table: pct by rows (0 replies)
  101. Customer accounts balance(debt,credit) vba (0 replies)
  102. email macro stops on Debug Run-time error '91' (1 replies)
  103. Clock not working properly (2 replies)
  104. Email macro works 1 time on excel sheet and stops (1 replies)
  105. VBA Coding help - Multi-page User Form, vlookup, and INTERCEPT (0 replies)
  106. [SOLVED:] Split Cells that have Alt+Enter Text Into Multiple rows and fill rows accrodingly. (8 replies)
  107. Select PivotItems from to... (1 replies)
  108. VBA - Draw line to next high value (3 replies)
  109. Listing rows associated to a value in Col A, by selecting related value in Col B (0 replies)
  110. VBA Macro for taylor Series of Sine (x) (2 replies)
  111. Any suggestion for VB self-learning resources? (0 replies)
  112. [SOLVED:] How to count no of shapes in a group? (2 replies)
  113. VBA code help to sum values in conditionally formated cells (2 replies)
  114. stop incrementing (4 replies)
  115. Automatically increment single cell from 15 to 150 (3 replies)
  116. VBA Code for Searching\Renaming files in a folder (2 replies)
  117. VB Excel, Data Not able to auto refresh (2 replies)
  118. VBA - Finding a value in column A, selecting that row, pasting it above with formulae (4 replies)
  119. dynamic graph based on drop down list (5 replies)
  120. Looping Countifs with Excel Formulas (0 replies)
  121. Automatically pull new data VBA (4 replies)
  122. Filter/sort columns in another sheet (3 replies)
  123. Transpose or Copy Text from text to another Text box and Undo when necessary (0 replies)
  124. [SOLVED:] File not found error when trying to attach PDF to Email (2 replies)
  125. If M column starts with phone number shift K,L and M cells left. (2 replies)
  126. Problem for salary calculation (4 replies)
  127. [SOLVED:] excel vba search text in range and retrieve results in a textbox (3 replies)
  128. [SOLVED:] Type mismatch error on startup (5 replies)
  129. Excel templates to PDF (6 replies)
  130. [SOLVED:] How to compare two Strings and do some find-copy-paste operation (12 replies)
  131. COMBING MACROS (3 replies)
  132. Integer Overflow (11 replies)
  133. [SOLVED:] VBA code to find the string and paste the whole sentence in another cell (2 replies)
  134. [SOLVED:] Copy Paste Ranges - Listed in Column A (6 replies)
  135. [SOLVED:] Show the Solver Dialog Box (3 replies)
  136. Next record problem (3 replies)
  137. [SLEEPER:] How do I save a value from a combobox on a userform to my sheet where ...... (4 replies)
  138. Excel2013 or 2016 on Android Tablet with VBA (3 replies)
  139. Populate spreadsheet cells based on multi select listbox and combo boxes (1 replies)
  140. Retention Report Automation (15 replies)
  141. How to search column and highlight values that are not in dictionary? (9 replies)
  142. Can't copy cells' content into another workbook (0 replies)
  143. [SOLVED:] VB Excel, Count shapes with same color (4 replies)
  144. Inventory System (4 replies)
  145. [SOLVED:] UserForm RowSource Named Range Crashes (5 replies)
  146. Having an Excel file open a website at a specified time (3 replies)
  147. [SOLVED:] Revert Scientific Notiation to the Text that was Entered (9 replies)
  148. [SOLVED:] Finding the active cell in other work book (8 replies)
  149. Msg Box if cell left blank (3 replies)
  150. [SLEEPER:] How to setup clock as per zones, macro should work when excel is open (11 replies)
  151. [SOLVED:] Need help to transform one spreadsheet into another form of spreadsheet. (18 replies)
  152. paste as text from other applications (3 replies)
  153. VBA Error 91 (4 replies)
  154. Copy one cell of a worksheet of a workbook and paste to a master workbook many times (1 replies)
  155. Vba Web Project - Data from web to Excel sheet (0 replies)
  156. User Defined Function not working when entered in Excel (6 replies)
  157. remove line or lines from a text file using vba if checkbox is true (10 replies)
  158. sum every sheet cell into a sheet easy (3 replies)
  159. How to search substring against range and if found remove it? (41 replies)
  160. Extracting Unique Values in Column that meets criteria (1 replies)
  161. Excel VBA to download file from url (0 replies)
  162. How to search a specific text constellation? (13 replies)
  163. How to search a specific text constellation? (0 replies)
  164. Sleeper: Need help to create Scatter plot chart through VBA code (4 replies)
  165. Save a copy of an excel file as Read Only (3 replies)
  166. [SOLVED:] Need help Restructuring current macro to translate different type of data, please!!! (2 replies)
  167. Can you search sort for a specific color and number (2 replies)
  168. [SOLVED:] Need help with current macro run the x vlaues as letters. Please!!! (2 replies)
  169. VBA HELP!!! (5 replies)
  170. Searching for cells that contain a specific text constellation (2 replies)
  171. [SOLVED:] Calculate power (13 replies)
  172. Make code shorter (5 replies)
  173. [SLEEPER:] Macro that highlights specific rows yellow if a cell is green and a date varies (4 replies)
  174. [SOLVED:] Need to create a separate worksheet for each row of data (14 replies)
  175. Delete all rows except names input by user (4 replies)
  176. date pick error (5 replies)
  177. range of object failed xcel 2013 (2 replies)
  178. match work sheets (1 replies)
  179. [SOLVED:] WINHTTP Request Returns NOT FOUND and UNAUTHORIZED ACCESS (VBA EXCEL) (7 replies)
  180. [SOLVED:] Macro to move back to previously active cell (9 replies)
  181. Return the value to the right of the cell (7 replies)
  182. VBA does not print (0 replies)
  183. [SOLVED:] vba code to offset negative values - left or right and make positive (2 replies)
  184. Help with lookup formula (5 replies)
  185. How to Call a user defined input within range function ? or Global Call ? (6 replies)
  186. [SOLVED:] Multiple Dependent Checkbox to hide unhide sheet (10 replies)
  187. Split Multiple worksheets to Multiple Workbook based on Column Value (0 replies)
  188. [SOLVED:] Loop through each excel file in a folder (8 replies)
  189. [SOLVED:] import a .csv generated from a php website link (9 replies)
  190. Print PDF batch scripting for a noob (3 replies)
  191. [SOLVED:] VBA operator problem (15 replies)
  192. Gathering sheet names and displaying them in a specific sheet column (3 replies)
  193. [SOLVED:] Verify no files are open in a folder (10 replies)
  194. [SOLVED:] At my wits end (21 replies)
  195. VLOOKUP question (3 replies)
  196. Unable to fill text box of a #32770 window [EXCEL-VBA] (1 replies)
  197. what should be the VBA code for my problem? (1 replies)
  198. VBA Open a Excel file and then copy charts to other excel file which is already open (1 replies)
  199. Creating a curve graph to show negative position to positive position (0 replies)
  200. Cannot get excel to email sheet via outlook (2 replies)
  201. Changing cell color (3 replies)
  202. VBA code to automatically click an element of a toolstrip (0 replies)
  203. [SOLVED:] Selecting a file to email from Excel 2010 (2 replies)
  204. VBA code in Excel opens Word template and fills bookmarks, but can't get correct form (2 replies)
  205. [SOLVED:] Help locking a column to prevent editing. (3 replies)
  206. Help with formula for scenarios (8 replies)
  207. Display warning alerts (2 replies)
  208. [SOLVED:] Generating random outcomes based on probability (2 replies)
  209. [SOLVED:] Point in Polygon (13 replies)
  210. Get oldest file from the folder (14 replies)
  211. Named Range !REF# error (4 replies)
  212. Need Macro Help for making Transpose List (3 replies)
  213. Compare three work sheets problem (1 replies)
  214. Need help! constr a macro that copies data and pastes in multiple new range in WB (0 replies)
  215. [SOLVED:] Need help rearranging VBA to search from a rangei a range for duplicates to HL please (4 replies)
  216. Calculate Net Salary (4 replies)
  217. Excel - lock range of cells in a row based on value in a cell (4 replies)
  218. [SOLVED:] How to post only the SaveAs location that a user selects to a Worksheet cell (1 replies)
  219. Formula for value in Row (0 replies)
  220. From DDL field (5 replies)
  221. Delete is taking to long, and I dont know another way to do it. (17 replies)
  222. VBA transfer columns from two reference sheets to a master sheet with different colum (2 replies)
  223. [SOLVED:] Disable right click insert rows (2 replies)
  224. Problem changing cell color on button click (1 replies)
  225. Need help with program deleting rows (5 replies)
  226. Save the workbook with a time stamp in the same folder (6 replies)
  227. Auto update data to diffrent columns VBA code needed (0 replies)
  228. Source Password Protected (5 replies)
  229. Stop auto text to columns upon opening (4 replies)
  230. only run one email command and other processes based on user prompt using excel vba (0 replies)
  231. [SOLVED:] Something like vlookup (8 replies)
  232. [SOLVED:] Combining Columns into One (1 replies)
  233. Code to generate plots for different variables with different range in loop manner (0 replies)
  234. [SOLVED:] Unable to select a value in a DropDown List in a Webpage using VBA (1 replies)
  235. [SOLVED:] VBA Loop Through all open Workbooks (2 replies)
  236. [SOLVED:] Textbox validation (3 replies)
  237. Create OLAP Connection in Excel 2010 via VBA Code under the Button (0 replies)
  238. [SOLVED:] ComboBox Linked Cell (1 replies)
  239. VBA Code for Combing Lists (2 replies)
  240. [SOLVED:] I need help fixing macros to high light the correct data. please need help with this! (6 replies)
  241. [SOLVED:] Rename excel worksheets based on values contained in 1 excel tab (7 replies)
  242. Send multiple different pdf to contacts on list (5 replies)
  243. [SOLVED:] VBA to Verify Data (5 replies)
  244. [SOLVED:] Link embedded objects (10 replies)
  245. Sending Email from excel cell with attachment (1 replies)
  246. [SOLVED:] call shell and execute in cygwin using excel vba (4 replies)
  247. [SOLVED:] Tricky one, Changing vertical list to horizontal list... (6 replies)
  248. [SOLVED:] Need help restructuring a coloring cells code macro. (0 replies)
  249. Click event for a group of option buttons in a Frame (4 replies)
  250. Background cell color on filter in vba (3 replies)