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. message box
  2. Return values from a cell
  3. Read Only Visible Columns from a range
  4. CDO attaches all file in Loop
  5. Refreshing external data on individual sheets in a specific sequence.
  6. Solved: how to find the value with 2 conditions
  7. Solved: If Statement Using Named Ranges
  8. Join two tables with conditions
  9. Split a string
  10. Lots of problems, excell beginner
  11. Solved: HTTP File Download
  12. Solved: CODE TO CLEAR ROW CONTENTS BASED ON MATCH NAME
  13. Solved: Delete Row From UF
  14. Bold text in userform tabs
  15. Referencing Data in a different location
  16. data control
  17. Solved: Leading Zero with a twist
  18. Custom Function Help Features
  19. Update value window
  20. Textbox Macro Comes Up Empty
  21. Solved: Use Worksheet Variable in vlookup code
  22. PageBreak, AutoFilter, SpecialCells
  23. How to format chart?
  24. VBA Tutor wanted in Philadelphia area
  25. Excel VBA Worksheet Consolidation Help
  26. Point to pixel conversion
  27. Copy dat to another sheet Macro
  28. Delete Excel sheet without prompt
  29. [SLEEPER:] Problem with Application.Quit
  30. SOLVED: Delete row with Autofilter takes ages after ADO code
  31. Select first non-hidden row below starting cell
  32. Solved: Normal distribution
  33. Solved: Comma delimited CSV
  34. Solved: Hyperlink Cell to Include Cell Value in Link
  35. Solved: Dates in text String
  36. Solved: Closing file takes A LONG TIME
  37. [SLEEPER:] Print PDF
  38. Count number of .pst files from excel vba
  39. Getting file name from sharepoint
  40. Hyperlinks to many Sheets within a Workbook
  41. Solved: AutoFilter
  42. Solved: Custome Function Returns Wrong Value
  43. check multiple conditions in a excel sheet through VBA
  44. Need help with Range
  45. Solved: Custom Function for UpTime Calculation
  46. Solved: Formula not entered by macro
  47. Change Read-Only Status (Excel '97)
  48. How to Join 2 Macro into 1
  49. [SOLVED:] Moving data from columns to rows
  50. Show picture in Userform
  51. Solved: Sumproduct Syntax
  52. Solved: If Cell is certain value THEN hide rows
  53. Call vba function from flash embedded in excel
  54. Help with cell referencing
  55. Solved: Column Heading Search
  56. Solved: UDF, VBA or Formula for multi-conditional SUMIF?
  57. How to calculate loss or profit for multiple trades
  58. Solved: Row Color Range When Cell Changes Color
  59. [SOLVED:] Clearing a Userform
  60. Check if CommandBarPopup exists
  61. Updating Data on a Worksheet from a Userform (Excel '97)
  62. Solved: Runtime Error 1004 for Application.Username
  63. Changing function input from Cell dropdown to Combobox
  64. Solved: Preventing Excel from opening in IE
  65. Copy Worksheet code needs to copy VALUES
  66. Extracting Chart Data and Automated VBA Procedure for Slope
  67. Solved: Chart ControlTipText
  68. Solved: Formatting with Calulated Values
  69. Copying Values and Pictures into new workbook: VBA
  70. Solved: Populating a Listbox from multiple name ranges (Excel '97)
  71. [SOLVED:] Auto attach Worksheet to new outlook email
  72. Solved: How to stop it closing??!!
  73. Solved: prevent typing in a Data Val drop-down
  74. [SLEEPER:] latency issue with web query?
  75. Macro HELP PLEASE
  76. Solved: 'Else without If' error...
  77. tough charting code
  78. [SOLVED:] percentual match of cells
  79. [SLEEPER:] custom 'Filename' function
  80. [SOLVED:] Compile all xls file column by column
  81. How to Show Blank Cell Instead Of #DIV/0!
  82. Solved: Search rows and copy and save them
  83. Extend Daily Dates series excluding Weekends with latest dates
  84. If statement to look for now()-1 in another file
  85. Solved: MOVE ROWS UP TO BLANK ROW
  86. Import Word 2007 Form Into Excel
  87. If dates match then add
  88. Saving a WB to Sharepoint
  89. Solved: Another 'Else without If' error!
  90. Solved: VBA how to Delete Empty / Valueless Series from Chart
  91. Solved: Before Close unfilter on protected/shared workbook
  92. Excel 2007 issue
  93. Pivot Table error
  94. Solved: Using IF command SUM copy paste special
  95. chart automation
  96. Move Text File After Importing to Excel
  97. Solved: if it contains an O
  98. Solved: FileName saving not working
  99. Progress Bar for refreshing pivot caches
  100. Solved: how to change direction of move after Enter in one sheet
  101. Solved: Close workbooks
  102. FileName Manipulation Problem
  103. Want to create a button at menubar
  104. Userform Contacts.
  105. How to build a command string to execute
  106. *** Compare range heading and then values in the columns
  107. Solved: Dependents and Precedents
  108. [SOLVED:] Force user to go only to next row in a spreadsheet
  109. Copying multiple sheets
  110. Find Text in a Woksheet
  111. Solved: Modifying regex to accept comma's?
  112. compiled error of "method or data member not found excel".
  113. macro
  114. blank page problem
  115. Delete character in cell
  116. Summarizing from multiple sheets in same workbook
  117. Macros & Input Boxes
  118. Solved: Trapping a FillDown event
  119. Format output
  120. Subtotal Error
  121. Solved: Conditionally changing a cell's font colour with a function
  122. Solved: Aggregate records entered for 2008
  123. Solved: conflicting vba Button and select change event
  124. Solved: Macro coding help.
  125. Worksheet_BeforeDoubleClick question
  126. gsm table
  127. Need Help on Userform
  128. Excel adds wrong pathname to macro name
  129. Pivot Table Count ?
  130. Issues with Hyperlinks
  131. Solved: Perform action based on conditional formatted colour?
  132. Solved: Interesting...
  133. Solved: VBA VLookup Problem (Excel '97)
  134. [SLEEPER:] Error in Excel 2007
  135. auto addition of gridlines
  136. Solved: InputBox Help needed
  137. Solved: problem filling empty cells
  138. Array takes out the parentheses
  139. Optimization with for each
  140. Relist Column
  141. Solved: Pop up message removal
  142. multiple text to excel + filename
  143. Send "Enter" to mainframe
  144. Solved: Custom Function to Calculate Response Time
  145. Solved: Generating an email in Excel- adding signature
  146. Solved: Convert csv file to xls format
  147. Solved: Copy Error creating 35mb file...:(
  148. Autoselect relevant range for Sumproduct function
  149. userform listbox query
  150. HEX file (".bmp") into EXCEL
  151. Percentile
  152. Solved: Excel to Word Number Formatting
  153. Understanding a Function
  154. Highlighting rows inside first empty cell loop
  155. Solved: open file with a date variable
  156. Solved: Switching between Multipage tabs
  157. Find Text then insert formula in same row
  158. Solved: It sounds simple yet I can not overcome.
  159. Solved: Delete Spaces in text but not numbers.
  160. Deleting Rows - Defined Names
  161. Solved: countifs in excel 2003
  162. Solved: Unprotect Work sheet to allow Macro to run
  163. help in entry in excel access
  164. Selecting all sheets but....
  165. [SLEEPER:] Format Datalabel
  166. sending mails only to filtered persons
  167. Solved: working with multiple open workbooks
  168. Complex Lookup
  169. Solved: Vlookup From Userform
  170. Solved: Printing Selected xlVeryHiddenSheets
  171. creating shared workbooks (excel 2007)
  172. Is it possible to store calculation results in VBA Memory?
  173. Solved: check range of numbers conditionnaly
  174. Solved: Determine if Userform is Loaded
  175. Solved: runtime error 9 when decomposing cells
  176. VBA for MORE Conditional Formating Excel 2003
  177. Solved: object variable coming in lower case
  178. Solved: enter current time in a current cell
  179. Autofilter change
  180. Multiple files imported to specified tabs script
  181. Text strip send
  182. Dropdown Box Loop
  183. Can this basic code be refined?
  184. Next Record / Previous Record
  185. Solved: Create copy of worksheet plus code in the same workbook
  186. Solved: Stop buttons from printing
  187. avoid "error 400"
  188. Open hyperlink to PDF on website and save file
  189. Modules vanishing - bug?
  190. Solved: vlookup and dates
  191. Solved: Date formatting
  192. Solved: User Form question
  193. Data validation with dynamic range
  194. Solved: Sumif/Sumproduct Across Columns & Rows
  195. return to textbox
  196. finder
  197. calling python from VBA, excel
  198. Solved: Can I use a different (closed) workbook for a listbox rowsource? (excel '97)
  199. Solved: Login Screen / Password Call & Validation Issue
  200. problem writing after last used row
  201. Checkboxes
  202. problem replacing string by another one
  203. Excel error ---------- please help
  204. macro code to switch worksheets?
  205. Compressing VBA Code length
  206. Error handling odd problem
  207. Inventory Examples.
  208. [SOLVED:] Track Changes in Comment
  209. Solved: Creating main folder and sub directories
  210. RegEx Split String
  211. Solved: Same cell address on different sheet comparison problems
  212. TreeView node images
  213. Solved: A kind of Back button in sheet for other sheets
  214. Solved: footer code error
  215. Subtotal Macro Formula Help
  216. Solved: Execute multiple subs or one large sub
  217. Solved: Excel - Text to rows
  218. Solved: Pivot Table Formulas
  219. Controlling child web pages of pages opened w/ Excel
  220. [SLEEPER:] Code Optimization: Running too slow
  221. Format selected cells within filtered range
  222. Solved: Spreadsheet control 2007
  223. Delete all files in a directory
  224. Remove or Bypass the 'File Reservation' Dialogue?
  225. CheckBox code repetition
  226. Solved: Max 2 decimals allowed in cell
  227. Solved: Text to Rows
  228. Solved: Auto Update Links on a Mapped Drive
  229. Solved: Merge the Data
  230. [SOLVED:] Select multiple rows based on cell value
  231. Solved: Arrange/Lag Data in columns By Specfied Lags
  232. Find certain criteria delete that row and the next 5 rows as well
  233. Solved: Run Macro Whilst Editing
  234. Solved: format cells based on 2 criteria
  235. Solved: Multiple messages boxes
  236. ListBox Objects?
  237. Controlling web checkbox and buttons FORM type POST
  238. Solved: Insert-Delete Rows with formulas
  239. [SOLVED:] Transpose data in columns into rows using a primary key
  240. Add formula dynamically to different sheets
  241. Macro Idea for find and edit
  242. Modify Email macro to check cells for entry prior to emailing.
  243. Solved: VBA to import files to sheets
  244. Excel Advanced Filter
  245. Solved: unload userform before worksheet deactivate
  246. Edit Work Sheet Whilst Msg Box Remains Open
  247. Solved: Unable to delete custom toolbar created in excel 2003.
  248. Add blank row after each record
  249. Solved: Autoconstruct Forecast Formula from Linest function based on number of variables
  250. find unknown values which adds up to some values