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

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