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 174

  1. Jumble Word Game (0 replies)
  2. Solved: Offset Macro Needed...I think (3 replies)
  3. Snap view upon cell click (12 replies)
  4. Opening Excel from Powerpoint (8 replies)
  5. Solved: Need to add a sort command to macro (15 replies)
  6. Solved: copying rows matching criteria from a column (7 replies)
  7. Solved: How to automate Excel Tools-> Options (3 replies)
  8. Solved: Join Two Codes Together (5 replies)
  9. Solved: How to Chart two different data ranges (5 replies)
  10. Help to populate listbox via vba (11 replies)
  11. Solved: how to protect/unprotect column depending on cell value? (3 replies)
  12. Pausing a macro... (10 replies)
  13. Solved: Select case for conditional formatting to build heat chart? (14 replies)
  14. Solved: Alphabetically reverse text in cell (2 replies)
  15. Solved: Splitting all addresses in a formula (34 replies)
  16. Solved: Speeding up routine (10 replies)
  17. Solved: Changes in all Workbooks in One Time (6 replies)
  18. Calculate Retirement Age: I Failed! (1 replies)
  19. Print tables with variable height and same heading (1 replies)
  20. Change picture based on cell value (2 replies)
  21. Solved: deleting rows matching criteria from a column (4 replies)
  22. Formatting text cells to use in a formula (5 replies)
  23. Sum of column (2 replies)
  24. Procedure needed to group sections of data? (6 replies)
  25. Solved: Opening the Edit Links Dialog (1 replies)
  26. Correlation Matrix through relative refrances (1 replies)
  27. Solved: Take time difference (2 replies)
  28. "Application OnTime" Questions (2 replies)
  29. Center Userform/splash son monitor (3 replies)
  30. Using Excel to Tab through IE (4 replies)
  31. Solved: How to correct hide sheets when more than one workbook is closed? (6 replies)
  32. Solved: Coverting table data to flat data & delete empty rows (2 replies)
  33. Excel and Mainframe apps (3 replies)
  34. Correspondance search between sheets (19 replies)
  35. Solved: colorIndex change event (2 replies)
  36. Solved: Protect based on cell colour (6 replies)
  37. Solved: SOS !!! File/Send To (4 replies)
  38. Solved: links in formulas to other files problem (1 replies)
  39. "Save As" for Excel file with Internet Explorer (17 replies)
  40. Solved: Review Code (20 replies)
  41. Solved: Change background colour if cell is blank (3 replies)
  42. Delete invalid filename characters (9 replies)
  43. Solved: Cells format (7 replies)
  44. Error while sending mail (4 replies)
  45. Solved: help in indirect function (3 replies)
  46. vba with web application (8 replies)
  47. [SOLVED:] Save excel in temp (1 replies)
  48. [SOLVED:] How do i access Excel training? (1 replies)
  49. Solved: set print area problem (10 replies)
  50. Scan lists and shade row with lowest number (9 replies)
  51. Chage background colour (5 replies)
  52. [SOLVED:] A command that clears all data stored?? (6 replies)
  53. Can VBA do = camera to scan paper image:check marks ABCD = auto grading in classroom (11 replies)
  54. Solved: Compare Values from two sheets (3 replies)
  55. How to add paste special in contex menu and make Hotkey on it? (4 replies)
  56. Solved: Web page closes itself then opens a new IE... How can I track? (2 replies)
  57. Advice: Not filtering by given criteria (4 replies)
  58. Sleeper: Case Statement? (4 replies)
  59. [SOLVED:] How can I simplify my pivot tables (3 replies)
  60. [SOLVED:] Excel to Access Database (2 replies)
  61. [SOLVED:] Disabling a button for specific worksheets (6 replies)
  62. Sleeper: Calculating automatically with matrix (3 replies)
  63. [SOLVED:] Maximum size of String Variable (17 replies)
  64. [SOLVED:] Popup Window (7 replies)
  65. Solved: Making a Collection of some Form Controls (4 replies)
  66. [SOLVED:] Spreadsheet inside a Userform (6 replies)
  67. Chart multiple ranges from userform dropdown (1 replies)
  68. Solved: Multiple replace slowing macro (9 replies)
  69. Solved: Lookup Dates & Times (7 replies)
  70. Sleeper: Excel 2003 Convert to 2007 xlsm file (2 replies)
  71. [SOLVED:] dynamic chart layout (5 replies)
  72. Sleeper: Chart title as grid (6 replies)
  73. Solved: Macro is really slow (15 replies)
  74. Get value from workbook closed (1 replies)
  75. Solved: Using forms and form data (4 replies)
  76. macro to copy and past into mulitple worksheets (16 replies)
  77. Changing Date Format (2 replies)
  78. [SOLVED:] Showing Male and Female Ages on the same chart (3 replies)
  79. setting "trust access to visual basic project" programmatically? (5 replies)
  80. Conditional formatting (7 replies)
  81. Solved: userform error 424 (5 replies)
  82. How to make Hyperlink which will change with cell number? (4 replies)
  83. [SOLVED:] ShowDataForm and data validation (7 replies)
  84. Solved: Unwanted Connection to Macros in Another WB (9 replies)
  85. Setting Current Position equal to Last Position: Homework (5 replies)
  86. Live Data over network (3 replies)
  87. [SOLVED:] Pivot Table Error (1 replies)
  88. Solved: Parse Method (5 replies)
  89. customize menus (1 replies)
  90. Solved: Add button to bar (1 replies)
  91. Solved: Dependent Validation Lists (2 replies)
  92. get value of cell for pivot table (2 replies)
  93. Solved: Is this possible (7 replies)
  94. Solved: Selecting used range of each row in loop? (5 replies)
  95. Solved: How to get CompId in UserForm (3 replies)
  96. In macro how do i go to last worked cell (7 replies)
  97. Solved: Adding sourcedata to Pivottable (2 replies)
  98. How to add References to a VBA Project? (3 replies)
  99. Display Charts (4 replies)
  100. Auto generate Excel File Name? (1 replies)
  101. Prevent WB Open if Macros 'Disabled' (3 replies)
  102. Solved: Check Date From A List (7 replies)
  103. Excel VBA 2003 Out of Memory Error (12 replies)
  104. [SOLVED:] Totaling manual subtotals (8 replies)
  105. Solved: carrying over sheets (4 replies)
  106. How can I put Multiselected files (not one) into listbox? (3 replies)
  107. DisplayFormulaBar Problem (5 replies)
  108. Getting <Title> out of HTML source code (1 replies)
  109. Create automated form excel (2 replies)
  110. Solved: Macro to keep data in tables in order (2 replies)
  111. Need trim to include leading space (7 replies)
  112. Solved: Testing the sheetname (2 replies)
  113. Solved: consistant data in different table same workbook (2 replies)
  114. [SOLVED:] Extracting Row Number using VBA Function.. (3 replies)
  115. Solved: Create a database from info coming from tabs (5 replies)
  116. How do I require data entry in a cell before moving to the next cell (11 replies)
  117. Conditional Formating - Based on the Originator of Document? (6 replies)
  118. Solved: Run macro every day automatically? (11 replies)
  119. Using Comboboxes to Update a Worksheet?? (2 replies)
  120. Solved: activewindow.panes(i) (24 replies)
  121. Solved: Send both html signature and body of email together (32 replies)
  122. Need help comparing worksheets (10 replies)
  123. Sleeper: How to create table of missing items? (22 replies)
  124. Solved: Excel Sheet Protection (11 replies)
  125. Solved: .UMAS file extension (1 replies)
  126. SUMIF function (6 replies)
  127. identify dates in a cell using macro (3 replies)
  128. Edit Function & My Checkbox (3 replies)
  129. Extended use of VLOOKUP function (3 replies)
  130. CSV File (5 replies)
  131. Testing connection string and SQL statment (3 replies)
  132. Create a button and asign Macro from VBA (7 replies)
  133. Variable names to refer to column and row (2 replies)
  134. Solved: Run Access Macro without Reference (7 replies)
  135. Have Excel identify last entry in a range (4 replies)
  136. Problem with Colors?! (8 replies)
  137. Solved: Error recovery when there is no worksheet (4 replies)
  138. Any way to rename Sheet1 to the name of the Workbook when you save? (2 replies)
  139. Solved: Checkbox correspondence (7 replies)
  140. Sort ascending with expand selection (1 replies)
  141. How to stretch some range, if in contains some protected cells? (1 replies)
  142. [SOLVED:] Moving Excel files into folder based on filename (15 replies)
  143. Solved: Automate Answers to vbMsgBoxResults using a macro (19 replies)
  144. Solved: INCLUDE NAME/MNEMONIC IN MSGBOX (3 replies)
  145. Solved: select and copy cells through VBA (3 replies)
  146. Locking Excel 5.0 VBA (6 replies)
  147. Application.Calculation (6 replies)
  148. Solved: got upgraded and Files functions dont work (3 replies)
  149. Separate Parts of a Name String into Different Cells (9 replies)
  150. How to Use a Class Module from an Excel Addin in VBA (3 replies)
  151. Solved: Worksheet formula to convert text date YYYYMMDD (2 replies)
  152. Solved: Colour format cells in each row with highest values (6 replies)
  153. How to make userform/wizard remember value even after it is closed (2 replies)
  154. Format Function with Numbers (5 replies)
  155. Mailfunction - Send mail when document is updated. (1 replies)
  156. Max length of textbox with multiline property. (3 replies)
  157. [SOLVED:] Compare rows from two sheets and highlight non matched rows (2 replies)
  158. Datestamp + Calculation (0 replies)
  159. Sharing An Excel Workbook (3 replies)
  160. Referencing Worksheets from Macros (3 replies)
  161. Solved: Things That Happen When A Workbook Is Closed (5 replies)
  162. Get Sepcified Detail From Worksheets (24 replies)
  163. Does anyone use VSTO2008? (1 replies)
  164. Dynamic protection of data (3 replies)
  165. Sleeper: Inserting flash animation (20 replies)
  166. Extract various data from Worksheet into one column using certain criteria (3 replies)
  167. Solved: Open new application in maximized position (2 replies)
  168. Delete a Name Range that references a spreadsheet that does not exist (24 replies)
  169. Solved: Macro to create a &quot;Draft&quot; Watermark stamp for workbooks (24 replies)
  170. Solved: Dynamic Pivot Table (4 replies)
  171. Solved: Show MsgBox if autofilter results in zero (36 replies)
  172. Turn off custom functions (8 replies)
  173. How can I Run Macros In Other Excel File? (6 replies)
  174. Searching for cell value in another spreadsheet (3 replies)
  175. Extracting value from 1 of three columns where value exists (8 replies)
  176. Solved: finding Strikethrough font (6 replies)
  177. [SOLVED:] Keeps crashing on this code (2 replies)
  178. Solved: Zip / Rar thru VBA (2 replies)
  179. Solved: Paste to next empty row (8 replies)
  180. Solved: Better Code for Textbox (5 replies)
  181. Save as .txt (4 replies)
  182. VBA or In-Cell functions for Duplicate handling? (8 replies)
  183. Solved: Copy/Paste from HTML Spreadsheet to Excel (9 replies)
  184. Pivottable macro - ManualUpdate problem (1 replies)
  185. Value find help (9 replies)
  186. Editing Chart Data Labels in Excel 2007 using VBA (3 replies)
  187. Solved: Prevent &quot;This workbook contains links&quot; window from popping up (2 replies)
  188. Disable msg SaveAs (2 replies)
  189. Permutations in a class modules (8 replies)
  190. SOLVED: Disable Custom Buttons when no Worksheet is Loaded (9 replies)
  191. Solved: VBA Calendar problem (2 replies)
  192. Solved: Date from textbox to cell (2 replies)
  193. Pull Data from range (1 replies)
  194. Solved: Another sorting problem (3 replies)
  195. Ribbon control mouse click detection (4 replies)
  196. Solved: Calculating Week Ending date based on Sunday week end? (2 replies)
  197. [SOLVED:] Vlookup - Im completley confused (9 replies)
  198. Formula to distribute a number in forward years with the cond. it is equals an amount (1 replies)
  199. Looping timer (4 replies)
  200. Loop through hundreds of files in a folder using select CASE (3 replies)
  201. Combine Certain Data From All Worksheets in All Workbooks in a Specified Directory (6 replies)
  202. Solved: macro to add FileName and currentdate to an existing worksheet (9 replies)
  203. Solved: Moving all files from one folder to another (6 replies)
  204. clipboard (6 replies)
  205. Solved: strings add a zero (4 replies)
  206. Byte Comparison for Strings (3 replies)
  207. VBA Formulas (7 replies)
  208. Solved: INCLUDE SIGNATURE IN AUTOMATED MAIL SENDING (4 replies)
  209. Solved: Combobox popup window without scroll bars (3 replies)
  210. formname.PrintForm disables msgbox (3 replies)
  211. Protect Sheet (3 replies)
  212. How do i save as *.xla in VBA? (7 replies)
  213. Solved: Open pdf or image file from predefined folder (4 replies)
  214. Scaling Values in a Chart. (3 replies)
  215. Solved: comments object, placement property (2 replies)
  216. [SLEEPER:] Check which cmd buttons is clicked (5 replies)
  217. Solved: Remembering entries (5 replies)
  218. Short code to set caption on labels based on cell values (3 replies)
  219. Solved: Calling a Macro from an OPC linked cell (2 replies)
  220. Multiple log in & update a file that contain Macro (2 replies)
  221. Wrapped (R) (2 replies)
  222. Solved: Vlookup or not? (1 replies)
  223. Solved: Update Value from one column to another column under 1 row (4 replies)
  224. Solved: Automation Error 440 (7 replies)
  225. [SOLVED:] Alternate shading via conditional format with a twist (6 replies)
  226. Audit trail macro on excel? (6 replies)
  227. custom function error. (4 replies)
  228. Solved: Filter data and count unique (13 replies)
  229. How to use the Connections.Add method (1 replies)
  230. How to create a .xls file on a remote server (0 replies)
  231. How to copy files into a current user profile folder using Excel VBA macro? (1 replies)
  232. Solved: How to discover repeat text names in Range array? (3 replies)
  233. Combining Macros (3 replies)
  234. Solved: issue with using DATEValue in VBA, with VLookup (2 replies)
  235. CAll a macro on entering data to a cell under a column (3 replies)
  236. Solved: If Without Block If (2 replies)
  237. Contingent row copy (make duplicates) (18 replies)
  238. Solved: Zipping files in a folder using VBA (10 replies)
  239. Solved: How to create listing in Combo box of User Form (10 replies)
  240. SUM VISIBLE COLUMNS ONLY (16 replies)
  241. Solved: Disable Web site auto linkage to Excel (3 replies)
  242. Solved: Hiding &amp; Unhiding Columns base on a Data Validation or Cell value (1 replies)
  243. placing a floating combobox on top of a cell in OWC11 spreadsheet using VBA (0 replies)
  244. Solved: Using Start and End Date via a form? (1 replies)
  245. Solved: Using two commands in Excel 2007 (4 replies)
  246. Solved: Problems Distribute Excel Add-Ins in a high demand environment (3 replies)
  247. Copying multiple column data in multiple sheets to one column in Master sheet (13 replies)
  248. Solved: Copy sheet to new workbook without copying the code? (4 replies)
  249. [SOLVED:] 2007 compatibility (41 replies)
  250. Solved: Moving to London: Is anyone interested in hosting my duplicate master webpage? (21 replies)