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

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