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. Solved: Delete row if meet the criteria (3 replies)
  2. How do i add the custom toolbars programmatically (1 replies)
  3. Sorting - data in columns - arranged finally in one column (3 replies)
  4. Solved: Adding More Cell Ranges to BeforeDoubleClick and BeforeRightClick Macro (38 replies)
  5. Illegal Characters in Excel File Name (2 replies)
  6. Solved: Define Name from a function (6 replies)
  7. Range copying issues (1 replies)
  8. Challenging Macro (11 replies)
  9. generating emails from excel fields (6 replies)
  10. Solved: Adding Second Symbol (4 replies)
  11. How add new table ellement faster? (2 replies)
  12. Solved: Display if Found, if not edit??? (2 replies)
  13. Solved: Convert a number into a string with a leading zero (12 replies)
  14. Solved: Redirect save when given drive is not accessible (10 replies)
  15. Excel VBA Variant Variable Assigned a Number Tests as Number when assigned to ?? (15 replies)
  16. Solved: Amend vba code to apply same font and styling (6 replies)
  17. Saving Excell Data to File (More complicated then the title says) (3 replies)
  18. Solved: Open User Form in specified range (2 replies)
  19. Remove Duplicates in ComboBox (4 replies)
  20. Solved: Prevent numeric or symbol and if function in userform (5 replies)
  21. Add another call function to an exiting macro button (3 replies)
  22. Help to Modify An macros to compare (3 replies)
  23. Solved: Single click on cell should store value in another cell (3 replies)
  24. When to Use "Application.CutCopyMode" Statement (6 replies)
  25. MS Excel 2007: what is wrong with standard colors when constructing a chart? (6 replies)
  26. Delete row if cell does not contain a particular value (2 replies)
  27. User Defined Function - Write value to a range (3 replies)
  28. Solved: Formula help for odd money calculation? (5 replies)
  29. Spreadsheet maintainance automation required? (1 replies)
  30. Solved: Insert comment pictures fill down. (4 replies)
  31. Regular Express (19 replies)
  32. Solved: conditional formatting by color (8 replies)
  33. Saving data in incremental way in dat format-Help Needed. (0 replies)
  34. How Can I save data in incremental way-Help needed (2 replies)
  35. Solved: Choosing random samples (2 replies)
  36. Scripting.FileSystemObject (2 replies)
  37. Solved: column loop (9 replies)
  38. Solved: Textbox format (2 replies)
  39. Solved: unchecking checkboxes (12 replies)
  40. Solved: Copy only filtered rows (5 replies)
  41. Error Popup (3 replies)
  42. Internet Explorer dialog pop-up from Excel (1 replies)
  43. Solved: double case statement (16 replies)
  44. [SOLVED:] Getting Month and Year from a date cell (3 replies)
  45. Solved: Search through range and fill corresponding offset? (8 replies)
  46. Find Major Lows and Highs in Series (13 replies)
  47. Solved: Add sheet & name (12 replies)
  48. Email several sheets in one workbook password protected (8 replies)
  49. Solved: Deleting Unwanted Rows (7 replies)
  50. How to close the dialog with Excel VBA (5 replies)
  51. Solved: What to do when executing a code freezes Excel? (5 replies)
  52. Can you help me?I want code (2 replies)
  53. Saving (11 replies)
  54. Solved: deleting an asterik (4 replies)
  55. Solved: To copy part of the table data (7 replies)
  56. Solved: Merged Cells Null Value (8 replies)
  57. Help with ADSI spreadsheet (5 replies)
  58. Solved: Pie chart data labels percent formatting (6 replies)
  59. Compare two columns to two other columns (2 replies)
  60. Deselect range after Macro runs (6 replies)
  61. How to Parse a string with VBA (12 replies)
  62. Solved: xlCellTypeVisible question (2 replies)
  63. [SOLVED:] Autofilter OR function (10 replies)
  64. Solved: Time and Date log using VBA (21 replies)
  65. Solved: Locking Merged Cells (6 replies)
  66. [SOLVED:] Get Tenor - Bucket Function (2 replies)
  67. Solved: Loop to Get and put values (5 replies)
  68. Movies and scales (8 replies)
  69. Solved: UserForm turtorial (2 replies)
  70. Looping and shaking (1 replies)
  71. Solved: ActiveSheet Printing (5 replies)
  72. Solved: how to copy value with criteria to other worksheet? (4 replies)
  73. Multi Text Criteria (18 replies)
  74. Pivot table to NOT summarize data? (1 replies)
  75. Solved: Need someone to discreetly look at my code (8 replies)
  76. How can I disable the links and query alerts (3 replies)
  77. VBA search through workbooks to return answer help (7 replies)
  78. Data update does not work from VBS initiated open (4 replies)
  79. Solved: Add a count variable & increment it appropriately in this code (4 replies)
  80. Solved: Autofilter for multiple condition (5 replies)
  81. Solved: Check conditional format colour? (8 replies)
  82. Solved: Create folders and filename (11 replies)
  83. Solved: getting rid of a "If" + improving my code (5 replies)
  84. [SOLVED:] Can't Find Project or Library (9 replies)
  85. Array Formula (sum of ranges) (7 replies)
  86. Solved: Macros men? (10 replies)
  87. Deleting headers between two found variables? (3 replies)
  88. [SOLVED:] Disable Cut, Copy, Paste Macro for One Column (25 replies)
  89. Solved: Excel Macro Help - Hyperlinking (3 replies)
  90. Solved: Textbox formatting question (4 replies)
  91. Creating a lagged correlation matrix (5 replies)
  92. Want to have a static column referring to a dynamic range of data (5 replies)
  93. Solved: using a worksheet function in VBA (9 replies)
  94. Pull Access cells into Excel (4 replies)
  95. Solved: Calendar (4 replies)
  96. VLookup and column indicator (7 replies)
  97. Fill PDF form from Excel (0 replies)
  98. Solved: Changing Names to Numbers (9 replies)
  99. Solved: Amend vba code to add and extra step (7 replies)
  100. Sleeper: Copying single values instead of range (6 replies)
  101. Alternative to late Binding? (6 replies)
  102. Jumble Word Game (0 replies)
  103. Solved: Offset Macro Needed...I think (3 replies)
  104. Snap view upon cell click (12 replies)
  105. Opening Excel from Powerpoint (8 replies)
  106. Solved: Need to add a sort command to macro (15 replies)
  107. Solved: copying rows matching criteria from a column (7 replies)
  108. Solved: How to automate Excel Tools-> Options (3 replies)
  109. Solved: Join Two Codes Together (5 replies)
  110. Solved: How to Chart two different data ranges (5 replies)
  111. Help to populate listbox via vba (11 replies)
  112. Solved: how to protect/unprotect column depending on cell value? (3 replies)
  113. Pausing a macro... (10 replies)
  114. Solved: Select case for conditional formatting to build heat chart? (14 replies)
  115. Solved: Alphabetically reverse text in cell (2 replies)
  116. Solved: Splitting all addresses in a formula (34 replies)
  117. Solved: Speeding up routine (10 replies)
  118. Solved: Changes in all Workbooks in One Time (6 replies)
  119. Calculate Retirement Age: I Failed! (1 replies)
  120. Print tables with variable height and same heading (1 replies)
  121. Change picture based on cell value (2 replies)
  122. Solved: deleting rows matching criteria from a column (4 replies)
  123. Formatting text cells to use in a formula (5 replies)
  124. Sum of column (2 replies)
  125. Procedure needed to group sections of data? (6 replies)
  126. Solved: Opening the Edit Links Dialog (1 replies)
  127. Correlation Matrix through relative refrances (1 replies)
  128. Solved: Take time difference (2 replies)
  129. "Application OnTime" Questions (2 replies)
  130. Center Userform/splash son monitor (3 replies)
  131. Using Excel to Tab through IE (4 replies)
  132. Solved: How to correct hide sheets when more than one workbook is closed? (6 replies)
  133. Solved: Coverting table data to flat data & delete empty rows (2 replies)
  134. Excel and Mainframe apps (3 replies)
  135. Correspondance search between sheets (19 replies)
  136. Solved: colorIndex change event (2 replies)
  137. Solved: Protect based on cell colour (6 replies)
  138. Solved: SOS !!! File/Send To (4 replies)
  139. Solved: links in formulas to other files problem (1 replies)
  140. "Save As" for Excel file with Internet Explorer (17 replies)
  141. Solved: Review Code (20 replies)
  142. Solved: Change background colour if cell is blank (3 replies)
  143. Delete invalid filename characters (9 replies)
  144. Solved: Cells format (7 replies)
  145. Error while sending mail (4 replies)
  146. Solved: help in indirect function (3 replies)
  147. vba with web application (8 replies)
  148. [SOLVED:] Save excel in temp (1 replies)
  149. [SOLVED:] How do i access Excel training? (1 replies)
  150. Solved: set print area problem (10 replies)
  151. Scan lists and shade row with lowest number (9 replies)
  152. Chage background colour (5 replies)
  153. [SOLVED:] A command that clears all data stored?? (6 replies)
  154. Can VBA do = camera to scan paper image:check marks ABCD = auto grading in classroom (11 replies)
  155. Solved: Compare Values from two sheets (3 replies)
  156. How to add paste special in contex menu and make Hotkey on it? (4 replies)
  157. Solved: Web page closes itself then opens a new IE... How can I track? (2 replies)
  158. Advice: Not filtering by given criteria (4 replies)
  159. Sleeper: Case Statement? (4 replies)
  160. [SOLVED:] How can I simplify my pivot tables (3 replies)
  161. [SOLVED:] Excel to Access Database (2 replies)
  162. [SOLVED:] Disabling a button for specific worksheets (6 replies)
  163. Sleeper: Calculating automatically with matrix (3 replies)
  164. [SOLVED:] Maximum size of String Variable (17 replies)
  165. [SOLVED:] Popup Window (7 replies)
  166. Solved: Making a Collection of some Form Controls (4 replies)
  167. [SOLVED:] Spreadsheet inside a Userform (6 replies)
  168. Chart multiple ranges from userform dropdown (1 replies)
  169. Solved: Multiple replace slowing macro (9 replies)
  170. Solved: Lookup Dates & Times (7 replies)
  171. Sleeper: Excel 2003 Convert to 2007 xlsm file (2 replies)
  172. [SOLVED:] dynamic chart layout (5 replies)
  173. Sleeper: Chart title as grid (6 replies)
  174. Solved: Macro is really slow (15 replies)
  175. Get value from workbook closed (1 replies)
  176. Solved: Using forms and form data (4 replies)
  177. macro to copy and past into mulitple worksheets (16 replies)
  178. Changing Date Format (2 replies)
  179. Solved: Showing Male and Female Ages on the same chart (3 replies)
  180. setting "trust access to visual basic project" programmatically? (5 replies)
  181. Conditional formatting (7 replies)
  182. Solved: userform error 424 (5 replies)
  183. How to make Hyperlink which will change with cell number? (4 replies)
  184. [SOLVED:] ShowDataForm and data validation (7 replies)
  185. Solved: Unwanted Connection to Macros in Another WB (9 replies)
  186. Setting Current Position equal to Last Position: Homework (5 replies)
  187. Live Data over network (3 replies)
  188. [SOLVED:] Pivot Table Error (1 replies)
  189. Solved: Parse Method (5 replies)
  190. customize menus (1 replies)
  191. Solved: Add button to bar (1 replies)
  192. Solved: Dependent Validation Lists (2 replies)
  193. get value of cell for pivot table (2 replies)
  194. Solved: Is this possible (7 replies)
  195. Solved: Selecting used range of each row in loop? (5 replies)
  196. Solved: How to get CompId in UserForm (3 replies)
  197. In macro how do i go to last worked cell (7 replies)
  198. Solved: Adding sourcedata to Pivottable (2 replies)
  199. How to add References to a VBA Project? (3 replies)
  200. Display Charts (4 replies)
  201. Auto generate Excel File Name? (1 replies)
  202. Prevent WB Open if Macros 'Disabled' (3 replies)
  203. Solved: Check Date From A List (7 replies)
  204. Excel VBA 2003 Out of Memory Error (12 replies)
  205. [SOLVED:] Totaling manual subtotals (8 replies)
  206. Solved: carrying over sheets (4 replies)
  207. How can I put Multiselected files (not one) into listbox? (3 replies)
  208. DisplayFormulaBar Problem (5 replies)
  209. Getting <Title> out of HTML source code (1 replies)
  210. Create automated form excel (2 replies)
  211. Solved: Macro to keep data in tables in order (2 replies)
  212. Need trim to include leading space (7 replies)
  213. Solved: Testing the sheetname (2 replies)
  214. Solved: consistant data in different table same workbook (2 replies)
  215. [SOLVED:] Extracting Row Number using VBA Function.. (3 replies)
  216. Solved: Create a database from info coming from tabs (5 replies)
  217. How do I require data entry in a cell before moving to the next cell (11 replies)
  218. Conditional Formating - Based on the Originator of Document? (6 replies)
  219. Solved: Run macro every day automatically? (11 replies)
  220. Using Comboboxes to Update a Worksheet?? (2 replies)
  221. Solved: activewindow.panes(i) (24 replies)
  222. Solved: Send both html signature and body of email together (32 replies)
  223. Need help comparing worksheets (10 replies)
  224. Sleeper: How to create table of missing items? (22 replies)
  225. Solved: Excel Sheet Protection (11 replies)
  226. Solved: .UMAS file extension (1 replies)
  227. SUMIF function (6 replies)
  228. identify dates in a cell using macro (3 replies)
  229. Edit Function & My Checkbox (3 replies)
  230. Extended use of VLOOKUP function (3 replies)
  231. CSV File (5 replies)
  232. Testing connection string and SQL statment (3 replies)
  233. Create a button and asign Macro from VBA (7 replies)
  234. Variable names to refer to column and row (2 replies)
  235. Solved: Run Access Macro without Reference (7 replies)
  236. Have Excel identify last entry in a range (4 replies)
  237. Problem with Colors?! (8 replies)
  238. Solved: Error recovery when there is no worksheet (4 replies)
  239. Any way to rename Sheet1 to the name of the Workbook when you save? (2 replies)
  240. Solved: Checkbox correspondence (7 replies)
  241. Sort ascending with expand selection (1 replies)
  242. How to stretch some range, if in contains some protected cells? (1 replies)
  243. [SOLVED:] Moving Excel files into folder based on filename (15 replies)
  244. Solved: Automate Answers to vbMsgBoxResults using a macro (19 replies)
  245. Solved: INCLUDE NAME/MNEMONIC IN MSGBOX (3 replies)
  246. Solved: select and copy cells through VBA (3 replies)
  247. Locking Excel 5.0 VBA (6 replies)
  248. Application.Calculation (6 replies)
  249. Solved: got upgraded and Files functions dont work (3 replies)
  250. Separate Parts of a Name String into Different Cells (9 replies)