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. removing duplicates (4 replies)
  2. Column Sorting (2 replies)
  3. Solved: Import by tab name (28 replies)
  4. Solved: Selecting a Cell on a worksheet. (6 replies)
  5. defining a data source as a variable (5 replies)
  6. Solved: ComboBox & Dynamic Arrays (3 replies)
  7. Football Cup maker (1 replies)
  8. Substitute variable into a range (9 replies)
  9. How to get the data from the "Staff Record.xls" in VBA (12 replies)
  10. [SOLVED:] Copy to OPEN Workbook, not named... (19 replies)
  11. Solved: Casting to Text (9 replies)
  12. VBA Find and replace in XML/Text file (6 replies)
  13. Referencing Cells in changing worksheets (3 replies)
  14. Solved: A Simple(?) ComboBox Query (2 replies)
  15. Solved: Download file from web (5 replies)
  16. Solved: Excel Code Efficiency with DB Connection (20 replies)
  17. Searching Cells for String (8 replies)
  18. Solved: Conditional searching using VBA (1 replies)
  19. Solved: Variable type question (6 replies)
  20. Solved: compare worksheets (5 replies)
  21. Solved: Getting Page Count for a Workbook (2 replies)
  22. Userform Treeview (11 replies)
  23. Solved: Using a String to Run a Macro (3 replies)
  24. Solved: Upper, Proper, and Date Formats (14 replies)
  25. Solved: Deleting a part from a parts list with a macro (9 replies)
  26. Can't Populate Recordset due to SQL code (1 replies)
  27. Solved: Define constant path (5 replies)
  28. Solved: A "Browse" option for File Save? (4 replies)
  29. Solved: Show remaining time (4 replies)
  30. Time Elapsed (4 replies)
  31. Solved: Opening a window to the active.path location (5 replies)
  32. Calculation by VBA (15 replies)
  33. [SOLVED:] Printing multiple pages based on cell (8 replies)
  34. Vlookup help (13 replies)
  35. Find Local Time (17 replies)
  36. Solved: Pop up data in Excel (9 replies)
  37. Incrementing the previous value (2 replies)
  38. Solved: Save data to notepad file and leave link in worksheet (12 replies)
  39. Solved: Rename object and code (1 replies)
  40. COMBO BOX question (5 replies)
  41. Solved: Combo Box: set possible values 1 thru N in code (11 replies)
  42. Solved: File Search in Excel - hidden files? (25 replies)
  43. Make directory at Network Login name (16 replies)
  44. restore excel to default (5 replies)
  45. Solved: WEEK DAY REMINDER (3 replies)
  46. Solved: Conditional format (2 replies)
  47. Completely remove form from Excel file (1 replies)
  48. Solved: month end reminder (30 replies)
  49. SUMIF question (4 replies)
  50. Cannot copy a range.... (4 replies)
  51. Excel (10 replies)
  52. Log-in server time (5 replies)
  53. How to set Iteration Times in Solver with macro (2 replies)
  54. Wraptext (2 replies)
  55. Solved: help: How to get cells data for calculation in the best way (20 replies)
  56. Deleting identical rows between sheets? (11 replies)
  57. code for review - Excel "new window" substitute (1 replies)
  58. Suggestions please..... (17 replies)
  59. Solved: excel 2007 saving to 97-2003 compatible (26 replies)
  60. Help:User interaction when code running (11 replies)
  61. Dynamic toolbar fails under certain condition (1 replies)
  62. How to transfer the data from other Workbooks to my worksheets in this case (18 replies)
  63. Empty Cell Reference (3 replies)
  64. Code modification for updating (8 replies)
  65. Cutting a loop short... (3 replies)
  66. Inserting worksheets automatically in the same workbook..Guidance reqd (7 replies)
  67. Solved: Count Total Columns used in Sheet (3 replies)
  68. Help with Index Custom Function (4 replies)
  69. Solved: set reference to Windows Script Host Object Model ??? (4 replies)
  70. Array manipulation (16 replies)
  71. what is wrong with this code? (3 replies)
  72. Solved: Position Values on Stack Bar chart (5 replies)
  73. Issue about size in excel (2 replies)
  74. VBA LogParser and Yahoo RSS feeds (11 replies)
  75. Solved: Excel 2000 commandbar question (15 replies)
  76. Excel 2007 and Conditional formatting (5 replies)
  77. Solved: Scroll Bar Length (2 replies)
  78. Help:How to identify the sheet number of the first sheet? (3 replies)
  79. Solved: VLOOKUP as a sum (19 replies)
  80. [SOLVED:] IF Statement (10 replies)
  81. Loop problem (13 replies)
  82. help speed vba code (2 replies)
  83. Solved: Data Validation Error (19 replies)
  84. Solved: Need a replacement for sub underneath sub (20 replies)
  85. Adding Date to File name (11 replies)
  86. Calling a Worksheet_SelectionChange Subroutine (7 replies)
  87. Use worksheet functions in VBA w/out opening sheet (5 replies)
  88. Forcing user to accept macro? (2 replies)
  89. Name definitions lost after import (0 replies)
  90. Formatting a Cell (11 replies)
  91. Attach ActiveSheet to Email (5 replies)
  92. replace code in VBE with values on worksheet (3 replies)
  93. VBA simple step (11 replies)
  94. Solved: Image instead of Comment (3 replies)
  95. [SOLVED:] U.K Can any one recommend a VBA course? (12 replies)
  96. Solved: Import data from text file (7 replies)
  97. Solved: VBA Evaluate function not working in arrays - Need alternate (13 replies)
  98. Workbooks.Open ... AddToMru:=True (7 replies)
  99. Abstract first 6 characters from a column (8 replies)
  100. Editing Initialize Procedures for Dynamic User Forms (3 replies)
  101. Help: How to get function return result in the cell next to it (9 replies)
  102. Solved: Move to next cell (3 replies)
  103. Solved: Onkey (11 replies)
  104. Extract numbers only (7 replies)
  105. [SOLVED:] Adding Next Line Character in a Cell (15 replies)
  106. Master broken into week 1, week2, etc... (12 replies)
  107. Solved: Scroll Bar (10 replies)
  108. Looping formula... (13 replies)
  109. Function or not? (15 replies)
  110. Solved: Logging previous values in series of cells (3 replies)
  111. [SOLVED:] Avoid unwanted messages (8 replies)
  112. Computer Hangs (18 replies)
  113. More showed up and Repeated Data! (9 replies)
  114. Button in Excel to open a New Contact in Outlook (1 replies)
  115. Help - activate sheet (5 replies)
  116. [SOLVED:] Array problems (6 replies)
  117. Recover variable value after saving document (3 replies)
  118. [SOLVED:] Updated time on Cell (17 replies)
  119. VBA Evaluate function not working in arrays - Need alternate (1 replies)
  120. [SLEEPER:] Activate Esc key in Calendar userform (10 replies)
  121. Solved: Navigate Controls (4 replies)
  122. Solved: Change event (2 replies)
  123. Solved: Run Calculator (7 replies)
  124. how to distribut a form project? (10 replies)
  125. Adding worksheets (5 replies)
  126. could not load an object because it is not available on this machines (4 replies)
  127. Combining selected work sheets into one (1 replies)
  128. Using Excel to post HTML form (6 replies)
  129. tool bar nad connectors and ... (0 replies)
  130. Solved: Need Help with Protection Scheme (8 replies)
  131. setting Print Area (3 replies)
  132. On line date for setting expiry period (17 replies)
  133. Harddrive Id (21 replies)
  134. When to Use ?CutCopyMode = TRUE??? (2 replies)
  135. 2 excel questions (5 replies)
  136. Solved: What's the difference? (3 replies)
  137. Solved: Password formated cell (2 replies)
  138. Moving & copying between two workbooks (16 replies)
  139. How to start from active cell (2 replies)
  140. Referring to lots of Text Boxes on a userform (3 replies)
  141. Using Scripting.Dictionary with UDTs (17 replies)
  142. how to get today's date in text format? (3 replies)
  143. Solved: Multiple attachments - email (1 replies)
  144. Results did not write to Excel timely. (3 replies)
  145. Excel 2007 (22 replies)
  146. Newbie to VBA:how to define a very long string? (3 replies)
  147. Solved: Self message to save file before closing it (13 replies)
  148. Passing Array (2 replies)
  149. Setting text box values to currency (2 replies)
  150. User Input for Formula (6 replies)
  151. Solved: Relative Links (2 replies)
  152. First Step in VBA (2 replies)
  153. Solved: page breaks question (5 replies)
  154. Solved: Maxif UDF required (3 replies)
  155. Solved: Unique values from date range (12 replies)
  156. Solved: Search a spreadsheet (13 replies)
  157. Solved: Save As powerpoint that reference a cell in Excel (4 replies)
  158. Solved: Brainstorming - Querying data (6 replies)
  159. Controls on the fly (15 replies)
  160. Solved: Figuring out a DATE from a Number (2 replies)
  161. Solved: Add array items to multi column ListBox (7 replies)
  162. Online spreadsheet? (5 replies)
  163. calling subs from conditional statements (6 replies)
  164. Delete rows of other sheets also (3 replies)
  165. Solved: How to clean up data (12 replies)
  166. Solved: Can't get my XLA auto installer to work... (12 replies)
  167. Solved: IF/THEN Copy macro (13 replies)
  168. Stop userform from loading (2 replies)
  169. Tab key issues in form (inserts tab rather than moving to next control) (6 replies)
  170. Excel 2007/ Outlook 2007 Mail Problem (1 replies)
  171. Pivot Data Question (1 replies)
  172. Solved: File Import Browser Filter Failure (4 replies)
  173. Going over formula length limit (9 replies)
  174. Google Translation Issue (3 replies)
  175. Application Object Error- Range(Cells( (3 replies)
  176. Split date into part (5 replies)
  177. Compare 2 spreadsheets with conditions = Macro? (0 replies)
  178. Solved: Changing position of Chart XValues (4 replies)
  179. Range & Cells Property Prob (3 replies)
  180. Solved: Sorting Question (12 replies)
  181. NumberFormat of Now (5 replies)
  182. [SOLVED:] Help: how to insert pic, textbox to chart automatically??? (7 replies)
  183. how to put tabindex for rows of data Grid? (5 replies)
  184. Record data from a dynamically changing cell (11 replies)
  185. Bingo anyone? How to cross check a list of numbers & letters (3 replies)
  186. Solved: Efficient way to store/retrieve data of large UDT (4 replies)
  187. Automatically populate cell based on validation list (3 replies)
  188. Hexadecimal to ASCII UDF (3 replies)
  189. Solved: Import Macro help (37 replies)
  190. Solved: Sort of dynamic drop down list (3 replies)
  191. Solved: Auto Export cells to pop message and text file (8 replies)
  192. Show only Current Contracts (3 replies)
  193. [SLEEPER:] Len function problem (25 replies)
  194. Solved: Clear all within range (2 replies)
  195. Sorting order please help! (3 replies)
  196. Solved: Date Saving Problem (1 replies)
  197. Solved: Getting rid of the glimpse of opening/closing file (9 replies)
  198. Solved: use a cell reference to name a save-as (5 replies)
  199. Solved: Search 2nd ListBox Column (10 replies)
  200. Array of objects (7 replies)
  201. Solved: Identify .csv attachment in LotusNotes Inbox (0 replies)
  202. Solved: Single Event Handler for Multiple Checkboxes (5 replies)
  203. Genetic Algorithm (1 replies)
  204. Solved: Replace error types with string (2 replies)
  205. Enabling Mouse Wheel for a Scroll Bar (1 replies)
  206. Execute Access Module within Excel (1 replies)
  207. Add-in sheet (13 replies)
  208. Solved: Update Links (1 replies)
  209. Unprotect Excel Worksheets (5 replies)
  210. Copy all sheets to new Workbook (4 replies)
  211. [SOLVED:] Assigning password to all files (2 replies)
  212. A few small problems... (1 replies)
  213. Pivot Field Have I Just Clicked On? (0 replies)
  214. Macro To Start An External Tool Process? (1 replies)
  215. Show All in PivotTable (1 replies)
  216. SUBSTITUTE FUNCTION (7 replies)
  217. Loop Problem (16 replies)
  218. Word doc in email body (1 replies)
  219. Add consecutive numbers (3 replies)
  220. Solved: Columns Alighnment (1 replies)
  221. Solved: Show Width Of Selected Columns... (2 replies)
  222. Dynamic Chart (6 replies)
  223. Solved: Copy Range Names (3 replies)
  224. Select network printer for printing Word doc (15 replies)
  225. How to copy sheet with dynamics chart? (4 replies)
  226. using variables in "Find Function" (3 replies)
  227. Solved: Copying a range from one sheet to a new sheet in the background (6 replies)
  228. Solved: Control the execution of macros (5 replies)
  229. Solved: Save Sheet to a user defined location (4 replies)
  230. Solved: Finding repeated values/cells (3 replies)
  231. Range behaviour after delete (3 replies)
  232. Search Listbox Problem (5 replies)
  233. Solved: pROBLEMS....! (6 replies)
  234. Solved: Template??? Conference Matrix (6 replies)
  235. Solved: Hide zero rows (10 replies)
  236. Solved: Edit in ListBox & changes made to RowSource (11 replies)
  237. Solved: ListBox Headers without .RowSource (2 replies)
  238. Solved: Protect sheet except for new inserted sheet (9 replies)
  239. Solved: Returning a Value from and "If Then Else" (12 replies)
  240. Solved: Help alter code to pickup extra info. (7 replies)
  241. Solved: Unable to Hide Columns ... Why?? (5 replies)
  242. Changing code in runtime - why doesnt work (2 replies)
  243. Solved: Excel 2003 Subscript issue (2 replies)
  244. Solved: Import File Using Browser (18 replies)
  245. [SOLVED:] Pasting Cells Into Word Chart (5 replies)
  246. Solved: Add cutom header to Top of printed worksheet (2 replies)
  247. Very large number: Mod operator (1 replies)
  248. Solved: Passing variable from access to excel (4 replies)
  249. Solved: Copy data from all the sheets in a workbook into a single sheet (11 replies)
  250. Bar chart (1 replies)