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. Adding/copying tables base on Input Data (1 replies)
  2. Solved: Understanding what used in this file (6 replies)
  3. Field cannot be updated (7 replies)
  4. Converting Excel 97/2000 to Excel XP/2003 (3 replies)
  5. Pics not being copied (1 replies)
  6. Solved: Formula with ranges based on variables (2 replies)
  7. optimization question (6 replies)
  8. Solved: Early Binding ADODB from Excel (7 replies)
  9. Solved: Recording changes in values (1 replies)
  10. [SOLVED:] Using XLQ in VBA (7 replies)
  11. Solved: Image in Comment box problem that Microsoft couldn't help with (7 replies)
  12. hide every n-th row (8 replies)
  13. Querying Access from Excel using VBA (4 replies)
  14. User form hotkeys (9 replies)
  15. call a sub from a combo box (9 replies)
  16. Solved: Sending Email Flagged High Priority (1 replies)
  17. Copy values from several workbooks to one workbook (7 replies)
  18. Solved: if sheet not found end sub, if found goto (18 replies)
  19. Help: The same text but can not error return by VlookUp (2 replies)
  20. Solved: Adding extra vba code (5 replies)
  21. Solved: Prompt user for a range of cells to copy (4 replies)
  22. Solved: Organize inconsistant data from 2 columns to 1 column on different sheet (6 replies)
  23. Solved: onkey event, toggle? (7 replies)
  24. Solved: How to Copy Values from another worksheet to Activeworksheet (5 replies)
  25. How to sort numbers in asceding order? (11 replies)
  26. Tricky IF() use (9 replies)
  27. Solved: Sorten Recorded Macro (17 replies)
  28. Delete all rows after.... (4 replies)
  29. Dealing with Ties when using Vlookup with Rank. (1 replies)
  30. regrouping data (11 replies)
  31. Task complete...note of thanks. (2 replies)
  32. Validation form concept (3 replies)
  33. Visible Timer On Form (6 replies)
  34. Solved: Import multiple text files as new worksheets (11 replies)
  35. Progress Bar - extend run time (12 replies)
  36. Solved: VBA CODE FOR PASTE VALUES (8 replies)
  37. Solved: can't open specific Sheet from Closed Workbook, i get eror's! PLEASE HELP!?! (12 replies)
  38. sql server VBA help (3 replies)
  39. ListView ItemSelectionChanged (0 replies)
  40. Solved: Move row based on text (4 replies)
  41. Solved: Simple Error Handling Help (15 replies)
  42. Looping a combobox (13 replies)
  43. Maximize Excel window (2 replies)
  44. Code to Loop Through Columns & Perform Action (1 replies)
  45. Solved: Use of Daverage in VBA (11 replies)
  46. Solved: newbie question regarding averaging arrays based on dates (14 replies)
  47. Format Cell in Excel 2000 (5 replies)
  48. Solved: use array to speed up copy and paste (6 replies)
  49. Solved: Number format (20 replies)
  50. Interrogating jpeg/jpg files (4 replies)
  51. Compile error: User-defined type not defined (9 replies)
  52. Loops and formulas (4 replies)
  53. on click a cell and copy to another cell (4 replies)
  54. Applying Title and current date to new file (1 replies)
  55. Solved: Left Lookup (5 replies)
  56. Solved: Copy down to blank cells? (10 replies)
  57. Selecting specific sheets to print (12 replies)
  58. Solved: Copying from one workbook to another WITHOUT seeing source (2 replies)
  59. Solved: Quick Formatting Question - Text Alignment (7 replies)
  60. Solved: Offset To Add Formula (4 replies)
  61. run code at specified time each day (6 replies)
  62. Solved: Excel crashes when Force Macros VBA is used (12 replies)
  63. Solved: Display userform pause code (3 replies)
  64. Functions on filtered rows (5 replies)
  65. URGENT!!! How to detect whether a value is convertible or not using the Cxxx() (6 replies)
  66. Solved: newbie wanting to know how to selct a variable range in VBA (7 replies)
  67. Dynamic OptionButton Validation (20 replies)
  68. Solved: More scanning help (4 replies)
  69. Solved: Change text to hyperlink (17 replies)
  70. [SLEEPER:] Validating Cells... (6 replies)
  71. Solved: Change Event? (12 replies)
  72. Tempermental Code seems protection related (5 replies)
  73. How to "tag" worksheet for later identification (10 replies)
  74. EMAIL command button (5 replies)
  75. Solved: Left Function (5 replies)
  76. URGENT!! Detecting Types of Errors as resulted from Cell Formulas (7 replies)
  77. overriding replace dialog box in saveAs method (1 replies)
  78. Solved: Using excel to send email through lotus notes - variable data and open/close notes (2 replies)
  79. changing textbox colour? (6 replies)
  80. CommandBox duel command? (8 replies)
  81. Copy data into Selective Range (0 replies)
  82. Solved: Fill Formula down & paste values up (3 replies)
  83. add a shortcut menu to excel (1 replies)
  84. Conditional formatting formula required for excel (6 replies)
  85. Solved: convert worksheet_change to module sub (5 replies)
  86. Solved: Single Command Button on Multipage (3 replies)
  87. One named range for the same range on 2 or more noncontiguous worksheets (3 replies)
  88. Solved: Help on Concatenate 2 cells under one drop down???? (1 replies)
  89. Display adjacent cell search results (4 replies)
  90. Emailing disjoint cells (1 replies)
  91. Defining sourcerange (10 replies)
  92. Solved: VBA write to a protected cell and I have the password (3 replies)
  93. keep text formating when transfering text from text box to cell (1 replies)
  94. Solved: combining lists into a string (4 replies)
  95. Write in a protected closed workbook (18 replies)
  96. Excel conditional formatting (5 replies)
  97. Solved: Delete pages (3 replies)
  98. Delete a row with the oldest date when project numbers match (12 replies)
  99. Solved: Selection of worksheet (6 replies)
  100. Code; Why Will it not work on any other sheet? (2 replies)
  101. How to search on two or more sheets? (5 replies)
  102. Solved: ComboBox error: Invalid property value (4 replies)
  103. Finding with userform (4 replies)
  104. Solved: openfile dialog retain openned name in variable (7 replies)
  105. Solved: Bulk entry of FormulaR1C1 problem (13 replies)
  106. Assign Macro to ComboBox?? (9 replies)
  107. Help Required with inputing data to excel worksheet (2 replies)
  108. Delete row on condition (18 replies)
  109. Multiple And Condition is Returning Wrong Answer (14 replies)
  110. Instructions for Explicit Error Type (7 replies)
  111. Using Autofilter Custom feature... (5 replies)
  112. Solved: Tips on a smarter way to perform Insert Line & Paste info? (10 replies)
  113. Open workbooks and compare cells (1 replies)
  114. Stumped Excel/Word-post do..loop results from excel to word (3 replies)
  115. Solved: Excel Freezing When Macro Runs (6 replies)
  116. [SOLVED:] Matching rows/values with rows/values of another spreadsheet (11 replies)
  117. Solved: Copying to the next blank cell (3 replies)
  118. conversion of variant (4 replies)
  119. User define the number of boxes in a form (4 replies)
  120. How can I read and write JPG Exif info (0 replies)
  121. excel queryTable (3 replies)
  122. global variables (7 replies)
  123. Setup and Write to a temporary storage location. (15 replies)
  124. Solved: condition (2 replies)
  125. Solved: copying data error (10 replies)
  126. Solved: delete a row (2 replies)
  127. RTF For a Text Box on a Form (0 replies)
  128. Compare Two Strings via Len Function (13 replies)
  129. before the last (16 replies)
  130. automaticaly show Scrollbars (0 replies)
  131. Solved: Trigger event on change/deactive/leave of a specific cell (4 replies)
  132. make the Application active (11 replies)
  133. scanning a column (2 replies)
  134. Saving 100 workbooks automatically (2 replies)
  135. Combine muliple rows into one row based on criteria (1 replies)
  136. Solved: Why doesn't this work? Apply macro to every sheet in book (3 replies)
  137. Email multiple worksheets - help please? (0 replies)
  138. Solved: How to pass a CheckBox to a subroutine (12 replies)
  139. Solved: limit users not to add/enter farmula (5 replies)
  140. Deleting rows when date within cell expires (3 replies)
  141. How to match data, then Copy (6 replies)
  142. Solved: Automating Hyperlinks (1 replies)
  143. Loop through, comparing string question (2 replies)
  144. Solved: How do I 'close' an open workbook? (4 replies)
  145. Getting and Extra Worksheet (2 replies)
  146. event procedures (12 replies)
  147. Solved: Data from userform to sheet (dynamic) (26 replies)
  148. Set Up a Pause Between Calls (15 replies)
  149. Auto list names (6 replies)
  150. interact with htlm (0 replies)
  151. Solved: count the cell hits (7 replies)
  152. Solved: Dealing with very large text files (2 replies)
  153. Hiding/Unhiding Columns based on Criteria (4 replies)
  154. Solved: Transferring Data from a Table (8 replies)
  155. Email message body (1 replies)
  156. Solved: How do I create a "dialog box"...? (4 replies)
  157. Solved: Excel to access cell for cell import (72 replies)
  158. action across all open workbooks (4 replies)
  159. textbox calculation (3 replies)
  160. Using ListView on Excel VBA UserForm (10 replies)
  161. Merging Date and Time from two different cells into one... (3 replies)
  162. Excel 2002 - data validation and copy/paste (0 replies)
  163. Parsing CSV files where data is split over lines (11 replies)
  164. Problem referencing other workbooks (2 replies)
  165. Checking if cell contains a string or a number (3 replies)
  166. Alter code to only clear data from target sheet (10 replies)
  167. look accross as I copy down (4 replies)
  168. Lookup tables (2 replies)
  169. Combobox change (16 replies)
  170. Solved: trapping error messages to hide in vba (2 replies)
  171. Formatting headers & footers in excel (6 replies)
  172. Paste in correct column based on criteria (12 replies)
  173. [SOLVED:] VBA To Run Another Macro at An Interval (2 replies)
  174. Solved: Export XML from Access using Excel VBA (4 replies)
  175. Solved: need to copy data from one workbook to another on selected cells (47 replies)
  176. Solved: How to get the number of days between two dates (3 replies)
  177. Running a macro on another spreadsheet with a macro (14 replies)
  178. Opening a directory and listing all files within (3 replies)
  179. Solved: Select Case not case sensitive (10 replies)
  180. Advanced Calculus VBA Programming (3 replies)
  181. Solved: Combobox in Worksheet (1 replies)
  182. Solved: How do I create a PivotTable from data in a worksheet?... (3 replies)
  183. find substring and display message box (7 replies)
  184. Setting Print Area taking forever (2 replies)
  185. Solved: Project Explorer window...how to display my module names. (3 replies)
  186. Solved: Convert JPEG file to XLS FILE (2 replies)
  187. Line graph - ignore zero (3 replies)
  188. Large size user form (11 replies)
  189. Solved: Syntax error in formula...where am I going wrong? (3 replies)
  190. Print code (4 replies)
  191. Creating a help file. (3 replies)
  192. help in creating function (0 replies)
  193. Solved: Code Deletes headers on .ClearContents (3 replies)
  194. Mulitple importing of text files (3 replies)
  195. Solved: Problem With Choose & Match (6 replies)
  196. [SOLVED:] Gannt Chart (5 replies)
  197. Solved: Updating sheet (2 replies)
  198. Populating Combo boxes (6 replies)
  199. VBA regex multiline match not working (7 replies)
  200. invisible window (2 replies)
  201. offical excel vba tutorials? (9 replies)
  202. Copy cell format, formulas, and insert new row (2 replies)
  203. Update records from user form (4 replies)
  204. multicolumn combobox range (13 replies)
  205. Question re Form option/UserForm (12 replies)
  206. Solved: Count Data Then Send To Correct List (35 replies)
  207. Fetching excel data based on a given contd. (2 replies)
  208. Excel UK Conference 2007 (6 replies)
  209. Code goes into a infinite loop (4 replies)
  210. Solved: Print Multiple Pivot Charts on Single Sheet (2 replies)
  211. how to find the first date? (1 replies)
  212. Solved: Numpty question, but I'm not too proud to ask for help... (10 replies)
  213. Solved: Toolbar has no label (5 replies)
  214. Solved: Macro to match name & date and move info (5 replies)
  215. Solved: VBA Character colour change (3 replies)
  216. Solved: Run Macro When Worksheet Is Selected (2 replies)
  217. [SOLVED:] Syntax for 'LookUp' command? Help... (5 replies)
  218. auto add column (2 replies)
  219. Solved: automatic convert to upper case (2 replies)
  220. Sleeper: Text Edit Mode (1 replies)
  221. Solved: Viewing a text file from within Excel (3 replies)
  222. Creating employee schedules using preferences (6 replies)
  223. Solved: How to run a marquee text in Excel (3 replies)
  224. Time calculation on specific days (1 replies)
  225. Solved: GetSaveAs not actually saving? (3 replies)
  226. need to find the cell which intersets the fixed row and a variable column (10 replies)
  227. speeding up the code (5 replies)
  228. finding the Index value (10 replies)
  229. Private ComboBox Event Subs NOT staying private? (1 replies)
  230. Solved: Set range variable to cell above hidden rows (12 replies)
  231. Restore "lost" custom menus? (2 replies)
  232. Unlist Table (1 replies)
  233. Solved: Help in tabbing (2 replies)
  234. Solved: transfer jpg file to Excel (4 replies)
  235. Solved: delete everything other than (15 replies)
  236. Solved: Run-time error 1004 (macro export/import?) (4 replies)
  237. Run Time Error 91 (14 replies)
  238. Solved: Can I 'pull in' a worksheet (4 replies)
  239. Do not know how to use "Findnext" command (0 replies)
  240. Copy cells from Excel and Paste Special in Word (Clipboard problems) (3 replies)
  241. How do I best integrate and Excel workbook with a website for data capture? (0 replies)
  242. Returning value needs to be changed. (5 replies)
  243. Read a Text file with delimiter as comma and import the infor into excel sheet (3 replies)
  244. Sleeper: Auto sorting validation list (3 replies)
  245. unable to fetch the data from excel sheet based on a given condition. (7 replies)
  246. Solved: How to password protect the VBA Code (6 replies)
  247. UDTs and Collections (1 replies)
  248. Checking to see if other sheets are open (7 replies)
  249. Solved: Automatically start the macro in 15mins (19 replies)
  250. Click The hyperlink provided in a cell of a table (9 replies)