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