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