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: Help:Switch automatic changing case ON/OFF? (8 replies)
  2. Help with query (1 replies)
  3. Solved: Design of reformat macro (22 replies)
  4. Solved: Prevent Duplicate Date in Validation Code (6 replies)
  5. Solved: Re-writing my VBS into VBA Excel... minor bug (2 replies)
  6. Solved: Searching a very specific Value (6 replies)
  7. Solved: Conditional formating (2 replies)
  8. Solved: Excel User Forms with multiple selections (6 replies)
  9. how to delete the column when the shape is deleted? (14 replies)
  10. toggleButtons (4 replies)
  11. query does not work (1 replies)
  12. Export Excel Range to Access (9 replies)
  13. Solved: Highlight control in UserForm (11 replies)
  14. Solved: Changing Date Format Within an Array (3 replies)
  15. Recognize other programs running (3 replies)
  16. worksheetname (6 replies)
  17. Checking date in cell A1 Monday or not (2 replies)
  18. Solved: Scrolling in Form threw rows (17 replies)
  19. Inputing Userform data into spreadsheet (30 replies)
  20. Tabbing Issues (3 replies)
  21. Solved: ROUND OFF TO NEAREST INCREMENT IN 25 (3 replies)
  22. Open Bloomberg (3 replies)
  23. Solved: UserForm Navigation (16 replies)
  24. Solved: Auto Comment (4 replies)
  25. Save copy. (2 replies)
  26. SaveAs: Keep original copy open? (16 replies)
  27. Where does code go (2 replies)
  28. Exporting data from Access to Excel (6 replies)
  29. [SOLVED:] Userform combobox value using if (3 replies)
  30. Pivot Table events (5 replies)
  31. Read Only File (4 replies)
  32. Solved: Work Sheet Naming (7 replies)
  33. Switch to workbook if already open (7 replies)
  34. Mouse Icon over Cell Change (4 replies)
  35. adding date with double click (7 replies)
  36. [SOLVED:] Refresh Pivot with larger cache (12 replies)
  37. Solved: Matching Date Types (3 replies)
  38. Solved: Using the EOMonth Function (2 replies)
  39. Solved: link to return to form (10 replies)
  40. copying a worksheet that is hidden? (2 replies)
  41. [SOLVED:] code to close workbook (1 replies)
  42. Data Validation - Combo box using Named Ranges ? INDIRECT (5 replies)
  43. Solved: Auto Date Populate in form (13 replies)
  44. Solved: Macro to AutoRun at Night on Network - will it work? (9 replies)
  45. Compare and Print with VBA HELP!! (10 replies)
  46. Set up table to search Web for specific Item details (8 replies)
  47. Copy "X" number of records to new file (21 replies)
  48. Solved: SUMPRODUCT WITH COLUMN() (10 replies)
  49. Solved: Delete Empty Rows (11 replies)
  50. UCase Help (22 replies)
  51. Solved: For Each Loop- Multiple columns? (2 replies)
  52. Solved: AutoFilters: need simple tutorial, and differences (?) for Mac users? (5 replies)
  53. Excel userform pass values to SQl query (5 replies)
  54. EXCEL MACROS: Convert Absolute Reference cell into Relative one (16 replies)
  55. 1004 error (2 replies)
  56. Listbox Values to Select ppt Shape (2 replies)
  57. Best loop to use? (23 replies)
  58. Solved: Excel Template and Excel Database (11 replies)
  59. Solved: Form Radio Buttons (7 replies)
  60. Solved: Rename tab (4 replies)
  61. lotus email problem (3 replies)
  62. nesting a vba function (9 replies)
  63. Using the MATCH command (12 replies)
  64. Solved: Combobox Value in Userform to a textbox in an activeworksheet (3 replies)
  65. Solved: Selecting Non-adjacent columns (3 replies)
  66. Solved: Merging Worksheets into one Master Sheet (21 replies)
  67. Solved: Eliminating the "Data May Exist in the Sheets Selected for deletion" window (1 replies)
  68. Solved: resetting a variable to empty (5 replies)
  69. Write Reserved Error With Save As Macro (5 replies)
  70. [SOLVED:] Start Range down 1 Row (19 replies)
  71. calculation state (3 replies)
  72. Copying chart parameters from one chart to another (10 replies)
  73. The sampler should give transactions of (5 replies)
  74. Individual Dates To Consecutive Dates (5 replies)
  75. Solved: How to protect macro code.. (2 replies)
  76. Cell Reference in another excel file (2 replies)
  77. Solved: Printing different columns (18 replies)
  78. -2147417848 Object Disconnedted from client (0 replies)
  79. getting worksheetnames as links (4 replies)
  80. Data from Web page / IE into Excel (0 replies)
  81. Cell on Click Event? (8 replies)
  82. Solved: Comparing a list between two worksheets (6 replies)
  83. Solved: Changing Date Format (1 replies)
  84. Select unique value (4 replies)
  85. Solved: Changing Date Format in an Array (5 replies)
  86. Prevent sub routines from running (1 replies)
  87. Trying to make a loop to shorten my code (2 replies)
  88. Web query help (21 replies)
  89. Input Mask? (13 replies)
  90. Solved: Testing the Left Header (2 replies)
  91. Merge Data from 2 lists into 1 without duplicates (3 replies)
  92. Vlookup if I don't know the name of the workbook (40 replies)
  93. Solved: Add to a Year if not formated as a number (4 replies)
  94. Solved: Copy a range from 1 workbook to another workbook (10 replies)
  95. Solved: PivotTable Finding x,y First Non-Blank Cell in Row Returning Column # (4 replies)
  96. Solved: Offset List Help (5 replies)
  97. Solved: Conditional Format of textbox on form (4 replies)
  98. Combine Workbooks based on Date (2 replies)
  99. detecting open WB at start up (8 replies)
  100. need help with VBA code for conditional formatting (1 replies)
  101. [SOLVED:] Shade all Blank rows in Range (7 replies)
  102. Line numbering in the VBE (7 replies)
  103. Solved: Run-time error '1004': Issue (2 replies)
  104. A Simple Email from Excel (8 replies)
  105. UserForm clear controls (8 replies)
  106. copying data from different workbooks. (5 replies)
  107. Compare two xls files and generate a report/result file (2 replies)
  108. Solved: generate ws from template adding data from range on main sheet (25 replies)
  109. Ignoring item in unique list formula? (3 replies)
  110. copying worksheets (6 replies)
  111. Solved: I am getting " ' " in front of text (8 replies)
  112. Filtering A Worksheet (12 replies)
  113. intersect function (4 replies)
  114. Solved: Test Date if it is Weekend or Holiday (8 replies)
  115. CVar'ing a string (1 replies)
  116. Solved: Variable Help (31 replies)
  117. Solved: UDF For Convering a Formula To Resource Addresses (8 replies)
  118. Find Excel workbooks in many SubFolders and create hyperlink for it (5 replies)
  119. Attach button to sheet/ access from Private Sub (10 replies)
  120. Solved: Locating Address without Selecting cell (2 replies)
  121. [SOLVED:] S"Action" menu item? (5 replies)
  122. Do Calculation with Form before I enter on worksheet (4 replies)
  123. Re-setting Checkbox Number (4 replies)
  124. Solved: Use VBA to compare two columns in Excel and highlight the cells that are similar (4 replies)
  125. Sleeper: Few Quick Questions (14 replies)
  126. UserForm - clear contents for next entry (2 replies)
  127. Copy data with empty value (0 replies)
  128. Solved: How to save OLE object added in a sheet. (2 replies)
  129. Solved: Compare values in same sheet (8 replies)
  130. Run Macro (6 replies)
  131. Copy Particular Text to Excel File... (4 replies)
  132. Solved: Add a Clear Button (14 replies)
  133. [SOLVED:] A Problem in an User Definied Function About Color Info (7 replies)
  134. Need help, don't know VBA. (1 replies)
  135. Command in execution time (0 replies)
  136. Solved: Copy cells from a excel form to different worksheets (5 replies)
  137. Relative Reference (7 replies)
  138. Solved: Excel Auto Fill columns (16 replies)
  139. Solved: Error on "Save As" (5 replies)
  140. Hyperlink to another form. (6 replies)
  141. picking up file names in one folder (9 replies)
  142. Macro to attach numerous pdf files and email via lotus notes (6 replies)
  143. help in unhiding all hidden cells and worksheets (7 replies)
  144. Dropping off all characters after .xx decimal place (not rounding up or down) (4 replies)
  145. Solved: Chart from a list of cells with count of numbers as data (5 replies)
  146. Solved: Getting rid of message box (3 replies)
  147. Solved: Concatenate and Autonumbering (2 replies)
  148. Solved: Create Email with Hyperlink to Network Folder (3 replies)
  149. Copying Cell to another Worksheet (8 replies)
  150. Solved: Question re: Browse For Folder KBase article (12 replies)
  151. Help w/ Loop (9 replies)
  152. SubFolders of GetFolder(x).SubFolders (29 replies)
  153. function category (2 replies)
  154. Help With Sorting (8 replies)
  155. Clear cell edit (12 replies)
  156. reminder box (11 replies)
  157. Using user-defined functions in formulas (2 replies)
  158. Can I combine these into 4 lines? (2 replies)
  159. UserForm- Select records from Access (1 replies)
  160. Solved: Delete rows based on Criteria in two cols (3 replies)
  161. Copying and Storing VBA Code in DB (10 replies)
  162. printing issue (2 replies)
  163. Solved: Delete Rows with same information (8 replies)
  164. Solved: Help required for Excel VBA query (15 replies)
  165. Solved: Checkbox help (14 replies)
  166. Highlight if less then subtotal (19 replies)
  167. Solved: create User Friendly Spreadsheet (13 replies)
  168. Listbox worksheet help (9 replies)
  169. copy data in the last row automatically (5 replies)
  170. Solved: Setting the Directory - SaveAs (3 replies)
  171. amending Array MATCH formula to cope with blanks? (4 replies)
  172. Solved: Curing #NUM! when formula finds no match? (1 replies)
  173. Summing non contiguous range minus last 2 cells of range? (6 replies)
  174. 2-Part Workbook Question- Save & Save As (43 replies)
  175. [SOLVED:] Range in VBA (12 replies)
  176. Retrieving data based on a combobox selection (11 replies)
  177. Solved: countif and offset help for 2 work sheets (10 replies)
  178. Solved: Speedy PageSetup (15 replies)
  179. Hyperlinks within a userform (1 replies)
  180. Transfer Array to worksheet (3 replies)
  181. Deleting Checkboxes (9 replies)
  182. I lose page break formatting when attempting to print (3 replies)
  183. data store in access .. (13 replies)
  184. UserForm, Copy Data (10 replies)
  185. userform help wanted (1 replies)
  186. Datepicker Null value. (8 replies)
  187. Solved: generate reports.. need help... (8 replies)
  188. Solved: Compare Worksheets (2 replies)
  189. Solved: Open & copy from files with differing names (8 replies)
  190. My Print Layout Reverts Right Before Printing (0 replies)
  191. Change Print to 'Landscape' (4 replies)
  192. Need help with a function called PAYBACK (5 replies)
  193. Solved: CheckBox Delete in Macro (2 replies)
  194. Sleeper: Moving Items in a ListBox (6 replies)
  195. create and run a worksheet template macro in a middle of other process !!! (5 replies)
  196. check if a file exists (4 replies)
  197. Solved: Why won't this work? (19 replies)
  198. stop closing a worksheet unless press a button (1 replies)
  199. Solved: Sheet Change Event (4 replies)
  200. Solved: Copying UserForm between project files (13 replies)
  201. Solved: copy data from one worksheet to another in same workbook (6 replies)
  202. Countdown Clock (1 replies)
  203. Solved: How to check the values stored in excel sheet thru VBA (8 replies)
  204. Saving after autodeleting (4 replies)
  205. Automatically run macro every 5 minutes (1 replies)
  206. Excel not properly closing (3 replies)
  207. looping cut & paste (8 replies)
  208. ActiveCell - shifting from one workbook to another (2 replies)
  209. Comparing columns (0 replies)
  210. Solved: Format Extracted Data (13 replies)
  211. UserForm-ListBox (10 replies)
  212. Solved: Convert to txt (6 replies)
  213. [SOLVED:] Save small icons as pictures (4 replies)
  214. Newbie Function Compile Error (8 replies)
  215. Solved: Unhide only certain sheets Macro (11 replies)
  216. Solved: Listbox starting value - vlookup disappears? (5 replies)
  217. Solved: Statusbar progress percentage value (3 replies)
  218. Date Format - Non-English (6 replies)
  219. Options of Excel 2007 (2 replies)
  220. Making a report based on 4 sheets (16 replies)
  221. Solved: Application-defined or object-defined error (7 replies)
  222. VBA DateDiff() Problem (6 replies)
  223. Menu bar on a User Form (3 replies)
  224. Copying to list (19 replies)
  225. Solved: Setting Available References (2 replies)
  226. How to solve the strings and sentence (4 replies)
  227. Sorting in PivotTable or Hiding a PivotField (0 replies)
  228. Solved: Find text, return near by text based on an offset(more efficient way?) (9 replies)
  229. random problem (1 replies)
  230. PivotTable question (0 replies)
  231. Global Variable accross multiple procedures (2 replies)
  232. Solved: How come this works on 2007 but not on 2003 (12 replies)
  233. Importing html's source code into Excel ! (0 replies)
  234. Solved: Forms 101... showing range of cells on a user form (13 replies)
  235. Concept only required (107 replies)
  236. Worksheet Change Event (2 replies)
  237. how to modify Novell Groupwise VBA script? (11 replies)
  238. Insert Row based on partial cell value (2 replies)
  239. Find Blank Row and Sum Cells Above it?? (5 replies)
  240. Solved: Unhide and hide desired sheets from macro (10 replies)
  241. Copy worksheets to new workbooks (4 replies)
  242. to modify an existing code (5 replies)
  243. create .xls file from false condition (1 replies)
  244. Username and Password (9 replies)
  245. A useful Risk Liklihood Matrix (2 replies)
  246. help on duplication code (14 replies)
  247. Solved: Create hyperlink and activate it (4 replies)
  248. [SOLVED:] Sorting inside single cell (5 replies)
  249. Email On Click Cell (1 replies)
  250. Break down a string (3 replies)