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. Excel VBA "OnKey" command problem (2 replies)
  2. Solved: Display Character Entries in InputBox with "*" (2 replies)
  3. Solved: Formula not working the way I need it to (6 replies)
  4. Trigger Excel Solver without VBA (4 replies)
  5. Speed Imporvements (3 replies)
  6. Solved: What's up with thes CheckBoxes and Option Boxes? (9 replies)
  7. Solved: Formula question (2 replies)
  8. Solved: Worksheet_change event with VLookUp (9 replies)
  9. Praying... and Praying.... (4 replies)
  10. Statistics on LogNormal/Monthly Arrays (2 replies)
  11. Merge tables on diferent workbooks (3 replies)
  12. replace an icon (0 replies)
  13. Solved: Excel to Access (0 replies)
  14. Why my UserForm cannot be initialized? (20 replies)
  15. Solved: Conditional Range without autofilter? (9 replies)
  16. AutoFilter - number of criteria (5 replies)
  17. AfterUpdate event in Class module (9 replies)
  18. Help in pictures on user form (2 replies)
  19. Find First Cell, Check if Pivot Table (12 replies)
  20. Sleeper: Add ColumnHead to a ListBox via VBA (7 replies)
  21. Urgent - manual combo input (10 replies)
  22. Solved: Range Array (3 replies)
  23. Solved: autofilter event ... ? (2 replies)
  24. Array.Count gives Invalid Qualifier Error (1 replies)
  25. set label value equal to file name (2 replies)
  26. how to delete rows? (13 replies)
  27. Solved: Referencing A Variable + An Integer To Show Cell Value? (20 replies)
  28. Solved: Check if sheet is blank (6 replies)
  29. Enumerate reference GUID's (7 replies)
  30. Waiting message (9 replies)
  31. Variable Indirection (9 replies)
  32. Another minor Bug :( passing String variable (6 replies)
  33. Hide and unhide rows by selecting a letter from a userform ComboBox (8 replies)
  34. Solved: Show Hide Multiple Columns at once (4 replies)
  35. Sorting Multiple columns programmatically (5 replies)
  36. Solved: filling in data, relative to the active cell (5 replies)
  37. Consolidate to Summary Page (7 replies)
  38. Solved: Sort without a title row (5 replies)
  39. Solved: Comparing 2 Sheets in a Workbook minor bug (2 replies)
  40. Solved: Saving Sheet (3 replies)
  41. VBA paste from clipboard to email (5 replies)
  42. See the values from a formula (2 replies)
  43. Concatenate in a cell the content of a column if a certain condition (11 replies)
  44. Run macros on different occasions (2 replies)
  45. Misc problems and questions. (16 replies)
  46. Solved: turn off features if not found (7 replies)
  47. Solved: Install if certain user (17 replies)
  48. [SOLVED:] How to write the codes? (29 replies)
  49. clock - display message every half hour (4 replies)
  50. Solved: output message in label (3 replies)
  51. Alter one macro from within another (6 replies)
  52. Naming a Worksheet Today's date (3 replies)
  53. Solved: Excel sync from network copy (5 replies)
  54. hide or disable a page (3 replies)
  55. Solved: Pasting from Word into Excel (4 replies)
  56. Conditional Formating (14 replies)
  57. Solved: rounded down format/display (4 replies)
  58. how to save worksheets in another excel file? (21 replies)
  59. Excel VBA Problem :( (10 replies)
  60. Find used cells, skip blanks (14 replies)
  61. Scanning for specific sheet names (14 replies)
  62. Solved: Building Dynamic List for Combobox Sort Alphabetically? (19 replies)
  63. Solved: Cell Error #### (6 replies)
  64. Solved: Date Format (4 replies)
  65. Solved: reducing file size (6 replies)
  66. Solved: Ignoring 0 in list (8 replies)
  67. File I/O Functions (4 replies)
  68. Solved: Advice On Macro For Transfering Data (13 replies)
  69. Help with: Hide empty rows, unhide others from johnske (4 replies)
  70. Solved: Run-time error '3464' Data type mismatch in criteria expression? (7 replies)
  71. V Lookup (23 replies)
  72. new to VBA scripting. need help. (4 replies)
  73. Select all text of a textbox (9 replies)
  74. Solved: use multipage as button (4 replies)
  75. Solved: Counting Visible Sheets in a workbook (22 replies)
  76. VB date formats - UK / US - HELP!!!!! (1 replies)
  77. Sleeper: Tracking payment adjustments (3 replies)
  78. Solved: run if this cell is blank (1 replies)
  79. Multiple V-look ups at once (6 replies)
  80. Form-level key handler (3 replies)
  81. Excel 2007 -- need help (0 replies)
  82. Solved: Collating and formatting financial data (2 replies)
  83. Solved: Get a Full address of a website using a macro (7 replies)
  84. Solved: Save one sheet as Read-Only (6 replies)
  85. HELP!! Attachments to email - excel VBA (3 replies)
  86. Solved: Setting a range from a Worksheet module (3 replies)
  87. Using OWC9 spreadsheet on User Form (4 replies)
  88. Solved: Date Formula With Conditional Formatting (4 replies)
  89. Solved: Combo Box help (14 replies)
  90. Solved: Selecting Range based on criteria? (1 replies)
  91. Selecting Range based on criteria? (8 replies)
  92. Copy rows from multiple worksheets (3 replies)
  93. Solved: Keep only the newest data?!? (1 replies)
  94. Solved: subtract (17 replies)
  95. Solved: Copy & paste a cell and row times defined number (22 replies)
  96. Linking? (7 replies)
  97. Solved: 1st Form option button to 2nd FORM (11 replies)
  98. Chart Problemz (2 replies)
  99. XY Scatter graphs (2 replies)
  100. Solved: Listbox selection (10 replies)
  101. Solved: Create folders on network drive (11 replies)
  102. Is this ready? (6 replies)
  103. Solved: search for #n/a (5 replies)
  104. XLM Page Setup (7 replies)
  105. Solved: Get values from a multi columns listbox (2 replies)
  106. Solved: how range is defined for a worksheet? (5 replies)
  107. [SOLVED:] Link VBA and HYSYS (1 replies)
  108. Solved: User defined data type - array of an array! (6 replies)
  109. Solved: Input check (6 replies)
  110. Embed ActiveX Control for portability (2 replies)
  111. Help in Tab in user form (22 replies)
  112. Solved: Import Text File (3 replies)
  113. Solved: Calculating wage using time format & currency format? (2 replies)
  114. Warning for missing information (16 replies)
  115. [SOLVED:] Dsiplay image based on list box selection (11 replies)
  116. Macro code isn't working (17 replies)
  117. Solved: Problem Moving Code from Module to UserForm (10 replies)
  118. PERSONAL.VBO (2 replies)
  119. Solved: Apply a Range Name to a second sheet (7 replies)
  120. a userform question (4 replies)
  121. Solved: Open workbook when excel starts (3 replies)
  122. Solved: Option button and text box (7 replies)
  123. vbe and excel date settings (0 replies)
  124. automatic save a file and close (21 replies)
  125. Down and Dirty xml->xsd (3 replies)
  126. Solved: Enable additional controls by vba code (4 replies)
  127. Solved: Macro to compute Lagged Correlations (6 replies)
  128. Display sheet name in a cell (10 replies)
  129. Solved: Generate a computer's hardware code (14 replies)
  130. Adding filter criteria (1 replies)
  131. Retrieving hidden columns (3 replies)
  132. Update Registry key via VBA/excel to chnage default E-mail to Lotus Notes (13 replies)
  133. Solved: Return a subtotal in a list (1 replies)
  134. API show last active URL (9 replies)
  135. Flexible range graph (2 replies)
  136. Solved: Match (2 replies)
  137. automatic calculation (4 replies)
  138. save userform and continue later (7 replies)
  139. Top 5 Help. (7 replies)
  140. [SOLVED:] Delete Rows (3 replies)
  141. double V-Lookup (20 replies)
  142. textbox controlSource problem (10 replies)
  143. Solved: deleting form listbox and datagrid (4 replies)
  144. Solved: Drop Down List (3 replies)
  145. Excel Help - Templates / Forms (3 replies)
  146. [SOLVED:] Stop WorksheetChange Event (3 replies)
  147. ensure that all controls have a value (25 replies)
  148. This Should be an easy copy/paste (7 replies)
  149. Unload frm1 - error (Wrong Number of Arguments) (3 replies)
  150. Solved: Max and Min dates in right header (9 replies)
  151. count if help (2 replies)
  152. Reassign variable (1 replies)
  153. Count rows based upon multiple criteria (11 replies)
  154. Solved: List worksheet names across columns (2 replies)
  155. Assigning comments to UDF (2 replies)
  156. Solved: Call Subroutine to Clear cells on Worksheet_Change (12 replies)
  157. Solved: populating a worksheet (10 replies)
  158. Solved: Add Bold to Number Formating (3 replies)
  159. copy and paste 2 destinations (11 replies)
  160. VISTA: multiple excel apps (19 replies)
  161. Execute SQL Stored Procedure (4 replies)
  162. Solved: Autofit alternating sizes (4 replies)
  163. Solved: Test if last column is longer than first column (2 replies)
  164. Solved: 52 wks or 53 wks in Year (7 replies)
  165. Solved: Display info from Module in msg box (4 replies)
  166. Solved: Insert File(s) In to the main xls file (8 replies)
  167. Auto close excel after 1hr (7 replies)
  168. Highlighting cells using VBA & Sumif() (8 replies)
  169. Determining name of nested multipage... (4 replies)
  170. Solved: populating listbox2 with listbox1 (15 replies)
  171. Manipulate data in range (4 replies)
  172. Copying data from another excel workbook created to another file automatically. (5 replies)
  173. Print Userform (23 replies)
  174. Solved: Excel out of memory with plenty of memory unused (4 replies)
  175. Solved: filtering, maybe? (2 replies)
  176. Solved: Named range quickie (2 replies)
  177. Solved: Open text File into a Excel workbook (5 replies)
  178. Solved: UserForm scroll bar (4 replies)
  179. 2 Excel Files, 1 Userform (3 replies)
  180. Hide Rows Using Data Validation (4 replies)
  181. Solved: Insert/Delete Row Between Entry (6 replies)
  182. Solved: use today in formula (2 replies)
  183. Simplify SQL string (5 replies)
  184. Moving 3 decimal places (8 replies)
  185. Solved: Replace in a sheet and not the entire workbook (5 replies)
  186. complicate unhide sheet (9 replies)
  187. Summing last two entries or smallest two entries in a list (1 replies)
  188. Solved: Showing all offset matches on different sheet using formula? (13 replies)
  189. Solved: Newbie...Stopping automatic conversion to scientific notation in VBA (4 replies)
  190. Solved: form.width=screen.width (15 replies)
  191. Solved: option box, combo box and excel (10 replies)
  192. Msg Box options (2 replies)
  193. Solved: Changing Month In Cell Everytime Sheet Is Copied? (2 replies)
  194. EnableMenuItem function help (12 replies)
  195. Help with consolidating Invoices (2 replies)
  196. Solved: Showing filtered range in TextBox on UserForm? (13 replies)
  197. Solved: The Lifetime of the "Application.Iteration" Setting (5 replies)
  198. help with old code now work has changed output formats (13 replies)
  199. Text to columns Destination (2 replies)
  200. inserting optButton value into worksheet (2 replies)
  201. Use animated gif in userforms (6 replies)
  202. re: Cannot Add Uniqe Items to a collection (10 replies)
  203. Hours Between dates & time (8 replies)
  204. correct formula syntax in macro (5 replies)
  205. Solved: Help with Textbox and label (5 replies)
  206. Import Text File to Different Worksheet (12 replies)
  207. Solved: Help understanding CONCATENATE formula (6 replies)
  208. Auto Run a macro from PERSONAL.XLS (11 replies)
  209. Solved: Range Union (3 replies)
  210. SQL Loop Error '3021' (8 replies)
  211. List uniques from multiple worksheets (7 replies)
  212. Excel Macro Help (8 replies)
  213. Solved: Range Reference Quickie (3 replies)
  214. Solved: Form Locations (1 replies)
  215. Open emails from excel. (12 replies)
  216. Solved: Summing time in a dynamic range? (17 replies)
  217. Solved: Formatting Time Values using VBA (5 replies)
  218. Solved: Overflow Error #6 (5 replies)
  219. FinalRow (5 replies)
  220. [SOLVED:] What Quarter is the Date? (8 replies)
  221. How to copy vice versa? .. (11 replies)
  222. Copy just certain data from a cell (5 replies)
  223. Solved: Advance Filter problem copying filtered range to different workbook? (17 replies)
  224. Report from Excel (1 replies)
  225. Solved: Excel Sorting Help (2 replies)
  226. repeate open event (8 replies)
  227. Solved: Splash screen While Macro Runs (9 replies)
  228. collecting particular type of fileds (4 replies)
  229. Chart Series info in tipbox? (3 replies)
  230. Solved: Specifying path using Environ(UserName) = Runtime Error 5? (3 replies)
  231. VBA Code Security and Sheet Protection (30 replies)
  232. Custom Document Property Defaults (14 replies)
  233. Check for memory leaks in Excel VBA (4 replies)
  234. Solved: Flashing cell (sheet_activate) (15 replies)
  235. Unexplained ?NAME? Error in Formula (2 replies)
  236. Solved: Pivot Tables from External Databases - Average formula incorrect (4 replies)
  237. [SOLVED:] Worksheet Protection (4 replies)
  238. Solved: Adding a row of unlocked cells (1 replies)
  239. macro to open a folder with explorer (2 replies)
  240. Version incompatibility? (3 replies)
  241. recursively add button and code (18 replies)
  242. Solved: Adding new sheets with the pre-define names (7 replies)
  243. Solved: titles in scatter graph (1 replies)
  244. Solved: Cut and Paste using Offset and Vlookup (22 replies)
  245. Solved: [solved] Help with Email active worksheet example (7 replies)
  246. Find Next Error (4 replies)
  247. Consolidating data from multiple workbooks grouped by first column (7 replies)
  248. Solved: Formula for sheet name (2 replies)
  249. Solved: Help With INDEX-MATCH-SMALL... (5 replies)
  250. Solved: Copy and Paste Problem (3 replies)