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: truncate and add two text boxes into third (3 replies)
  2. Solved: Open a workbook & copy data using (3 replies)
  3. Find all instances of a word and return the results in a userfrom - not working (2 replies)
  4. How to identify non-whole number? (7 replies)
  5. [SOLVED:] Working with visible rows (2 replies)
  6. Possible 1-liner (2 replies)
  7. Solved: Onchange event to check a date (12 replies)
  8. Solved: Help w/ Summing Range (3 replies)
  9. Solved: Difference between UDF & sub routine (6 replies)
  10. Compare 4 worksheets in a workbook (0 replies)
  11. Solved: explain formula (3 replies)
  12. Solved: Two instances of the same form? (5 replies)
  13. Delete duplicated rows 2 (8 replies)
  14. Solved: More than 1 Validation in Single cell (11 replies)
  15. [SOLVED:] Change event in range selection (2 replies)
  16. Solved: Activate sheet after add/sort sheet executed (13 replies)
  17. Solved: How to copy data from one sheet to another (4 replies)
  18. Solved: Cannot Open The Excel File (6 replies)
  19. Solved: Tool to check VBA code (2 replies)
  20. Disabling worning message while closing a workbook. (3 replies)
  21. For-Next Loop Help (14 replies)
  22. Solved: Search for Missing Module/Code? (34 replies)
  23. Opening an Access Form via Excel (1 replies)
  24. ASCii code to allow a space (11 replies)
  25. Macro on Window Activation (8 replies)
  26. Solved: Is there a way to have code trigger an event when trying to save or print? (34 replies)
  27. Sorting producing wrong result (4 replies)
  28. Solved: Extract number of digits/characters of a variable (15 replies)
  29. Problems in calculation of Means, Max, Min in VBA (9 replies)
  30. Solved: Populate UserForm TextBox based on Worksheet Lookup (7 replies)
  31. Solved: Prohibit or restrict copy (7 replies)
  32. Solved: Nomenclature for referencing named cells in .Formula Code (7 replies)
  33. Solved: Migrating frm Excel 2003 to 2007 (4 replies)
  34. Solved: Delete duplicated rows (7 replies)
  35. How to Give Upper & Lower Limits to a Plot? (2 replies)
  36. Solved: Linking Again? (16 replies)
  37. Dynamic Plotting (1 replies)
  38. Solved: populate combobox problem (4 replies)
  39. Problem using arbitrary column length in a user defined function (9 replies)
  40. Sort data and past into new sheet (1 replies)
  41. Dummy post so I can creat4e an attachement (2 replies)
  42. [SOLVED:] Automatic close and save (7 replies)
  43. Adding sheets to summary (15 replies)
  44. Solved: Help with Lookup Function (6 replies)
  45. Solved: Populate Column based on contents of range (3 replies)
  46. VBA obfuscate data & find cell (1 replies)
  47. Solved: IsError Function (3 replies)
  48. Problem in the Range Row index (4 replies)
  49. Solved: delete columns with an array collection (4 replies)
  50. Print Setup via VBA (7 replies)
  51. Problem of open all file(s) in the listbox (2 replies)
  52. Counting Multiple Criteria (12 replies)
  53. Playing w/ Arrays (13 replies)
  54. I want to change the color of some letters, but it does't work (4 replies)
  55. Solved: Conditional formatting (6 replies)
  56. vlookup worksheet formula error: sub or function not defined? (8 replies)
  57. Making URLS Hyperlinks (4 replies)
  58. Diaplay text in a cell (8 replies)
  59. Loop Comparison Theory Discussion: For.Nxt vs. For Each (6 replies)
  60. Extract Text (8 replies)
  61. Solved: Hyperlink Address (4 replies)
  62. Transfer the data from the multiple files into 1 worksheets (7 replies)
  63. Solved: Remove Formula (5 replies)
  64. VBA to EXE (3 replies)
  65. inporting external data (4 replies)
  66. delete rows based upon external list (2 replies)
  67. Multi-Delete Function Problem in ListBox1 (11 replies)
  68. Solved: Amend cell in row based on value in first cell (4 replies)
  69. Solved: removing spaces (5 replies)
  70. Solved: Message box Format?? (6 replies)
  71. Version clash (7 replies)
  72. Solved: Excel 2007 ExportAsFixedFormat (8 replies)
  73. Creating charts automaticaly in Excel (7 replies)
  74. Solved: Prompt to save on close (askes if already saved?) (24 replies)
  75. Solved: Copying Workbooks without disrupting the original (1 replies)
  76. Row entry without keeping any row blank (2 replies)
  77. Solved: Data Validation Code To Force Prior Cell Entry (2 replies)
  78. Hide Rows based if column I = 0, then set print area from row 80 to everything visibl (2 replies)
  79. Create Summary Sheet (1 replies)
  80. Excel Lists (6 replies)
  81. 180 Day Calendar (24 replies)
  82. Solved: Sloved:Why GetOpenFilename not working (9 replies)
  83. Need help setting tab orders (28 replies)
  84. Show sheet based on serial number (4 replies)
  85. Searching a range (1 replies)
  86. Solved: clear cells if, like reset (15 replies)
  87. Union Query in VBA (12 replies)
  88. Macro - Pivot Tables (7 replies)
  89. Calculations between Textbox values on Form (2 replies)
  90. Solved: Looping required (2 replies)
  91. Seek help to highlight number. (55 replies)
  92. Newbie help: advanced table manipulation (10 replies)
  93. Auditing in Excel (4 replies)
  94. Solved: Paste Special,Text question (3 replies)
  95. Solved: "Tagging" a Cell (7 replies)
  96. CellColor Macro Not Working (13 replies)
  97. Publish Selection to Web (1 replies)
  98. Hide rows based on cell in row (3 replies)
  99. Prevent VBA generated charts from refreshing (3 replies)
  100. Solved: word wrap or new line (2 replies)
  101. Find Method To Find 2nd Occurence (9 replies)
  102. Solved: Question on sheet names and Copy (3 replies)
  103. Row and Column Numbers in VBA (8 replies)
  104. Solved: Help with array formula (9 replies)
  105. Last Date Used: (3 replies)
  106. print multiple sheets based on user choices (17 replies)
  107. Help:Just some clarification... (4 replies)
  108. Disabling the "Unsafe ActiveX controls" promt in excel (3 replies)
  109. VBA Help in books (3 replies)
  110. How to change sheet name at close excel workbook (17 replies)
  111. Using spinner in a protected sheet (2 replies)
  112. Solved: Hide column on selection change (14 replies)
  113. removing duplicates (4 replies)
  114. Column Sorting (2 replies)
  115. Solved: Import by tab name (28 replies)
  116. Solved: Selecting a Cell on a worksheet. (6 replies)
  117. defining a data source as a variable (5 replies)
  118. Solved: ComboBox & Dynamic Arrays (3 replies)
  119. Football Cup maker (1 replies)
  120. Substitute variable into a range (9 replies)
  121. How to get the data from the "Staff Record.xls" in VBA (12 replies)
  122. [SOLVED:] Copy to OPEN Workbook, not named... (19 replies)
  123. Solved: Casting to Text (9 replies)
  124. VBA Find and replace in XML/Text file (6 replies)
  125. Referencing Cells in changing worksheets (3 replies)
  126. Solved: A Simple(?) ComboBox Query (2 replies)
  127. Solved: Download file from web (5 replies)
  128. Solved: Excel Code Efficiency with DB Connection (20 replies)
  129. Searching Cells for String (8 replies)
  130. Solved: Conditional searching using VBA (1 replies)
  131. Solved: Variable type question (6 replies)
  132. Solved: compare worksheets (5 replies)
  133. Solved: Getting Page Count for a Workbook (2 replies)
  134. Userform Treeview (11 replies)
  135. Solved: Using a String to Run a Macro (3 replies)
  136. Solved: Upper, Proper, and Date Formats (14 replies)
  137. Solved: Deleting a part from a parts list with a macro (9 replies)
  138. Can't Populate Recordset due to SQL code (1 replies)
  139. Solved: Define constant path (5 replies)
  140. Solved: A "Browse" option for File Save? (4 replies)
  141. Solved: Show remaining time (4 replies)
  142. Time Elapsed (4 replies)
  143. Solved: Opening a window to the active.path location (5 replies)
  144. Calculation by VBA (15 replies)
  145. Solved: Printing multiple pages based on cell (8 replies)
  146. Vlookup help (13 replies)
  147. Find Local Time (17 replies)
  148. Solved: Pop up data in Excel (9 replies)
  149. Incrementing the previous value (2 replies)
  150. Solved: Save data to notepad file and leave link in worksheet (12 replies)
  151. Solved: Rename object and code (1 replies)
  152. COMBO BOX question (5 replies)
  153. Solved: Combo Box: set possible values 1 thru N in code (11 replies)
  154. Solved: File Search in Excel - hidden files? (25 replies)
  155. Make directory at Network Login name (16 replies)
  156. restore excel to default (5 replies)
  157. Solved: WEEK DAY REMINDER (3 replies)
  158. Solved: Conditional format (2 replies)
  159. Completely remove form from Excel file (1 replies)
  160. Solved: month end reminder (30 replies)
  161. SUMIF question (4 replies)
  162. Cannot copy a range.... (4 replies)
  163. Excel (10 replies)
  164. Log-in server time (5 replies)
  165. How to set Iteration Times in Solver with macro (2 replies)
  166. Wraptext (2 replies)
  167. Solved: help: How to get cells data for calculation in the best way (20 replies)
  168. Deleting identical rows between sheets? (11 replies)
  169. code for review - Excel "new window" substitute (1 replies)
  170. Suggestions please..... (17 replies)
  171. Solved: excel 2007 saving to 97-2003 compatible (26 replies)
  172. Help:User interaction when code running (11 replies)
  173. Dynamic toolbar fails under certain condition (1 replies)
  174. How to transfer the data from other Workbooks to my worksheets in this case (18 replies)
  175. Empty Cell Reference (3 replies)
  176. Code modification for updating (8 replies)
  177. Cutting a loop short... (3 replies)
  178. Inserting worksheets automatically in the same workbook..Guidance reqd (7 replies)
  179. Solved: Count Total Columns used in Sheet (3 replies)
  180. Help with Index Custom Function (4 replies)
  181. Solved: set reference to Windows Script Host Object Model ??? (4 replies)
  182. Array manipulation (16 replies)
  183. what is wrong with this code? (3 replies)
  184. Solved: Position Values on Stack Bar chart (5 replies)
  185. Issue about size in excel (2 replies)
  186. VBA LogParser and Yahoo RSS feeds (11 replies)
  187. Solved: Excel 2000 commandbar question (15 replies)
  188. Excel 2007 and Conditional formatting (5 replies)
  189. Solved: Scroll Bar Length (2 replies)
  190. Help:How to identify the sheet number of the first sheet? (3 replies)
  191. Solved: VLOOKUP as a sum (19 replies)
  192. [SOLVED:] IF Statement (10 replies)
  193. Loop problem (13 replies)
  194. help speed vba code (2 replies)
  195. Solved: Data Validation Error (19 replies)
  196. Solved: Need a replacement for sub underneath sub (20 replies)
  197. Adding Date to File name (11 replies)
  198. Calling a Worksheet_SelectionChange Subroutine (7 replies)
  199. Use worksheet functions in VBA w/out opening sheet (5 replies)
  200. Forcing user to accept macro? (2 replies)
  201. Name definitions lost after import (0 replies)
  202. Formatting a Cell (11 replies)
  203. Attach ActiveSheet to Email (5 replies)
  204. replace code in VBE with values on worksheet (3 replies)
  205. VBA simple step (11 replies)
  206. Solved: Image instead of Comment (3 replies)
  207. U.K Can any one recommend a VBA course? (12 replies)
  208. Solved: Import data from text file (7 replies)
  209. Solved: VBA Evaluate function not working in arrays - Need alternate (13 replies)
  210. Workbooks.Open ... AddToMru:=True (7 replies)
  211. Abstract first 6 characters from a column (8 replies)
  212. Editing Initialize Procedures for Dynamic User Forms (3 replies)
  213. Help: How to get function return result in the cell next to it (9 replies)
  214. Solved: Move to next cell (3 replies)
  215. Solved: Onkey (11 replies)
  216. Extract numbers only (7 replies)
  217. [SOLVED:] Adding Next Line Character in a Cell (15 replies)
  218. Master broken into week 1, week2, etc... (12 replies)
  219. Solved: Scroll Bar (10 replies)
  220. Looping formula... (13 replies)
  221. Function or not? (15 replies)
  222. Solved: Logging previous values in series of cells (3 replies)
  223. [SOLVED:] Avoid unwanted messages (8 replies)
  224. Computer Hangs (18 replies)
  225. More showed up and Repeated Data! (9 replies)
  226. Button in Excel to open a New Contact in Outlook (1 replies)
  227. Help - activate sheet (5 replies)
  228. [SOLVED:] Array problems (6 replies)
  229. Recover variable value after saving document (3 replies)
  230. Updated time on Cell (17 replies)
  231. VBA Evaluate function not working in arrays - Need alternate (1 replies)
  232. [SLEEPER:] Activate Esc key in Calendar userform (10 replies)
  233. Solved: Navigate Controls (4 replies)
  234. Solved: Change event (2 replies)
  235. Solved: Run Calculator (7 replies)
  236. how to distribut a form project? (10 replies)
  237. Adding worksheets (5 replies)
  238. could not load an object because it is not available on this machines (4 replies)
  239. Combining selected work sheets into one (1 replies)
  240. Using Excel to post HTML form (6 replies)
  241. tool bar nad connectors and ... (0 replies)
  242. Solved: Need Help with Protection Scheme (8 replies)
  243. setting Print Area (3 replies)
  244. On line date for setting expiry period (17 replies)
  245. Harddrive Id (21 replies)
  246. When to Use ?CutCopyMode = TRUE??? (2 replies)
  247. 2 excel questions (5 replies)
  248. Solved: What's the difference? (3 replies)
  249. Solved: Password formated cell (2 replies)
  250. Moving & copying between two workbooks (16 replies)