PDA

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

  1. Create a Code to update Date
  2. Calculate the product of two matrices
  3. create path to .pdf and extract sheet size
  4. lock workbook
  5. [SOLVED] Loop down vba Help
  6. [SOLVED] Formula/Macro to only display figures in a cell if a certain condition is met.
  7. Wildcard issues
  8. [SOLVED] Delete row with condition
  9. Spreading numbers problems in VBA code
  10. [SOLVED] Long length value convert to determine set length
  11. [SOLVED] Pivot in single sheet one below the other
  12. Help in Userform and data
  13. [SOLVED] Deleting rows older than 3 months
  14. Adding and Deleting a Sheet Dependent on Cell Content
  15. Listbox Not Populating - Source is dynamic named range
  16. [SOLVED] Select range of visible cells
  17. [SOLVED] userform text box formatting and exporting to word template
  18. Formatting Font Style and Size on Excel Chart with Marco
  19. max items in Array
  20. [SOLVED] SaveAs Error
  21. Help with Function
  22. Excel VBA insert Formulas below a table
  23. Specify Columns to Write File to CSV
  24. Need Help Deleting Rows Based on Column Values
  25. delete characters from string
  26. VBA to Insert Blank Row Based on Two Variables
  27. Code Help Request
  28. [SOLVED] Efficent arithmetic loop
  29. Refresh connection then close
  30. Copying data from one cell when other cell is between a time range
  31. Large Spreadsheet Calculations
  32. Sum two column criteria
  33. [SOLVED] Check Name and Save Workbook
  34. vba userforms - transparency png premultiplied alpha channel
  35. Match formula too slow
  36. Appending multiple text files to each other by name.
  37. [SOLVED] VBA code to fill missing data
  38. Radio Button Not Working
  39. UDF result wrong when cell with UDF copied to range
  40. Excel 2003 - Broken ActiveX
  41. Excel sheet to textfile
  42. [SOLVED] "A" shift vs "B" shift work days into calendar
  43. Copy a colum where add data in every year to another column
  44. Error 424 - Copy and paste b/w worksheets
  45. Need Help Sorting a List
  46. Calculate % trend reversal from last bank high
  47. [SOLVED] Help with Workbook_BeforeSave
  48. [SOLVED] Is there a VBA that will search all formulas in a sheet or book
  49. Make seperate columns range formula refer to cell in vba?
  50. VBA error
  51. Cant refer to graph from other sheet?
  52. A project assigned to me
  53. With keyword triggers Class_Terminate
  54. Time Calculation Dilemna
  55. [SOLVED] Make the ENTER key act like the TAB key.
  56. Need VBA help to create copies of template and populate sheets with data from Master
  57. [SOLVED] Autofilter: Filter between to dates
  58. [SOLVED] Change Data from String to Date: Runtime Error '1004'
  59. Run-time Error 1004
  60. [SOLVED] Excel won't load using 3rd party software
  61. [SOLVED] Separate content of a cell (merged or not) in columns
  62. how do i get the cell value from formula results (variable) in excel 2013 ?
  63. Slider effect
  64. chart with dynamic axis help
  65. [SOLVED] Compare two columns in different workbooks
  66. VBA Code to Compare a number of different worksheets and change/highlight differences
  67. [SOLVED] Help with an If and OR Statement
  68. Macro to Copy Paste Data from Source WB to Master WB in different folder sheet wise
  69. problem with VBA code( Ambiguous name detected)
  70. Mix Constants and Enumerators
  71. Macro to create an outlook appointment using specific cells in my spreadsheet & email
  72. COUNT WEEKS WITH BROKEN/UNBROKEN DATE RANGES WITH VBA
  73. Delete File if the specific cell is empty
  74. Generate a list without duplicated data and fill Start/End Date
  75. Syntax for sending email
  76. Copy the data from pdf to Excel VBA
  77. [SOLVED] Auto shape color change
  78. Run Dos Comand and store result in Excel.
  79. VBA Select Dynamic Data for Pivot Chart Monthly
  80. Send Excel data to Word
  81. Compressing long IF OR AND functions
  82. [SOLVED] Moving entire row of data based on two cell values
  83. Workbook with a series of errors
  84. Macro to compare date in cell to current date.
  85. [SOLVED] Excel Add In runtime error 4198
  86. Unicode in Excel-Cells
  87. Can someone help me narrow down a list of combinations.
  88. [SOLVED] Application.OnTime at Workbook_Open
  89. RDP via VBA Macro
  90. [SOLVED] Text Import Wizard Help
  91. Why the Excel is not opening as page in IIS?
  92. [SOLVED] Open Powerpoint file from Excel
  93. [SOLVED] Stop Read only
  94. [SOLVED] How to integrate a Loop
  95. [SOLVED] Can't refer to graph when using if statements?
  96. [SOLVED] Need help with ForEach-If-ElseIf situation
  97. Combine several sheets - Union, ADO, SQL, Consolidate, Formula?
  98. VBA in oil and gas prodaction
  99. Select a couple of cells per row
  100. [SOLVED] VBA Sum a range of variable rows with a value below a set amount and loop
  101. OnTime expertise needed
  102. Worksheet_Change to trigger a graph scale change
  103. VBA match 4 conditional values at once with Select Case.
  104. Totally new with VBA help please
  105. [SOLVED] Insert N cells for M new rows?
  106. [SOLVED] Autofill Form fields from external spreadsheet - Help please!
  107. Excel code to close an already openend access database
  108. [SOLVED] Try to Increment "To" Variable in "For To" but it's static.
  109. [SOLVED] Get number of last colored column
  110. Find Last Match, if no match use previous Match
  111. [SOLVED] Macro for setting up a printarea of random large quntaties of ranges
  112. How to Loop thru Column and Modify Values Based on User Input
  113. Excel 2013 is changes all General formatting to Date formatting...
  114. [SOLVED] Distribute rows from 1 ws into about 100 different workbooks and copy 2 ws to all.
  115. Keeping modeless userform on top
  116. Data Validation for a Range
  117. Run macro from another workbook
  118. Count colored worksheets
  119. VBA Data Transmission - Sound Output/Input
  120. Weighted Random Number generator
  121. Open Webpage use pg dwn, take a screen shot (print screen) and paste into excel
  122. VBA help - how to ungroup rows at level 2 only
  123. [SOLVED] Close Word UserForm from Excel
  124. VBA To Open & Close Files from a specified Folder
  125. Delete full line under condition
  126. [SOLVED] Extracting Data from Folder -- Want to Select Higher Level Folder
  127. Help with VBA
  128. Help with macros/VBA and formulas - Generating a report & recurring task
  129. [SOLVED] Print hidden chart
  130. [SOLVED] MACRO converter number to english letter
  131. [SOLVED] picking up every new unique name and counting the times it appears in a column (VBA)
  132. [SOLVED] Comparing Strings
  133. VBA Help - E-mail extract
  134. Problem with Instance Code
  135. VBA to Create new tabs based on Location
  136. [SOLVED] Case Sensitive Macro Help
  137. Lookup and insert rows
  138. Hyperlink to be revised help please
  139. Compare values from two excel sheets(columns) and check values one by one
  140. adding 3 column lines to a 3 column listbox
  141. Better way to search through 35000 lines?
  142. Copy table data
  143. If statement if cell is active?
  144. [SOLVED] Selecting sets of 21 Rows and saving as a csv
  145. [SOLVED] Calculating Last Vote
  146. [SOLVED] Need Assistance with a complex If And Then statement
  147. Help with macroes
  148. VBA for putting in 450 word documents into excel
  149. Re-arranging 1 row to multiple rows based on specific data
  150. VBA Help! Macro to find correct workbook from table name in cell
  151. VBA code not working correctly
  152. Form
  153. Macro emailing that includes a spreadsheet sum
  154. [SOLVED] Please help with formula
  155. Print Screen
  156. [SOLVED] How to select all rows down?
  157. Compiling data from selected excel files
  158. Update Worksheet from Listbox selected items
  159. VBA problem from complete amateur
  160. [SOLVED] Setting Boolean Using a Cell
  161. Save Worksheet as PDF but Ignore Hidden Rows
  162. Help with macro for solver using variable cells
  163. Call By Month aggregate
  164. Copy "My Sql" Query from worksheet and connect to MY Sql and get results
  165. Compiling data from selected excel files (with screenshots!)
  166. stop duplicates
  167. How to sum without using a worksheet function
  168. VBA Code - Based on Cell Value, macro inputs number into the cell that is next
  169. Insert & fill rows based on values if found in columns
  170. [SOLVED] Insert With Worksheet_Change (VBA)
  171. Quicksort code
  172. FORMULA TROUBLESHOOTING
  173. VBA control chart Y-Axis
  174. minimized userform pops up when new spreadsheet opened
  175. [SOLVED] Variable Array based on cell value
  176. Help with Printing/Exporting First Page of Multiple Sheets to Single PDF file
  177. Duplex Printing For 3 Hole Punched Paper
  178. From Excel, selecting Word text between headings
  179. Consecutive status in period of 15 minutes
  180. [SOLVED] Excel VBA - Change the current page of an already open PDF
  181. Combine Worksheets into Master Depending on ID
  182. Excel functions in VBA (basic question)
  183. [SOLVED] Trying to get a Macro to sort 4 digits
  184. Extract unique words from textbox
  185. Problem with Time-Data format
  186. [SOLVED] Open multiple VBE while using multiple monitors
  187. VBA Slide array defined by user in Excel
  188. macro loop to save .xml extension to .xls.
  189. excel 2010 - turn off cell updates, but keep calculations running
  190. Need a FOR Loop which selects all worksheets with a number in the worksheet name
  191. Keep Lowest value row
  192. Why my VBA code runs faster when clicking on the Immediate Window?
  193. [SOLVED] Excel VBA Application Object
  194. Insert Row in Table Linked to PowerPoint
  195. VBA Script for changing grouped data names in multiple pivot tables
  196. Problem with creating Array
  197. EXCEL, VBA, DLL
  198. [SOLVED] How to replace a symbol like ≤ by using VBA?
  199. Help Needed: filtering data from to sheets in another sheet currency wise
  200. [SOLVED] Macro to copy from Merged Cells (Same Range) to Columns of a New Worksheet
  201. conditional formatting based on other cell (over multiple Rows & Column)
  202. [SOLVED] Efficiently searching text array?
  203. Need Help Writing Macro to Simulate Roulette Spins
  204. [SOLVED] Create a Named range for each Unique Value in Column
  205. Macro Loop to Copy/Paste picture and set of columns if Checkbox
  206. [SOLVED] Macro filtered in column no fill cells in selected sheets
  207. Vlookup in vba isn't working
  208. Can someone critique my code please
  209. VBA for Pivot Tables and Slicers
  210. [SOLVED] Macro to find duplicates in a column and add the cell contents together
  211. VBA code to import data from a website
  212. [SOLVED] Unable to remove "Overflow" message while running the macro
  213. Creating button by offsetting space
  214. [SOLVED] Importing Worksheets from different Workbook
  215. Create button with different Find range
  216. Open all Zipped files within folder of the xlsm file.
  217. [SOLVED] Excel VBA User Form ( Need Help here please )
  218. macro to search & copy columns from another workbook
  219. [help][Important to learn VBA] export the list of classes from VBA Object libraries
  220. List to Labels
  221. Formula Conumdrum Is Excel up to it.
  222. HELP VBA code
  223. Need to replace SUMIFS function with VBA code
  224. Recordset B takes longer to copy/paste to worksheet than Recordset A, but is smaller!
  225. help to write VBA code for ignoring cells with "0" in them (I'm new to this..)
  226. [SOLVED] VBA-highlight cell(s) in a column range if empty or greater than a value
  227. How to select highlighted cells as dynamic range?
  228. Need formula for this
  229. Dynamic Table Using Reference Cells to Adjust Size
  230. Deleting two buttons with similar names
  231. vba to insert vlookup between workbooks
  232. Run-time error 402 for Userform
  233. Use Find in a loop
  234. VBA: Get Range of found cell
  235. [SOLVED] Removing the Zeros from Blank Cells
  236. Chart creation basis dropdown value
  237. [SOLVED] How to create a Macro Pivot Table where the range changes?
  238. Round Robin Triggered by Button Click
  239. Edit/Delete Data Row
  240. [SOLVED] Pivot Table error - Tabular format
  241. Change file name & path with formula or macro
  242. Age Calculate from textobx
  243. Stepping through cells in a range
  244. Help with .Find and .FindNext in VBA
  245. [SOLVED] Protecting Passwords and Workbook expiration date
  246. VBA Filter problem
  247. [SOLVED] Want help with a tricky sorting Macro
  248. Referring formulas to next row in spreadsheets (Shapes)
  249. VBA - Vertical organization display on set chart
  250. VBA TANKER volume HELP