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: Worksheet focus on unloading modal form (2 replies)
  2. Solved: Vlookup table acting weird (4 replies)
  3. help with excel (1 replies)
  4. Solved: reverse lookup (4 replies)
  5. Help with ISBLANK (7 replies)
  6. Help in modifying a macro (7 replies)
  7. Solved: Auto filter for drop down list (6 replies)
  8. Solved: Embedding double quotes in a string (1 replies)
  9. Last Row with data (5 replies)
  10. Solved: Clear check box on open (3 replies)
  11. Spreadsheet Database Help (1 replies)
  12. Solved: Move to next cell (6 replies)
  13. Autosort Range (2 replies)
  14. Find cells in mutiple sheets and export in one sheet (5 replies)
  15. Solved: How to Put the Cursor on a Cell Without "Select"? (4 replies)
  16. Delete blank spaces (8 replies)
  17. Solved: VBA Project Password Prompt on Close?? (20 replies)
  18. Solved: AutoFit rows (5 replies)
  19. Solved: To find Algorithm (8 replies)
  20. Solved: Changing multiple workbooks (6 replies)
  21. Solved: SQRT function and VBA : "sub or function not defined" (8 replies)
  22. Solved: rounded value with the lower unit (0 replies)
  23. Search (8 replies)
  24. Hyperlink (2 replies)
  25. Solved: Active Object (2 replies)
  26. Print out all groups in a Active workbook (1 replies)
  27. Windows media player on excel spreadsheet (1 replies)
  28. Solved: Custom toolbar position (3 replies)
  29. Procedure Runs or Fails Depending on How Started (12 replies)
  30. Solved: Same Excel Constants Have Different Names?? (5 replies)
  31. Renaming the active chart (5 replies)
  32. Solved: How to Invoke a Formatting Macro (2 replies)
  33. Consecutive data in different sheet (14 replies)
  34. Solved: Populate Treeview (4 replies)
  35. Solved: convert numerical value to other text format (8 replies)
  36. Http - stumbling block (2 replies)
  37. Send Var With range to/from Form (2 replies)
  38. Solved: compare celle and copy in Q (1 replies)
  39. Activating hidden worksheets (14 replies)
  40. Solved: Userform to use IF formula and input result to ws (5 replies)
  41. Solved: combobox issue (3 replies)
  42. Solved: Another cross platform problem (4 replies)
  43. Send Keys kludge (18 replies)
  44. Printing to PDF using Adobe Distiller (2 replies)
  45. Solved: data to word bookmarks (2 replies)
  46. Solved: Worksheet_Change: Insert or Delete Columns (3 replies)
  47. Solved: Change font and/or size for validation list (3 replies)
  48. Solved: Problem with Program "Excel Diet" (2 replies)
  49. Solved: .FindNext situation.... (8 replies)
  50. Massive project involving Word & Excel (5 replies)
  51. [SOLVED:] Excel 2002-03 range2xml question (2 replies)
  52. Headlines (8 replies)
  53. Autonumber (4 replies)
  54. Solved: Cross platform form problem PC to Mac (2 replies)
  55. [SOLVED:] Validation in cell (2 replies)
  56. Solved: Adding Combobox inside of Cell (3 replies)
  57. Chart Question (3 replies)
  58. Solved: Make Workbook level event local (2 replies)
  59. Solved: Conditional formatting (5 replies)
  60. Application.InputBox Zero is False?? (7 replies)
  61. Solved: DAO access from excel (15 replies)
  62. Solved: What Happens to Event Programs for Deleted Sheets? (2 replies)
  63. Solved: alert box on open (11 replies)
  64. Progress Bar - Need some help (6 replies)
  65. Solved: missing reference (10 replies)
  66. An Excel Project! (5 replies)
  67. Drop Down Image combo List ? (2 replies)
  68. Solved: More ??? on Excel to Word (6 replies)
  69. Solved: File Name Protection (6 replies)
  70. Solved: Access navigation from within excel (1 replies)
  71. Microsoft pivot table control 9.0 (3 replies)
  72. Solved: Smart Error Handler (7 replies)
  73. Solved: Savechanges:=False (3 replies)
  74. Solved: copying data from several workbooks into one workbook (5 replies)
  75. Solved: Regarding On Error GoTo 0 (7 replies)
  76. Shapes are rediculous to work with (6 replies)
  77. MsgBox only when you first open the workbook? (4 replies)
  78. Solved: sorting (4 replies)
  79. Solved: sheet activate formula problem? (4 replies)
  80. Solved: Paste from one workbook to another using VBA (12 replies)
  81. Solved: What is Wrong with This Function? (4 replies)
  82. Excel/VB (15 replies)
  83. Help needed ! copy data from tabs of one work book to another ! (3 replies)
  84. [SOLVED:] Remove formulas (18 replies)
  85. Creating a game using Excel (1 replies)
  86. Solved: Seems simple but maybe not... (2 replies)
  87. Solved: Finding chars in strings and returning position (7 replies)
  88. Not a normal "WS Email" case? (11 replies)
  89. Solved: Is there a easier way (6 replies)
  90. Solved: additional criteria (1 replies)
  91. Solved: While "Thinking" (8 replies)
  92. Solved: How to "Deselect" an AutoShape (7 replies)
  93. Solved: Unlock all worksheets (6 replies)
  94. Solved: while loop (8 replies)
  95. Solved: Create access database from excel? (18 replies)
  96. Solved: Maths symbols (9 replies)
  97. Solved: SaveAs - Default Name (4 replies)
  98. Solved: Save before closing workbook. Close workbook, recalculates cells & prompt to save? (2 replies)
  99. copy line with 2 condition... (1 replies)
  100. Solved: checking worksheet name in macro (12 replies)
  101. [SOLVED:] Return contents of row ?4... (5 replies)
  102. Solved: Using Mid Question (6 replies)
  103. auto saving using macro (4 replies)
  104. Solved: Line Graphs Plotting Blanks & N/A (5 replies)
  105. Read Column B for dates and calculate averages (1 replies)
  106. Solved: concantonate cells using a loop (8 replies)
  107. Solved: Returning an Error Indicator in a Function (2 replies)
  108. Declaring Constants (5 replies)
  109. autofilter copy paste and lookup (11 replies)
  110. Solved: Force Enable Macros help (6 replies)
  111. Sample Data Maker (5 replies)
  112. Solved: Function similar to FACT() to SUM numbers, not multiply (9 replies)
  113. Solved: Sort range by active column (3 replies)
  114. Maximum number of characters in cell (5 replies)
  115. Solved: Send An Email (3 replies)
  116. Solved: Improve Find Function (7 replies)
  117. Solved: Automating Outlook 2003 calendar from Excel (7 replies)
  118. Highlighting alternate rows (4 replies)
  119. Solved: Find ALL Cell Fill Colors and Make them One Color (7 replies)
  120. Solved: Not recognizing variable or range? (2 replies)
  121. Solved: print contents of a list box? (4 replies)
  122. Changing the length of worksheets name (2 replies)
  123. Solved: Replace formula with vb event (5 replies)
  124. Solved: ******** Instead of Password (2 replies)
  125. Sleeper: VBA Error message (4 replies)
  126. Solved: creating a custom toolbar in VBA (3 replies)
  127. [SOLVED:] Find / Replace with Name Range References (2 replies)
  128. Solved: Auto-Name a Range (9 replies)
  129. Solved: Convertiing a Macro to Script (2 replies)
  130. Solved: What Are the General Rules for the End Property? (9 replies)
  131. Solved: userform controls (3 replies)
  132. Solved: Color Coding Specific Cell Value (8 replies)
  133. Solved: Selection to particular column and 1st avail row (7 replies)
  134. If Range is non-Existent Then... (3 replies)
  135. Solved: Find and Replace marco p Revisited (6 replies)
  136. Solved: Query a worksheet in excel (11 replies)
  137. USB Keys (0 replies)
  138. Calling Macro's (4 replies)
  139. Selective Deletion of ranges (3 replies)
  140. Solved: Problem Rewriting a Short Macro (5 replies)
  141. Solved: Do a Visible and Invisible Graph (6 replies)
  142. Solved: Texbox - Numbers ONLY - Date (12 replies)
  143. Find method problem (2 replies)
  144. Solved: display msgbox in R1C1 style of C12 (4 replies)
  145. [SOLVED:] Rename my range name (4 replies)
  146. Call Function not working... (13 replies)
  147. Form List box autopopulates doubles entry and wrong columns (3 replies)
  148. Populate Checkbox Based on Cell Content (7 replies)
  149. Setting active color of Fill Color and/or Font color tool (2 replies)
  150. Solved: First available row and clear row (7 replies)
  151. Lookup / Find / Search values and return same (6 replies)
  152. [SOLVED:] Open passworded sheet from other sheet in workbook (3 replies)
  153. Updating Range with Visual FoxPro Array (3 replies)
  154. Solved: Formatting cell contents (10 replies)
  155. Moving Horizontal PageBreak (2 replies)
  156. Solved: Question About For Loop Execution (2 replies)
  157. Solved: String Concatenation to a cell (3 replies)
  158. Solved: A short search and copy function (10 replies)
  159. Solved: Save range to a text file (13 replies)
  160. Solved: naming chart series from a cell value (4 replies)
  161. Corrupt document? (5 replies)
  162. Solved: 2 errors to rectify (11 replies)
  163. Grouping Data into Buckets (9 replies)
  164. [SOLVED:] Custom Button Maker (3 replies)
  165. Browse For File (4 replies)
  166. Run-time error '1004' using PasteSpecial (6 replies)
  167. On Error Resume Next ? (19 replies)
  168. [SOLVED:] Date Calculations (3 replies)
  169. Creating an addin and posting to other PCs (4 replies)
  170. [SOLVED:] can anyone help me resolve this error (2 replies)
  171. Best way to do an add/update button. (1 replies)
  172. Solved: Multi-Line into a cell (2 replies)
  173. Solved: Functions and formulas (1 replies)
  174. Solved: Chart-Moving Fails Sometime...Why?? (9 replies)
  175. [SOLVED:] Identify cells with color fill and borders (15 replies)
  176. Comparing multiple columns and copying cell (2 replies)
  177. Solved: "Out of memory" error while renaming module (3 replies)
  178. Solved: Save data to textfile with " in. (5 replies)
  179. [SOLVED:] Range with multiple conditions (5 replies)
  180. Sleeper: Using a loop to set and copy a range (5 replies)
  181. Delete row on value of active cell and ac offset (1 replies)
  182. Solved: Extract Data From PDF Files to Excel (22 replies)
  183. COM add-in as a DLL in VBA (8 replies)
  184. [SOLVED:] Comments transfer to cells (2 replies)
  185. Solved: Data Validation Question (6 replies)
  186. [SOLVED:] Advanced Filter (3 replies)
  187. Copy Values (4 replies)
  188. [SOLVED:] Intersect method question (4 replies)
  189. Sleeper: Tagging a Cell (3 replies)
  190. Solved: Inserting '-' in cell items (3 replies)
  191. Collect data and send mail (1 replies)
  192. [SOLVED:] Could this possibly be a problem in Excel 2000 (3 replies)
  193. [SOLVED:] Using Union Method (2 replies)
  194. Solved: Mystery to SOLVED: Forced-in negative value (3 replies)
  195. [SOLVED:] Converting amounts to fixed-length (5 replies)
  196. [SOLVED:] Using ADO to copy form a closed WB to a new WB (3 replies)
  197. [SOLVED:] Cut and paste (8 replies)
  198. Sleeper: Code to add comment when value of cell is changed (5 replies)
  199. Solved: Conditional Formatting (12 replies)
  200. Solved: Refresh date fields on data form in Excel (4 replies)
  201. Draw Line arrow to Scale VBE (10 replies)
  202. [SOLVED:] Selecting named columns (5 replies)
  203. Sleeper: How to assign macros from workbook module to Option Buttons Automatically (7 replies)
  204. [SOLVED:] How to Construct a Column Variable for Range (4 replies)
  205. [SOLVED:] Modify Code to Unprotect Workbook Prior to Deleting Worksheet (2 replies)
  206. [SOLVED:] An Ify statment in macro module (3 replies)
  207. Sleeper: Match values on multiple sheets (0 replies)
  208. [SOLVED:] Problem with save (5 replies)
  209. [SOLVED:] Matching two sets of numbers with duplicates (4 replies)
  210. Sleeper: Check CC validation (in excel). (7 replies)
  211. [SOLVED:] Further to previous solved, deleing rows in AN (2 replies)
  212. Sleeper: Importing a worksheet (3 replies)
  213. Sleeper: Draw Lines & Arrows UserForm VBE (1 replies)
  214. [SOLVED:] List Files from target directory thru all subdirs (11 replies)
  215. Sleeper: Search cells for no Hyperlink (3 replies)
  216. [SOLVED:] Cannot delete worksheet from userform...Why? (5 replies)
  217. [SOLVED:] Deleting rows where value in column AN = certain value (5 replies)
  218. [SOLVED:] Find cell address (2 replies)
  219. [SOLVED:] Spelling out numbers (7 replies)
  220. Sleeper: Pivot table showing text values (0 replies)
  221. [SOLVED:] Using only names found in combo box (4 replies)
  222. [SOLVED:] Clearing shapes (5 replies)
  223. [SOLVED:] Translate to Named Range (2 replies)
  224. [SOLVED:] Can you call a Sub from a Function? (4 replies)
  225. [SOLVED:] Set multiple Print Areas (2 replies)
  226. Sleeper: Copy stock symbols from one sheet to another (18 replies)
  227. [SOLVED:] AutoRunning User Defined Formula (3 replies)
  228. [SOLVED:] Disallow workbook to be opened (3 replies)
  229. [SOLVED:] Count item in array (4 replies)
  230. Sleeper: "statistical" function to randomize.. (1 replies)
  231. Sleeper: Circular reference in a macro (9 replies)
  232. [SOLVED:] Separate 2 last digits of a number with comma. (3 replies)
  233. Sleeper: Printing very hidden sheet? (2 replies)
  234. Sleeper: Subtotal (6 replies)
  235. Sleeper: Adding code from XLA to workbook (Excel 2000) (11 replies)
  236. Sleeper: AutoFilter and criteria inarray (1 replies)
  237. Sleeper: Find values and copy areas to another sheet (2 replies)
  238. [SOLVED:] I fell off the truck (3 replies)
  239. Sleeper: Is there a Calculator user Form such as the Calendar (2 replies)
  240. [SOLVED:] Input Box text to display Asterisks (*) (11 replies)
  241. [SOLVED:] Problem with ActiveSheet.Shapes (3 replies)
  242. [SOLVED:] Array of Controls (3 replies)
  243. [SOLVED:] Selecting cells off a button (9 replies)
  244. Sleeper: Update macro (3 replies)
  245. Sleeper: Follow up question on "Solved" thread (10 replies)
  246. It's Official (41 replies)
  247. Sleeper: Recalc cells if macro code has changed? (0 replies)
  248. [SOLVED:] Web Query To Jpeg w/external VBA/VBScript Code (6 replies)
  249. [SOLVED:] Number to date (5 replies)
  250. [SOLVED:] Cannot open file (Error 53) for writing (2 replies)