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: ComboBox error: Invalid property value (4 replies)
  2. Finding with userform (4 replies)
  3. Solved: openfile dialog retain openned name in variable (7 replies)
  4. Solved: Bulk entry of FormulaR1C1 problem (13 replies)
  5. Assign Macro to ComboBox?? (9 replies)
  6. Help Required with inputing data to excel worksheet (2 replies)
  7. Delete row on condition (18 replies)
  8. Multiple And Condition is Returning Wrong Answer (14 replies)
  9. Instructions for Explicit Error Type (7 replies)
  10. Using Autofilter Custom feature... (5 replies)
  11. Solved: Tips on a smarter way to perform Insert Line & Paste info? (10 replies)
  12. Open workbooks and compare cells (1 replies)
  13. Stumped Excel/Word-post do..loop results from excel to word (3 replies)
  14. Solved: Excel Freezing When Macro Runs (6 replies)
  15. [SOLVED:] Matching rows/values with rows/values of another spreadsheet (11 replies)
  16. Solved: Copying to the next blank cell (3 replies)
  17. conversion of variant (4 replies)
  18. User define the number of boxes in a form (4 replies)
  19. How can I read and write JPG Exif info (0 replies)
  20. excel queryTable (3 replies)
  21. global variables (7 replies)
  22. Setup and Write to a temporary storage location. (15 replies)
  23. Solved: condition (2 replies)
  24. Solved: copying data error (10 replies)
  25. Solved: delete a row (2 replies)
  26. RTF For a Text Box on a Form (0 replies)
  27. Compare Two Strings via Len Function (13 replies)
  28. before the last (16 replies)
  29. automaticaly show Scrollbars (0 replies)
  30. Solved: Trigger event on change/deactive/leave of a specific cell (4 replies)
  31. make the Application active (11 replies)
  32. scanning a column (2 replies)
  33. Saving 100 workbooks automatically (2 replies)
  34. Combine muliple rows into one row based on criteria (1 replies)
  35. Solved: Why doesn't this work? Apply macro to every sheet in book (3 replies)
  36. Email multiple worksheets - help please? (0 replies)
  37. Solved: How to pass a CheckBox to a subroutine (12 replies)
  38. Solved: limit users not to add/enter farmula (5 replies)
  39. Deleting rows when date within cell expires (3 replies)
  40. How to match data, then Copy (6 replies)
  41. Solved: Automating Hyperlinks (1 replies)
  42. Loop through, comparing string question (2 replies)
  43. Solved: How do I 'close' an open workbook? (4 replies)
  44. Getting and Extra Worksheet (2 replies)
  45. event procedures (12 replies)
  46. Solved: Data from userform to sheet (dynamic) (26 replies)
  47. Set Up a Pause Between Calls (15 replies)
  48. Auto list names (6 replies)
  49. interact with htlm (0 replies)
  50. Solved: count the cell hits (7 replies)
  51. Solved: Dealing with very large text files (2 replies)
  52. Hiding/Unhiding Columns based on Criteria (4 replies)
  53. Solved: Transferring Data from a Table (8 replies)
  54. Email message body (1 replies)
  55. Solved: How do I create a "dialog box"...? (4 replies)
  56. Solved: Excel to access cell for cell import (72 replies)
  57. action across all open workbooks (4 replies)
  58. textbox calculation (3 replies)
  59. Using ListView on Excel VBA UserForm (10 replies)
  60. Merging Date and Time from two different cells into one... (3 replies)
  61. Excel 2002 - data validation and copy/paste (0 replies)
  62. Parsing CSV files where data is split over lines (11 replies)
  63. Problem referencing other workbooks (2 replies)
  64. Checking if cell contains a string or a number (3 replies)
  65. Alter code to only clear data from target sheet (10 replies)
  66. look accross as I copy down (4 replies)
  67. Lookup tables (2 replies)
  68. Combobox change (16 replies)
  69. Solved: trapping error messages to hide in vba (2 replies)
  70. Formatting headers & footers in excel (6 replies)
  71. Paste in correct column based on criteria (12 replies)
  72. [SOLVED:] VBA To Run Another Macro at An Interval (2 replies)
  73. Solved: Export XML from Access using Excel VBA (4 replies)
  74. Solved: need to copy data from one workbook to another on selected cells (47 replies)
  75. Solved: How to get the number of days between two dates (3 replies)
  76. Running a macro on another spreadsheet with a macro (14 replies)
  77. Opening a directory and listing all files within (3 replies)
  78. Solved: Select Case not case sensitive (10 replies)
  79. [SLEEPER:] Advanced Calculus VBA Programming (3 replies)
  80. Solved: Combobox in Worksheet (1 replies)
  81. Solved: How do I create a PivotTable from data in a worksheet?... (3 replies)
  82. find substring and display message box (7 replies)
  83. Setting Print Area taking forever (2 replies)
  84. Solved: Project Explorer window...how to display my module names. (3 replies)
  85. Solved: Convert JPEG file to XLS FILE (2 replies)
  86. Line graph - ignore zero (3 replies)
  87. Large size user form (11 replies)
  88. Solved: Syntax error in formula...where am I going wrong? (3 replies)
  89. Print code (4 replies)
  90. Creating a help file. (3 replies)
  91. help in creating function (0 replies)
  92. Solved: Code Deletes headers on .ClearContents (3 replies)
  93. Mulitple importing of text files (3 replies)
  94. Solved: Problem With Choose & Match (6 replies)
  95. [SOLVED:] Gannt Chart (5 replies)
  96. Solved: Updating sheet (2 replies)
  97. Populating Combo boxes (6 replies)
  98. VBA regex multiline match not working (7 replies)
  99. invisible window (2 replies)
  100. offical excel vba tutorials? (9 replies)
  101. Copy cell format, formulas, and insert new row (2 replies)
  102. Update records from user form (4 replies)
  103. multicolumn combobox range (13 replies)
  104. Question re Form option/UserForm (12 replies)
  105. Solved: Count Data Then Send To Correct List (35 replies)
  106. Fetching excel data based on a given contd. (2 replies)
  107. Excel UK Conference 2007 (6 replies)
  108. Code goes into a infinite loop (4 replies)
  109. Solved: Print Multiple Pivot Charts on Single Sheet (2 replies)
  110. how to find the first date? (1 replies)
  111. Solved: Numpty question, but I'm not too proud to ask for help... (10 replies)
  112. Solved: Toolbar has no label (5 replies)
  113. Solved: Macro to match name & date and move info (5 replies)
  114. Solved: VBA Character colour change (3 replies)
  115. Solved: Run Macro When Worksheet Is Selected (2 replies)
  116. [SOLVED:] Syntax for 'LookUp' command? Help... (5 replies)
  117. auto add column (2 replies)
  118. Solved: automatic convert to upper case (2 replies)
  119. Sleeper: Text Edit Mode (1 replies)
  120. Solved: Viewing a text file from within Excel (3 replies)
  121. Creating employee schedules using preferences (6 replies)
  122. Solved: How to run a marquee text in Excel (3 replies)
  123. Time calculation on specific days (1 replies)
  124. Solved: GetSaveAs not actually saving? (3 replies)
  125. need to find the cell which intersets the fixed row and a variable column (10 replies)
  126. speeding up the code (5 replies)
  127. finding the Index value (10 replies)
  128. Private ComboBox Event Subs NOT staying private? (1 replies)
  129. Solved: Set range variable to cell above hidden rows (12 replies)
  130. Restore "lost" custom menus? (2 replies)
  131. Unlist Table (1 replies)
  132. Solved: Help in tabbing (2 replies)
  133. Solved: transfer jpg file to Excel (4 replies)
  134. Solved: delete everything other than (15 replies)
  135. Solved: Run-time error 1004 (macro export/import?) (4 replies)
  136. Run Time Error 91 (14 replies)
  137. Solved: Can I 'pull in' a worksheet (4 replies)
  138. Do not know how to use "Findnext" command (0 replies)
  139. Copy cells from Excel and Paste Special in Word (Clipboard problems) (3 replies)
  140. How do I best integrate and Excel workbook with a website for data capture? (0 replies)
  141. Returning value needs to be changed. (5 replies)
  142. Read a Text file with delimiter as comma and import the infor into excel sheet (3 replies)
  143. Sleeper: Auto sorting validation list (3 replies)
  144. unable to fetch the data from excel sheet based on a given condition. (7 replies)
  145. Solved: How to password protect the VBA Code (6 replies)
  146. UDTs and Collections (1 replies)
  147. Checking to see if other sheets are open (7 replies)
  148. Solved: Automatically start the macro in 15mins (19 replies)
  149. Click The hyperlink provided in a cell of a table (9 replies)
  150. Solved: How do I? (28 replies)
  151. Solved: Can I 'pull in' a worksheet from one excel file into another one? (8 replies)
  152. Solved: Timer (12 replies)
  153. Solved: Can you 'export' a macro? (2 replies)
  154. VBA Excel Solver (3 replies)
  155. Printing different files from a Folder in Excel (4 replies)
  156. Indexing Class Module Properties (4 replies)
  157. [SOLVED:] Input specific data into word (2 replies)
  158. Solved: Offset help (2 replies)
  159. holiday form for employees (5 replies)
  160. For Next loop error (3 replies)
  161. active box on a userform (14 replies)
  162. Solved: Just a bit stuck (3 replies)
  163. Quick Vlookup Theory Question (2 replies)
  164. Solved: Month building code issue (31 replies)
  165. [SOLVED:] How To Convert A Date/Time Serial Number (2 replies)
  166. [SOLVED:] Vlookup returning reference values - but only one?? (24 replies)
  167. Help: How to lock sheet but still let macro edit cell (14 replies)
  168. Solved: Specifying column width in sheet (7 replies)
  169. Inputbox & Time (17 replies)
  170. Solved: Setting criteria field on autofilter (6 replies)
  171. Multiple CSV Import (1 replies)
  172. Always On Top (3 replies)
  173. Problem with TxtBoxs and MsgBoxes (3 replies)
  174. Solved: auto email 2 sheets on workbook close, timing problem (4 replies)
  175. [SOLVED:] Text to column macro (6 replies)
  176. 2-D Vlookup? (4 replies)
  177. [SOLVED:] Generating Payslip 2 (5 replies)
  178. Excel and Outlook Global Address List (3 replies)
  179. Solved: Look-up table: Please help me (10 replies)
  180. Solved: Minimizing Excel (6 replies)
  181. [SOLVED:] Setting a filename as a variable (4 replies)
  182. Solved: Problems with my Combo Boxes (4 replies)
  183. Solved: If duplicate count is (3 replies)
  184. Pivot table in VB (0 replies)
  185. [SLEEPER:] Renaming excel files which have embedded macros (1 replies)
  186. [SOLVED:] seek help for VLOOKUP (7 replies)
  187. Not able to assign a whole range as a series to a chart (2 replies)
  188. [SOLVED:] Run Time Error 1004 Select method of range class failed (10 replies)
  189. emulate the satuesbar (1 replies)
  190. Solved: keeping format when copying (8 replies)
  191. Looking up Access database (2 replies)
  192. Solved: Workbook open problem (15 replies)
  193. [SOLVED:] How to align selected embedded chart? (2 replies)
  194. ForcePasteSpecial: getting an error... (4 replies)
  195. Find lowest bit in an integer (7 replies)
  196. Solved: Transpose in diffrent rows (5 replies)
  197. Name a range with For (2 replies)
  198. Create a control dynamically with an event and progressbar (12 replies)
  199. Activate a worksheet (12 replies)
  200. Using Sheet1 and Sheet2 (4 replies)
  201. Solved: codename donot work (6 replies)
  202. Extract Unique Records & Copy to New Worksheets (1 replies)
  203. VBA Error Message (8 replies)
  204. Solved: Cell address : loop till 2006 data (7 replies)
  205. Indexing of custom - type properties (4 replies)
  206. [SOLVED:] Registration/ Clocking system (15 replies)
  207. Simple vba for tagging colored cells (9 replies)
  208. Pass a variable to a user form (24 replies)
  209. Default Number Format for Pivot Table (2 replies)
  210. Solved: Print to non-default printer (5 replies)
  211. INPUT AND RESULT (2 replies)
  212. How to hide VBA combobox on Excel Sheet when it?s drop down? (1 replies)
  213. Password entry (1 replies)
  214. Workign with Image - Should be Simple? (5 replies)
  215. set the security level to "Medium" through vba code (7 replies)
  216. combo boxes pile up when hiding rows (6 replies)
  217. Hiding/unhiding worksheets with option buttons (12 replies)
  218. Solved: Hiding and unhiding rows (0 replies)
  219. Solved: VBA Excel 2003 escape listbox control on worksheet (4 replies)
  220. Importing a CSV and via Userform (1 replies)
  221. Excel VBA - Allow users to choose folder to save file (8 replies)
  222. Solved: Recycle UserForm (2 replies)
  223. Solved: find match copy cells to offset (18 replies)
  224. Problem Between Test and Physical Run (2 replies)
  225. Solved: display time (10 replies)
  226. Open a file from ftp site (3 replies)
  227. Solved: Printing Settings (1 replies)
  228. Solved: what's wrong with ActiveChart.Export code (5 replies)
  229. Validation Based On Another Column (9 replies)
  230. Copy data to Excel (11 replies)
  231. Dynamic charts (1 replies)
  232. MS graph question (0 replies)
  233. Comparing data in 2 worksheets & marking them if the respective cells donot match (4 replies)
  234. Solved: Quick Newb Question (4 replies)
  235. SOLVED: Finding #VALUE! as a value (6 replies)
  236. Solved: Quick Question - Easy, but not for me! (8 replies)
  237. MSFlexgrid alternative (0 replies)
  238. Macro to display who has Spreadsheet open in 'Read Write' mode? (3 replies)
  239. Solved: Increasing column width (5 replies)
  240. Solved: Can I select a Range of Sheets (16 replies)
  241. Duplicate or EXTRA rows (7 replies)
  242. I want 'sum', not 'count'... (11 replies)
  243. Sleeper: Pivot table Refresh (1 replies)
  244. Solved: re-using macros and pivotTables (3 replies)
  245. Solved: Generating Payslip (11 replies)
  246. Solved: (c) copyright - anyway to stop this (3 replies)
  247. Problem launching Excel using code (14 replies)
  248. Import data from selected sheets of other wb (0 replies)
  249. Protection - Trial Version (5 replies)
  250. find, copy, delete, paste (13 replies)