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 166 167 168 169 170 171 172 173 174

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