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. problem with date format when I use userform (4 replies)
  2. Linking Excel to Access Forms (0 replies)
  3. Validating column Heads (2 replies)
  4. Value change with date (3 replies)
  5. sending mail from excel via smtp-relay (1 replies)
  6. Excel to Power Point (4 replies)
  7. Solved: fill in every other row (1 replies)
  8. adding a message box icon (6 replies)
  9. Import and split large tab deliminated text files (3 replies)
  10. Locking blank cells only via VBA (2 replies)
  11. Mail merge where person and file name are the same. (2 replies)
  12. [SLEEPER:] VLookup like ? (2 replies)
  13. Show messagebox if user selects locked cells (1 replies)
  14. Solved: Create new folder within VB (5 replies)
  15. Locking cells in different range (1 replies)
  16. Solved: UPDATE FORMULA (5 replies)
  17. Solved: Accessing Cells With Activecell.offset (8 replies)
  18. Solved: help with saving a program (3 replies)
  19. Go To Dialog Box Width F5 (1 replies)
  20. Solved: Sumif with concatenate and wildcard (2 replies)
  21. Solved: Making more checkboxes visible when a checkbox is checked (6 replies)
  22. Solved: Define range and combine two codes (6 replies)
  23. Solved: how to condense results from multiple sheets (3 replies)
  24. Track changes if array or multiple cells are changed (1 replies)
  25. Solved: Sum Dynamic row in VBA (3 replies)
  26. Solved: Open File on shared network drive and copy information to sheet (4 replies)
  27. repeated action (1 replies)
  28. Sleeper: Copying new data from one sheet to another (1 replies)
  29. Save columns A:D to C:\ (9 replies)
  30. Find for a specific word and extract details based on the found value (40 replies)
  31. Solved: Locking down a spreadsheet (4 replies)
  32. Have predetermined data appear in one cell, when specific data entered in another. (1 replies)
  33. Solved: Check cell for text (7 replies)
  34. Solved: Lookup & transpose variable range from 1 To 3 columns (12 replies)
  35. Solved: formula to extract number (6 replies)
  36. Solved: Userform Calendar Control modification (9 replies)
  37. Include Row Number in XLFilterCopy (4 replies)
  38. vlookup match columns (5 replies)
  39. Rename file excle (5 replies)
  40. VBA Web Query Generating Error 1004 (0 replies)
  41. Solved: CELLS W/ NO VALUE NOT EQUAL TO BLANK (9 replies)
  42. Solved: One sheet dependent on input on another? (2 replies)
  43. UserForm - List Box Error Message (3 replies)
  44. Solved: Checkbox issue (5 replies)
  45. Saving data in .dat format-help needed (9 replies)
  46. macro to run a series of tasks (2 replies)
  47. Mail to macro (1 replies)
  48. Copy Data From WebPage To Excel (1 replies)
  49. Copy Duplication (9 replies)
  50. Solved: web forms/log ins + VBA? (5 replies)
  51. Access Report (3 replies)
  52. changing cell contents on basis off another cell (9 replies)
  53. parse text (4 replies)
  54. mirror fill color from reference cell (1 replies)
  55. Solved: ANNIVERSARY YEARS (12 replies)
  56. Solved: Close workbook based upon cell value, but don't save workbook (17 replies)
  57. Show Date And Time Of Latest Import From Yahoo! Finance (0 replies)
  58. Sleeper: Change Col diff into Col letter (4 replies)
  59. Solved: test selection for first and last row (2 replies)
  60. Solved: Sendkeys using wait. (8 replies)
  61. Solved: Array Formulas Using CTRL SHIFT ENTER (8 replies)
  62. Solved: if (RC[1]) = 1 then "=TEXT(RC[-1],""MMM/YY"")" (3 replies)
  63. Formula for summing vertically based on horisontal condition (5 replies)
  64. Right Click menu changed due to macro - how to modify? (12 replies)
  65. Code for changing an entry to uppercase (3 replies)
  66. Solved: hi code tweeking (11 replies)
  67. Solved: Prevent users from editing every 'nth' row - eg every 3rd or 4th row. (5 replies)
  68. Ini. Files problem (5 replies)
  69. Solved: again problem with counting date in week (6 replies)
  70. Date format testing fails (7 replies)
  71. Solved: Is there an ISnumeric or Formula code (1 replies)
  72. Solved: Autofill Cells When Another Cell Has Value (15 replies)
  73. Date Format issues (11 replies)
  74. Group with sum. (15 replies)
  75. Solved: smilies in excell 2003 (5 replies)
  76. need help (2 replies)
  77. Solved: count dates in a week (continue) (2 replies)
  78. Need Help testing if a cells contents match that of a cell in another column (2 replies)
  79. Solved: Linking sub's and selecting cells for a sub (3 replies)
  80. Need help with vba code for deleting trailing spaces before or after an entry in a co (6 replies)
  81. Fine tuning an If formula. Cells matching based on Condition (3 replies)
  82. Real Random number (7 replies)
  83. XML in VBA (2 replies)
  84. Multi Criteria Macro (11 replies)
  85. Solved: Count Dates in a Week (7 replies)
  86. trying to add the new name of a file in a cell (7 replies)
  87. Solved: Update Formulas to include added rows (2 replies)
  88. Solved: Issues with Find (1 replies)
  89. Chart Object Disable Right Click (1 replies)
  90. excel to xml (problem with listed elements) (2 replies)
  91. Solved: How to change the index of an array (20 replies)
  92. Hlookup returns wrong field (5 replies)
  93. Solved: Compatibility of Macros coded in 2007 (12 replies)
  94. Help needed VB code - file name with dates (6 replies)
  95. Scheduling servicing (31 replies)
  96. Sumproduct formula help (13 replies)
  97. Renaming sheet name (3 replies)
  98. Solved: VBA code to merge Worksheets Of Up To 1 Million Records In Ex. 2007 (3 replies)
  99. comment autosize help (2 replies)
  100. Still need help with this vba code (3 replies)
  101. screen up by code the option form (security tab) (1 replies)
  102. Logic assistance, please. (7 replies)
  103. mismatch error (3 replies)
  104. Reference question (5 replies)
  105. Rich Text Format RichTx32.ocx found in \system32 but does not display (4 replies)
  106. Compare two columns for any one word (1 replies)
  107. Vba code for importing external data (3 replies)
  108. VBA userform calendar (4 replies)
  109. Solved: Pivot Table Help (8 replies)
  110. Find shapes in sheet (5 replies)
  111. Un check a CheckBox when others are checked. (7 replies)
  112. Solved: Is it possible to protect specific cells on the sheets, (4 replies)
  113. Fully declaring each variable (3 replies)
  114. Solved: Different expressions of a simple formula (7 replies)
  115. Solved: Making my code smaller (6 replies)
  116. Solved: slow to open a workbook (1 replies)
  117. Solved: bloating of file (9 replies)
  118. Solved: manual calculation for individual workbooks (1 replies)
  119. Form not changing transparency (5 replies)
  120. Filter ListBox based on a ComboBox (12 replies)
  121. Solved: Sheet tab change event (3 replies)
  122. Solved: How do you run ThisWorkbook code from a module? (5 replies)
  123. Worksheet DoubleClick Event (12 replies)
  124. [SOLVED:] Log In-Out Sheet (15 replies)
  125. How to protect my project (10 replies)
  126. Trigger a macro when result changes (17 replies)
  127. Solved: Finding ID Number & Using That Row (3 replies)
  128. Progress Bar (6 replies)
  129. Solved: Floating Toolbars (10 replies)
  130. execute excel (1 replies)
  131. Solved: Merging sheets and stopping Excel from date formatting cells (4 replies)
  132. Solved: How to create a "Live" points table (11 replies)
  133. MSCOMM32.OCX ....Problem (0 replies)
  134. Solved: Help improve reverse loop (4 replies)
  135. Create Copy of a Control (12 replies)
  136. Can not understand what it means! (8 replies)
  137. Solved: Range Select problem (6 replies)
  138. Solved: Can this code be made any more efficient? (10 replies)
  139. Solved: OT - Help Needed To Access My Own Workbook (2 replies)
  140. How to load specific items to the listview 6.0 (2 replies)
  141. Renaming Defined Ranges (4 replies)
  142. Solved: If Value in one column is something and another column is mandatory (5 replies)
  143. microsoft access barcode control 9.0 active X running error (5 replies)
  144. Skip Cell VBA Help Change Code (3 replies)
  145. Visual Basic - Import and Insert Photos (3 replies)
  146. Solved: Extracting just the Number in a name (8 replies)
  147. Solved: Test if there is a Ranged Name already (9 replies)
  148. Solved: Printing an array of sheets (10 replies)
  149. Solved: If make confusing.. (8 replies)
  150. Solved: userform to search datasheet & return values (2 replies)
  151. Solved: Connect to Oracle (18 replies)
  152. Closing Errors... (14 replies)
  153. Solved: Insert lines after so many rows (4 replies)
  154. Solved: Is MS excel installation necessary to run VBA code? (6 replies)
  155. Solved: Timesheet Weekly Totals Help (5 replies)
  156. Solved: How do you prevent a row color change event? (13 replies)
  157. Solved: BeforeDoubleClick Question (2 replies)
  158. Solved: Split ONE word into TWO cells (11 replies)
  159. Error running second time (10 replies)
  160. Can I Cascade Dependent Validations? (7 replies)
  161. Sleeper: HTML Data to Excel Cells...Help (3 replies)
  162. Solved: Problem delete and replace item (2 replies)
  163. Solved: Range cell color by Double Clicking (22 replies)
  164. Class property vs public variable (5 replies)
  165. Tracking blood sugar levels (5 replies)
  166. Solved: Formula in vba help (4 replies)
  167. Solved: Extracted Sheets Limits to 43 only why? (12 replies)
  168. Create a new worksheet from existing worksheets plus doing calculations. (5 replies)
  169. Solved: How to reset only the current row color? (2 replies)
  170. Data validation with dependent dropdowns from a sorted list - seperate document? (8 replies)
  171. Inconsistent Behavior When Capturing Application Events From xla Add-in (7 replies)
  172. Solved: Split test column as string (6 replies)
  173. Solved: Need to convert date to three letter month (10 replies)
  174. [SOLVED:] Build file string to import an HTML file (1 replies)
  175. Solved: Alert Message and highlight duplicate (9 replies)
  176. Solved: RESOLVED - How do you set a max column range? (6 replies)
  177. adding/sizing images. (5 replies)
  178. Solved: Custom Menu and Toobar Items for a single file. (6 replies)
  179. Count number of times word occurs in selected column? (7 replies)
  180. Solved: filesearch for .txt and text conversion (11 replies)
  181. Solved: Filter list and place results below (4 replies)
  182. Simple Comparison (4 replies)
  183. Locking Form Controls (7 replies)
  184. Solved: Keep Track of a Workbook Review (2 replies)
  185. Hide Rows Based on Condition (2 replies)
  186. ComboBox help (3 replies)
  187. Help: How to get date input in specific syntax (6 replies)
  188. Solved: Checkbox confirmation (3 replies)
  189. Solved: how to open a folder? (8 replies)
  190. GOTO A different Worksheet named in cell A1 (4 replies)
  191. Solved: need to select and run macro on all worksheets in workbook consecutively (5 replies)
  192. Windows task scheduler and Excel (3 replies)
  193. Solved: MsgBox "Prompt Message" (4 replies)
  194. User-defined type not defined (3 replies)
  195. add a picture to comment (1 replies)
  196. Solved: Compare 2 collums and have a message box display varience (5 replies)
  197. Enabling and Disabling Buttons (1 replies)
  198. Sort-Excel-Custom Cell (5 replies)
  199. Solved: Multiplying cells from gathered information using VBA Excel ONLY (10 replies)
  200. Solved: Complie Error: Expected End Of Statement (21 replies)
  201. Solved: Question about hyperlinks (10 replies)
  202. Solved: switching columns around (1 replies)
  203. Solved: forms - passing valued returned to code (11 replies)
  204. Solved: open file without links (1 replies)
  205. Solved: rows.count in a range (2 replies)
  206. Solved: when autofilter returns nothing (2 replies)
  207. Solved: write reserved (3 replies)
  208. Solved: file size with macro (2 replies)
  209. Solved: Macro Not Updating Worksheets (19 replies)
  210. Strange IE7 quirk when macro is run (3 replies)
  211. Solved: Looping pivot tables (1 replies)
  212. Force Open File (3 replies)
  213. Solved: Copy cells in select columns that match other cells in select columns (30 replies)
  214. Solved: copy rows from worksheet to worksheet (19 replies)
  215. [SOLVED:] Solved: Macro extract external links from Edit>Links and update (31 replies)
  216. Solved: Rename a text file from within Excel (3 replies)
  217. Solved: For loop using columns as counter? (6 replies)
  218. Solved: Listbox Not Loading But should (1 replies)
  219. 2d array looping through x,1 (3 replies)
  220. [SOLVED:] Simple Question about notes (6 replies)
  221. Solved: Userform Updating Query (13 replies)
  222. Searching text entries (13 replies)
  223. Don't delete sheet if don't wirte a password in inputbox (9 replies)
  224. Make columns in pivot tables consistent (0 replies)
  225. Solved: Code Help (14 replies)
  226. Solved: Resolved: Delete row after 3 months (19 replies)
  227. Delete Rows (2 replies)
  228. Userform Unload Data onto Two Worksheets (15 replies)
  229. Manipulating Chart Title (2 replies)
  230. Solved: Variable Filename / No Drive Letter Chosen (4 replies)
  231. Sorting and Charting multiple Ranges (0 replies)
  232. Database search and return of results (2 replies)
  233. Can User Select a cell on Different Worksheet? (3 replies)
  234. Autofilter problem (2 replies)
  235. Converting Columns to Rows (365 to 8760) (6 replies)
  236. BeforeClose event (4 replies)
  237. Progress (5 replies)
  238. Weaving Two "If Not Intersecting" in One Worksheet Change (6 replies)
  239. looking for some help on to work out earliest event time (3 replies)
  240. JULIAN dates (4 replies)
  241. Load database values into Worksheet (3 replies)
  242. Filter and hide macro help (18 replies)
  243. Importing a text file into an excel template (5 replies)
  244. Macro to Saving Data Before Deleting (6 replies)
  245. Solved: Moving Page Breaks (9 replies)
  246. part of code to slow?! (2 replies)
  247. Help with search macro (3 replies)
  248. Solved: % using the color of a cell (21 replies)
  249. Solved: Automate data import (6 replies)
  250. Solved: WordArt Object Blocking Cell Selection (2 replies)