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 163 164 165

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