Log in

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

  1. Next Record / Previous Record (12 replies)
  2. Can this basic code be refined? (4 replies)
  3. Dropdown Box Loop (4 replies)
  4. Text strip send (5 replies)
  5. Multiple files imported to specified tabs script (5 replies)
  6. Autofilter change (2 replies)
  7. Solved: enter current time in a current cell (14 replies)
  8. Solved: object variable coming in lower case (2 replies)
  9. VBA for MORE Conditional Formating Excel 2003 (27 replies)
  10. Solved: runtime error 9 when decomposing cells (7 replies)
  11. Solved: Determine if Userform is Loaded (3 replies)
  12. Solved: check range of numbers conditionnaly (5 replies)
  13. Is it possible to store calculation results in VBA Memory? (13 replies)
  14. creating shared workbooks (excel 2007) (1 replies)
  15. Solved: Printing Selected xlVeryHiddenSheets (2 replies)
  16. Solved: Vlookup From Userform (17 replies)
  17. Complex Lookup (1 replies)
  18. Solved: working with multiple open workbooks (5 replies)
  19. sending mails only to filtered persons (2 replies)
  20. Format Datalabel (1 replies)
  21. Selecting all sheets but.... (5 replies)
  22. help in entry in excel access (4 replies)
  23. Solved: Unprotect Work sheet to allow Macro to run (2 replies)
  24. Solved: countifs in excel 2003 (6 replies)
  25. Deleting Rows - Defined Names (2 replies)
  26. Solved: Delete Spaces in text but not numbers. (5 replies)
  27. Solved: It sounds simple yet I can not overcome. (3 replies)
  28. Find Text then insert formula in same row (1 replies)
  29. Solved: Switching between Multipage tabs (2 replies)
  30. Solved: open file with a date variable (6 replies)
  31. Highlighting rows inside first empty cell loop (6 replies)
  32. Understanding a Function (2 replies)
  33. Solved: Excel to Word Number Formatting (3 replies)
  34. Percentile (2 replies)
  35. HEX file (".bmp") into EXCEL (1 replies)
  36. userform listbox query (1 replies)
  37. Autoselect relevant range for Sumproduct function (5 replies)
  38. Solved: Copy Error creating 35mb file...:( (2 replies)
  39. Solved: Convert csv file to xls format (3 replies)
  40. Solved: Generating an email in Excel- adding signature (6 replies)
  41. Solved: Custom Function to Calculate Response Time (5 replies)
  42. Send "Enter" to mainframe (2 replies)
  43. multiple text to excel + filename (7 replies)
  44. Solved: Pop up message removal (3 replies)
  45. Relist Column (7 replies)
  46. Optimization with for each (6 replies)
  47. Array takes out the parentheses (3 replies)
  48. Solved: problem filling empty cells (6 replies)
  49. Solved: InputBox Help needed (13 replies)
  50. auto addition of gridlines (5 replies)
  51. Error in Excel 2007 (7 replies)
  52. Solved: VBA VLookup Problem (Excel '97) (4 replies)
  53. Solved: Interesting... (2 replies)
  54. Solved: Perform action based on conditional formatted colour? (43 replies)
  55. Issues with Hyperlinks (0 replies)
  56. Pivot Table Count ? (2 replies)
  57. Excel adds wrong pathname to macro name (4 replies)
  58. Need Help on Userform (4 replies)
  59. gsm table (2 replies)
  60. Worksheet_BeforeDoubleClick question (2 replies)
  61. Solved: Macro coding help. (2 replies)
  62. Solved: conflicting vba Button and select change event (5 replies)
  63. Solved: Aggregate records entered for 2008 (11 replies)
  64. Solved: Conditionally changing a cell's font colour with a function (7 replies)
  65. Subtotal Error (5 replies)
  66. Format output (4 replies)
  67. Solved: Trapping a FillDown event (3 replies)
  68. Macros & Input Boxes (8 replies)
  69. Summarizing from multiple sheets in same workbook (8 replies)
  70. Delete character in cell (1 replies)
  71. blank page problem (3 replies)
  72. macro (2 replies)
  73. compiled error of "method or data member not found excel". (1 replies)
  74. Solved: Modifying regex to accept comma's? (4 replies)
  75. Find Text in a Woksheet (4 replies)
  76. Copying multiple sheets (2 replies)
  77. [SOLVED:] Force user to go only to next row in a spreadsheet (11 replies)
  78. Solved: Dependents and Precedents (12 replies)
  79. *** Compare range heading and then values in the columns (1 replies)
  80. How to build a command string to execute (6 replies)
  81. Userform Contacts. (2 replies)
  82. Want to create a button at menubar (2 replies)
  83. FileName Manipulation Problem (5 replies)
  84. Solved: Close workbooks (8 replies)
  85. Solved: how to change direction of move after Enter in one sheet (4 replies)
  86. Progress Bar for refreshing pivot caches (2 replies)
  87. Solved: FileName saving not working (4 replies)
  88. Solved: if it contains an O (1 replies)
  89. Move Text File After Importing to Excel (2 replies)
  90. chart automation (1 replies)
  91. Solved: Using IF command SUM copy paste special (4 replies)
  92. Pivot Table error (1 replies)
  93. Excel 2007 issue (0 replies)
  94. Solved: Before Close unfilter on protected/shared workbook (1 replies)
  95. Solved: VBA how to Delete Empty / Valueless Series from Chart (3 replies)
  96. Solved: Another 'Else without If' error! (3 replies)
  97. Saving a WB to Sharepoint (2 replies)
  98. If dates match then add (3 replies)
  99. Import Word 2007 Form Into Excel (0 replies)
  100. Solved: MOVE ROWS UP TO BLANK ROW (4 replies)
  101. If statement to look for now()-1 in another file (5 replies)
  102. Extend Daily Dates series excluding Weekends with latest dates (7 replies)
  103. Solved: Search rows and copy and save them (4 replies)
  104. How to Show Blank Cell Instead Of #DIV/0! (2 replies)
  105. Solved: Compile all xls file column by column (6 replies)
  106. custom 'Filename' function (2 replies)
  107. [SOLVED:] percentual match of cells (8 replies)
  108. tough charting code (6 replies)
  109. Solved: 'Else without If' error... (3 replies)
  110. Macro HELP PLEASE (5 replies)
  111. latency issue with web query? (2 replies)
  112. Solved: prevent typing in a Data Val drop-down (9 replies)
  113. Solved: How to stop it closing??!! (1 replies)
  114. Solved: Auto attach Worksheet to new outlook email (1 replies)
  115. Solved: Populating a Listbox from multiple name ranges (Excel '97) (10 replies)
  116. Copying Values and Pictures into new workbook: VBA (0 replies)
  117. Solved: Formatting with Calulated Values (3 replies)
  118. Solved: Chart ControlTipText (1 replies)
  119. Extracting Chart Data and Automated VBA Procedure for Slope (1 replies)
  120. Copy Worksheet code needs to copy VALUES (8 replies)
  121. Solved: Preventing Excel from opening in IE (8 replies)
  122. Changing function input from Cell dropdown to Combobox (4 replies)
  123. Solved: Runtime Error 1004 for Application.Username (12 replies)
  124. Updating Data on a Worksheet from a Userform (Excel '97) (0 replies)
  125. Check if CommandBarPopup exists (2 replies)
  126. Solved: Clearing a Userform (3 replies)
  127. Solved: Row Color Range When Cell Changes Color (4 replies)
  128. How to calculate loss or profit for multiple trades (3 replies)
  129. Solved: UDF, VBA or Formula for multi-conditional SUMIF? (2 replies)
  130. Solved: Column Heading Search (7 replies)
  131. Help with cell referencing (6 replies)
  132. Call vba function from flash embedded in excel (1 replies)
  133. Solved: If Cell is certain value THEN hide rows (7 replies)
  134. Solved: Sumproduct Syntax (9 replies)
  135. Show picture in Userform (8 replies)
  136. [SOLVED:] Moving data from columns to rows (6 replies)
  137. How to Join 2 Macro into 1 (7 replies)
  138. Change Read-Only Status (Excel '97) (2 replies)
  139. Solved: Formula not entered by macro (5 replies)
  140. Solved: Custom Function for UpTime Calculation (5 replies)
  141. Need help with Range (5 replies)
  142. check multiple conditions in a excel sheet through VBA (11 replies)
  143. Solved: Custome Function Returns Wrong Value (2 replies)
  144. Solved: AutoFilter (3 replies)
  145. Hyperlinks to many Sheets within a Workbook (9 replies)
  146. Getting file name from sharepoint (0 replies)
  147. Count number of .pst files from excel vba (1 replies)
  148. Print PDF (1 replies)
  149. Solved: Closing file takes A LONG TIME (5 replies)
  150. Solved: Dates in text String (4 replies)
  151. Solved: Hyperlink Cell to Include Cell Value in Link (11 replies)
  152. Solved: Comma delimited CSV (23 replies)
  153. Solved: Normal distribution (2 replies)
  154. Select first non-hidden row below starting cell (3 replies)
  155. SOLVED: Delete row with Autofilter takes ages after ADO code (5 replies)
  156. Problem with Application.Quit (2 replies)
  157. Delete Excel sheet without prompt (1 replies)
  158. Copy dat to another sheet Macro (1 replies)
  159. Point to pixel conversion (1 replies)
  160. Excel VBA Worksheet Consolidation Help (0 replies)
  161. VBA Tutor wanted in Philadelphia area (3 replies)
  162. How to format chart? (1 replies)
  163. PageBreak, AutoFilter, SpecialCells (4 replies)
  164. Solved: Use Worksheet Variable in vlookup code (7 replies)
  165. Textbox Macro Comes Up Empty (5 replies)
  166. Update value window (2 replies)
  167. Custom Function Help Features (2 replies)
  168. Solved: Leading Zero with a twist (3 replies)
  169. data control (5 replies)
  170. Referencing Data in a different location (4 replies)
  171. Bold text in userform tabs (1 replies)
  172. Solved: Delete Row From UF (2 replies)
  173. Solved: CODE TO CLEAR ROW CONTENTS BASED ON MATCH NAME (3 replies)
  174. Solved: HTTP File Download (1 replies)
  175. Lots of problems, excell beginner (0 replies)
  176. Split a string (3 replies)
  177. Join two tables with conditions (4 replies)
  178. Solved: If Statement Using Named Ranges (10 replies)
  179. Solved: how to find the value with 2 conditions (2 replies)
  180. Refreshing external data on individual sheets in a specific sequence. (2 replies)
  181. CDO attaches all file in Loop (0 replies)
  182. Read Only Visible Columns from a range (1 replies)
  183. Return values from a cell (3 replies)
  184. message box (2 replies)
  185. [SOLVED:] Help With Form (2 replies)
  186. Solved: Add Labels Together (11 replies)
  187. Need help getting an Excel Session to ignore .xls files from the web...(Not the usual (0 replies)
  188. Solved: using "--" (6 replies)
  189. Solved: Copy a Chart into another Sheet without Links (3 replies)
  190. Problem importing data from an xml file (0 replies)
  191. Report Macro (7 replies)
  192. Solved: Move excel files to a difference folder if sheet name is not "Payment Request" (4 replies)
  193. Problem toggling details (4 replies)
  194. Excel VBA to print the entire Workbook single sided (0 replies)
  195. Using an Excel Spreadsheet as a DataSource using DAO (3 replies)
  196. Sub string help (5 replies)
  197. Solved: Inserting data from Excel into Access (10 replies)
  198. Solved: Formula Problems (3 replies)
  199. Solved: Calculate cell (6 replies)
  200. Solved: SUMIF "criteria" (17 replies)
  201. Extracting highest value correlations and series names from Correlation Matrix (10 replies)
  202. Stop Excel from Updating Formula to external Workbook when copying the formula (5 replies)
  203. Solved: useform help filling list from DB VBA (1 replies)
  204. VBA Code Help (0 replies)
  205. Print specific pages of PDF in Excel using VBA (0 replies)
  206. I need help with a click proceedure attached to a dynamic label (5 replies)
  207. Solved: UserForm change width- Left Border? (13 replies)
  208. Process works in debug (2 replies)
  209. Refresh pivots on close AND on data being entered (2 replies)
  210. Solved: wb close and form close (5 replies)
  211. First & Last name comparisons (2 replies)
  212. Special macro for range goal seek (7 replies)
  213. Shifting data in cell from a work book to another based on some condition. (5 replies)
  214. Solved: Detect if workbook is Read Only (4 replies)
  215. Add subject, body, and attachments to emails thru excell/groupwise (4 replies)
  216. Solved: Limit length of input text box.. (2 replies)
  217. Solved: Centralized Log Manager (7 replies)
  218. Solved: Prevent Sql injection in User Form (1 replies)
  219. Solved: Macro to Add Link to Each Worksheet? (5 replies)
  220. Can Excel 2007 help with website accessibility? (1 replies)
  221. Passing a UDT member/element (4 replies)
  222. Varying the cell range around a sum formulae (5 replies)
  223. Solved: How to chk on duplicated cell values & show msg box (15 replies)
  224. Workbook OPEN Event Code - Update Links (6 replies)
  225. Userform input value to macro (3 replies)
  226. Combine 2 or more Cells into 1 Cell VBA (2 replies)
  227. File Lister (2 replies)
  228. Is it possible to create VBA or even VB just by entering data into a worksheet? (1 replies)
  229. VBA for Pivot Tables Help (Dates) (1 replies)
  230. Solved: Dynamic code based on cell values (3 replies)
  231. Copy and Paste Range in the body email (0 replies)
  232. Solved: Hyperlink - full address from displayed text (2 replies)
  233. Solved: import data from another workbook (3 replies)
  234. Remove zero chart labels (4 replies)
  235. Solved: Moving Rows with repeated value to different Tab (3 replies)
  236. Solved: Changing Arrangement of Text in a cell (3 replies)
  237. VLOOKUP or HLOOKUP (1 replies)
  238. Solved: find, copy and paste (10 replies)
  239. Solved: Data Validation , multiple selection same cell (16 replies)
  240. Unable to copy excel spreadsheet to another spreadsheet (1 replies)
  241. Public Variables don't work (10 replies)
  242. Help With Formula (2 replies)
  243. Solved: Hide Unhide Worksheets based on Name (23 replies)
  244. Wrapping UserForm Modules. (1 replies)
  245. Solved: Error 1004 in Transpose macro (2 replies)
  246. RibbonX code (1 replies)
  247. Capture Printer from Printer Dialog (1 replies)
  248. Working on Code efficiency... (2 replies)
  249. Forward stepwise regression using VBA (6 replies)
  250. Do Loop Help (6 replies)