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. Solved: Copy & paste a cell and row times defined number (22 replies)
  2. Linking? (7 replies)
  3. Solved: 1st Form option button to 2nd FORM (11 replies)
  4. Chart Problemz (2 replies)
  5. XY Scatter graphs (2 replies)
  6. Solved: Listbox selection (10 replies)
  7. Solved: Create folders on network drive (11 replies)
  8. Is this ready? (6 replies)
  9. Solved: search for #n/a (5 replies)
  10. XLM Page Setup (7 replies)
  11. Solved: Get values from a multi columns listbox (2 replies)
  12. Solved: how range is defined for a worksheet? (5 replies)
  13. [SOLVED:] Link VBA and HYSYS (1 replies)
  14. Solved: User defined data type - array of an array! (6 replies)
  15. Solved: Input check (6 replies)
  16. Embed ActiveX Control for portability (2 replies)
  17. [SOLVED:] Help in Tab in user form (22 replies)
  18. Solved: Import Text File (3 replies)
  19. Solved: Calculating wage using time format & currency format? (2 replies)
  20. Warning for missing information (16 replies)
  21. [SOLVED:] Dsiplay image based on list box selection (11 replies)
  22. Macro code isn't working (17 replies)
  23. Solved: Problem Moving Code from Module to UserForm (10 replies)
  24. PERSONAL.VBO (2 replies)
  25. Solved: Apply a Range Name to a second sheet (7 replies)
  26. a userform question (4 replies)
  27. Solved: Open workbook when excel starts (3 replies)
  28. Solved: Option button and text box (7 replies)
  29. vbe and excel date settings (0 replies)
  30. [SLEEPER:] Automatic save a file and close (21 replies)
  31. Down and Dirty xml->xsd (3 replies)
  32. Solved: Enable additional controls by vba code (4 replies)
  33. Solved: Macro to compute Lagged Correlations (6 replies)
  34. Display sheet name in a cell (10 replies)
  35. Solved: Generate a computer's hardware code (14 replies)
  36. Adding filter criteria (1 replies)
  37. Retrieving hidden columns (3 replies)
  38. Update Registry key via VBA/excel to chnage default E-mail to Lotus Notes (13 replies)
  39. Solved: Return a subtotal in a list (1 replies)
  40. API show last active URL (9 replies)
  41. Flexible range graph (2 replies)
  42. Solved: Match (2 replies)
  43. automatic calculation (4 replies)
  44. save userform and continue later (7 replies)
  45. Top 5 Help. (7 replies)
  46. [SOLVED:] Delete Rows (3 replies)
  47. double V-Lookup (20 replies)
  48. textbox controlSource problem (10 replies)
  49. Solved: deleting form listbox and datagrid (4 replies)
  50. [SOLVED:] Drop Down List (3 replies)
  51. [SOLVED:] Excel Help - Templates / Forms (3 replies)
  52. [SOLVED:] Stop WorksheetChange Event (3 replies)
  53. ensure that all controls have a value (25 replies)
  54. This Should be an easy copy/paste (7 replies)
  55. Unload frm1 - error (Wrong Number of Arguments) (3 replies)
  56. Solved: Max and Min dates in right header (9 replies)
  57. count if help (2 replies)
  58. Reassign variable (1 replies)
  59. Count rows based upon multiple criteria (11 replies)
  60. [SOLVED:] List worksheet names across columns (2 replies)
  61. Assigning comments to UDF (2 replies)
  62. Solved: Call Subroutine to Clear cells on Worksheet_Change (12 replies)
  63. Solved: populating a worksheet (10 replies)
  64. Solved: Add Bold to Number Formating (3 replies)
  65. copy and paste 2 destinations (11 replies)
  66. VISTA: multiple excel apps (19 replies)
  67. Execute SQL Stored Procedure (4 replies)
  68. Solved: Autofit alternating sizes (4 replies)
  69. Solved: Test if last column is longer than first column (2 replies)
  70. [SOLVED:] 52 wks or 53 wks in Year (7 replies)
  71. Solved: Display info from Module in msg box (4 replies)
  72. Solved: Insert File(s) In to the main xls file (8 replies)
  73. Auto close excel after 1hr (7 replies)
  74. Highlighting cells using VBA & Sumif() (8 replies)
  75. Determining name of nested multipage... (4 replies)
  76. Solved: populating listbox2 with listbox1 (15 replies)
  77. Manipulate data in range (4 replies)
  78. Copying data from another excel workbook created to another file automatically. (5 replies)
  79. Print Userform (23 replies)
  80. Solved: Excel out of memory with plenty of memory unused (4 replies)
  81. Solved: filtering, maybe? (2 replies)
  82. Solved: Named range quickie (2 replies)
  83. Solved: Open text File into a Excel workbook (5 replies)
  84. Solved: UserForm scroll bar (4 replies)
  85. 2 Excel Files, 1 Userform (3 replies)
  86. Hide Rows Using Data Validation (4 replies)
  87. Solved: Insert/Delete Row Between Entry (6 replies)
  88. Solved: use today in formula (2 replies)
  89. Simplify SQL string (5 replies)
  90. Moving 3 decimal places (8 replies)
  91. [SOLVED:] Replace in a sheet and not the entire workbook (5 replies)
  92. complicate unhide sheet (9 replies)
  93. Summing last two entries or smallest two entries in a list (1 replies)
  94. Solved: Showing all offset matches on different sheet using formula? (13 replies)
  95. Solved: Newbie...Stopping automatic conversion to scientific notation in VBA (4 replies)
  96. Solved: form.width=screen.width (15 replies)
  97. [SOLVED:] Option box, combo box and excel (10 replies)
  98. Msg Box options (2 replies)
  99. Solved: Changing Month In Cell Everytime Sheet Is Copied? (2 replies)
  100. EnableMenuItem function help (12 replies)
  101. Help with consolidating Invoices (2 replies)
  102. Solved: Showing filtered range in TextBox on UserForm? (13 replies)
  103. Solved: The Lifetime of the "Application.Iteration" Setting (5 replies)
  104. help with old code now work has changed output formats (13 replies)
  105. Text to columns Destination (2 replies)
  106. inserting optButton value into worksheet (2 replies)
  107. Use animated gif in userforms (6 replies)
  108. re: Cannot Add Uniqe Items to a collection (10 replies)
  109. Hours Between dates & time (8 replies)
  110. correct formula syntax in macro (5 replies)
  111. Solved: Help with Textbox and label (5 replies)
  112. Import Text File to Different Worksheet (12 replies)
  113. Solved: Help understanding CONCATENATE formula (6 replies)
  114. Auto Run a macro from PERSONAL.XLS (11 replies)
  115. Solved: Range Union (3 replies)
  116. SQL Loop Error '3021' (8 replies)
  117. List uniques from multiple worksheets (7 replies)
  118. Excel Macro Help (8 replies)
  119. Solved: Range Reference Quickie (3 replies)
  120. Solved: Form Locations (1 replies)
  121. Open emails from excel. (12 replies)
  122. Solved: Summing time in a dynamic range? (17 replies)
  123. Solved: Formatting Time Values using VBA (5 replies)
  124. Solved: Overflow Error #6 (5 replies)
  125. FinalRow (5 replies)
  126. [SOLVED:] What Quarter is the Date? (8 replies)
  127. How to copy vice versa? .. (11 replies)
  128. Copy just certain data from a cell (5 replies)
  129. Solved: Advance Filter problem copying filtered range to different workbook? (17 replies)
  130. Report from Excel (1 replies)
  131. Solved: Excel Sorting Help (2 replies)
  132. repeate open event (8 replies)
  133. Solved: Splash screen While Macro Runs (9 replies)
  134. collecting particular type of fileds (4 replies)
  135. Chart Series info in tipbox? (3 replies)
  136. Solved: Specifying path using Environ(UserName) = Runtime Error 5? (3 replies)
  137. VBA Code Security and Sheet Protection (30 replies)
  138. Custom Document Property Defaults (14 replies)
  139. Check for memory leaks in Excel VBA (4 replies)
  140. Solved: Flashing cell (sheet_activate) (15 replies)
  141. Unexplained ?NAME? Error in Formula (2 replies)
  142. [SOLVED:] Solved: Pivot Tables from External Databases - Average formula incorrect (4 replies)
  143. [SOLVED:] Worksheet Protection (4 replies)
  144. [SOLVED:] Adding a row of unlocked cells (1 replies)
  145. macro to open a folder with explorer (2 replies)
  146. Version incompatibility? (3 replies)
  147. recursively add button and code (18 replies)
  148. Solved: Adding new sheets with the pre-define names (7 replies)
  149. Solved: titles in scatter graph (1 replies)
  150. Solved: Cut and Paste using Offset and Vlookup (22 replies)
  151. Solved: [solved] Help with Email active worksheet example (7 replies)
  152. Find Next Error (4 replies)
  153. Consolidating data from multiple workbooks grouped by first column (7 replies)
  154. Solved: Formula for sheet name (2 replies)
  155. Solved: Help With INDEX-MATCH-SMALL... (5 replies)
  156. [SOLVED:] Copy and Paste Problem (3 replies)
  157. Solved: how to make a solved thread, unsolved again? (4 replies)
  158. Use Variable in ComboBox name? (4 replies)
  159. Restrict Data in Cells (2 replies)
  160. Get inner Text string Value (4 replies)
  161. Format of date in text box differs from the corresponding cell. (2 replies)
  162. Solved: Problem with Formula to Determine the Max Row (10 replies)
  163. Data Input in Excel (9 replies)
  164. Locking cells in excel (12 replies)
  165. Control with time (7 replies)
  166. Solved: Copy Large Cells (2 replies)
  167. Solved: User Form / List Box Help Me! (3 replies)
  168. Copying a Module and Updating Links (6 replies)
  169. Solved: 2007 Personal.xlsb info (3 replies)
  170. Solved: Timer Delay (3 replies)
  171. Number of days in current month (15 replies)
  172. Open Workbook based on today's date (2 replies)
  173. save a worksheet (1 replies)
  174. Extend Code To Other Worksheets (12 replies)
  175. Solved: pasting with formulas - problem with macro (6 replies)
  176. Last Row (6 replies)
  177. Import data (3 replies)
  178. Solved: Delete Any Numbers that are less than 1 (12 replies)
  179. Passing a variable into a Private sub (24 replies)
  180. Loop involving list (3 replies)
  181. close all but activeworbook (23 replies)
  182. Copy data from Excel to Internet Explorer (28 replies)
  183. Date Format Error (4 replies)
  184. Solved: XCOPY Command Using VBA? (12 replies)
  185. Solved: view/page break preview (5 replies)
  186. Hiding rows in a protected worksheet.. (3 replies)
  187. Solved: Moving data and deleting duplicate rows (9 replies)
  188. PivotTable.Refresh woes (1 replies)
  189. Cells method advice (1 replies)
  190. Copy Outlook data to Excel (6 replies)
  191. Solved: Using wildcards in a formula (3 replies)
  192. Solved: Update Matched Items (6 replies)
  193. Converting from: Send Key Event to: different event (8 replies)
  194. Copy data from one sheet to another in the same workbook (14 replies)
  195. Sleeper: Autofit without unhiding (9 replies)
  196. Group Cut and Paste (0 replies)
  197. Solved: Precedure that works on one sheet and does not on another one (13 replies)
  198. complex if statement.. need help.. thankyou (4 replies)
  199. Solved: Date in all Caps (4 replies)
  200. conditional addition of row (4 replies)
  201. Solved: Populating a user form, editing the data, then saving it back to the spreadsheet (5 replies)
  202. Shift if "Invoice Date" (4 replies)
  203. Pivot Table Default Selection (0 replies)
  204. Summing largest amounts - Formula limitations? (5 replies)
  205. Compare one cell with a range .... (10 replies)
  206. Dependant comboboxes (2 replies)
  207. SS not accepting dates past 1/20/06 (4 replies)
  208. world war 2 (3 replies)
  209. Automate IE download from jsp web page (5 replies)
  210. Solved: I need to debug, Can you help pls? (13 replies)
  211. zoom in to the pasted area. (5 replies)
  212. Returning External Data from MySQL Server (2 replies)
  213. Solved: Naming Sheets (16 replies)
  214. one sheet print (2 replies)
  215. rename excel files using text in it (14 replies)
  216. coding OptionButton to show message (6 replies)
  217. Browser History to Excel (0 replies)
  218. Solved: Hide my "Personal" (4 replies)
  219. HELP With Code (6 replies)
  220. Images copying to another cell (9 replies)
  221. Solved: Store Application.Vlookup Value in Array? (2 replies)
  222. [SOLVED:] Array & cbos? (6 replies)
  223. Getting a feel for excel functions (4 replies)
  224. Solved: Working with Dates (1 replies)
  225. Outlook data checked against a spreadsheet (2 replies)
  226. Solved: delete rows which are not completely filled (8 replies)
  227. Data validation pull down not recognized (18 replies)
  228. Solved: Formula if Product is the same as above (7 replies)
  229. Making a textbox display a default value (4 replies)
  230. Solved: Page break at each change in customer (2 replies)
  231. Code Printing (6 replies)
  232. multi match (2 replies)
  233. Solved: When Application.UserName is blank ... (2 replies)
  234. simple loop backwards (5 replies)
  235. Need help with macro to insert rows and copy data (7 replies)
  236. Solved: assign macros to the controls of a toolbar (29 replies)
  237. Solved: Message Box Obsolete (4 replies)
  238. Adding Controls to Pages programatically (6 replies)
  239. Zygote Assistance: Search by Font, Copy to New Worksheet (6 replies)
  240. CTRL F on more than one WB (8 replies)
  241. Breaking a name into characters (25 replies)
  242. [SOLVED:] Which Runs Quicker??? (11 replies)
  243. Creating Common Connection object to use across many modules (1 replies)
  244. testing/quizzing (3 replies)
  245. convert to number alert msg (3 replies)
  246. Sleeper: Charting question (3 replies)
  247. Solved: Export/Import Range to Text File (11 replies)
  248. Solved: Make add-in compatible with Excel 2007 (8 replies)
  249. Compile error: Variable not defined (22 replies)
  250. Worksheet ReadOnly? (3 replies)