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. Solved: Function - Lookup sub for file path (2 replies)
  2. Solved: Table customisation thru Pivot Table (5 replies)
  3. Solved: #NA problem (10 replies)
  4. Solved: Format problem (5 replies)
  5. double click (9 replies)
  6. Solved: A function that pulls earliest date based on multiple criteria (3 replies)
  7. why can i see it and other can't? (3 replies)
  8. Can you tell me why it sends two emails? (6 replies)
  9. Userform checkbox captions to a cell (1 replies)
  10. Search and Replace Special (12 replies)
  11. Changing Date Format in an array (1 replies)
  12. Combining code to make smaller (12 replies)
  13. Formulas that do not run (4 replies)
  14. Solved: how to check duplication of columns? (4 replies)
  15. Solved: Sum of columns (7 replies)
  16. textbox events? (14 replies)
  17. Solved: Chart Formatting (1 replies)
  18. Solved: POP UP MESSAGE (11 replies)
  19. Solved: Formulas, entered by macro (8 replies)
  20. Hiding blank rows below Pivot Table (27 replies)
  21. Solved: Gather tab names from workbook (9 replies)
  22. Cell format (5 replies)
  23. Solved: Copy paste special (2 replies)
  24. Solved: Excel VBA Email to more than one recipient (6 replies)
  25. Convert Excel Workbooks into Text files, Compare them & store result back ito Excel (6 replies)
  26. Solved: Dropdown list problem (4 replies)
  27. Is this code correct? (8 replies)
  28. Using 'Ontime' (4 replies)
  29. Importing a Text File (6 replies)
  30. Solved: Track File Usage (13 replies)
  31. Solved: Simple formula not working (13 replies)
  32. recopy value in column without dupes (1 replies)
  33. Classes, Instance, What is this all about? (14 replies)
  34. excel and sharepoint 2007 (1 replies)
  35. Solved: Deleting file at end of code (6 replies)
  36. Only locking particular cells without protecting the whole sheet? (13 replies)
  37. Solved: Hiding Command Toolbars (2 replies)
  38. Solved: protect formulas (6 replies)
  39. How to protect the macro code? (1 replies)
  40. Run Time errror 1004 (3 replies)
  41. Solved: Multi stage sorting and subtotaling of Excel Data Base (5 replies)
  42. Sheet selection + Shortcuts (4 replies)
  43. populate data based on a list (5 replies)
  44. Send as Attachment - Change coding from Excel 2003 to Excel 97 (7 replies)
  45. Solved: Determine is Sheet exists based on list (4 replies)
  46. Solved: Goto a worksheet selected by the user (2 replies)
  47. Solved: Code works on step through, but skips when run... (13 replies)
  48. Handling Array Error (6 replies)
  49. Solved: Cell reference in global declaration (4 replies)
  50. Select Row Copy anomaly (10 replies)
  51. Column Exists (1 replies)
  52. Copy values from one sheet to another (7 replies)
  53. Sheet Protection - Which has precedence? (4 replies)
  54. combining two Worksheet_SelectionChange(ByVal Target As Excel.Range) correctly (3 replies)
  55. Solved: Debug.Print (5 replies)
  56. Solved: Cell formatting (5 replies)
  57. Solved: Dealing with multiple columns with variables (2 replies)
  58. Deleting a formula from a cell once the result is given (11 replies)
  59. Assist in creating loop w/ multi-variables (14 replies)
  60. run macro for an entire folder contents (2 replies)
  61. Solved: WB + WS vba headache (8 replies)
  62. Macros do not work (1 replies)
  63. Solved: Test if Autofilter is on (2 replies)
  64. Create Image of selected cells and save outside of Excel (5 replies)
  65. Solved: create new workbook B from subtotals in workbook A (4 replies)
  66. Solved: reducing size of Excel files (4 replies)
  67. Solved: Tabbing Issue (9 replies)
  68. Solved: calling a sub in another add-in (7 replies)
  69. Solved: Forming a variable name (4 replies)
  70. Solved: Code help (3 replies)
  71. Formatting text in a formula (4 replies)
  72. how to write if a=b in VBA? (2 replies)
  73. Solved: Whole row becomes shaded / highlighted when selected (3 replies)
  74. Web Query Questions (1 replies)
  75. transfer of data from userform to sheet (29 replies)
  76. Whole row of active cell should be bold (14 replies)
  77. Sorting Columns (4 replies)
  78. Web Query -- URL Dynamically post (1 replies)
  79. Solved: Populate boxes on form with value from 1 cell (2 replies)
  80. Variables and Chart Series (2 replies)
  81. "Reset" Lastcell (8 replies)
  82. switch cells (10 replies)
  83. Solved: SETTING USER TO CLOSE WORKBOOK IN A BUTTON NOT IN WINDOW (23 replies)
  84. Cut and Paste Problem (2 replies)
  85. Input data into web form write to Excel (10 replies)
  86. Solved: Sheets Problem (1 replies)
  87. Import Access table to Excel (2 replies)
  88. VBA: Append letter "JS" (1 replies)
  89. Exit Excel Macro (4 replies)
  90. Solved: Setting Window height & width (4 replies)
  91. Solved: Column Number (2 replies)
  92. Solved: user access (6 replies)
  93. Import data from Text file using macros (5 replies)
  94. serious problem re: cut copy and paste (5 replies)
  95. Userform To Act As A Login With A Password To Use The Spreadsheet (6 replies)
  96. DELETING SYMBOLS (9 replies)
  97. Finding the Folder that the working file is in (3 replies)
  98. Solved: Error Checking against opening file (1 replies)
  99. Solved: Change Link Source in a protected sheet (17 replies)
  100. Array size limits? (8 replies)
  101. How to have a macro run by itself (20 replies)
  102. Solved: Help:Switch automatic changing case ON/OFF? (8 replies)
  103. Help with query (1 replies)
  104. Solved: Design of reformat macro (22 replies)
  105. Solved: Prevent Duplicate Date in Validation Code (6 replies)
  106. Solved: Re-writing my VBS into VBA Excel... minor bug (2 replies)
  107. Solved: Searching a very specific Value (6 replies)
  108. Solved: Conditional formating (2 replies)
  109. Solved: Excel User Forms with multiple selections (6 replies)
  110. how to delete the column when the shape is deleted? (14 replies)
  111. toggleButtons (4 replies)
  112. query does not work (1 replies)
  113. Export Excel Range to Access (9 replies)
  114. Solved: Highlight control in UserForm (11 replies)
  115. Solved: Changing Date Format Within an Array (3 replies)
  116. Recognize other programs running (3 replies)
  117. worksheetname (6 replies)
  118. Checking date in cell A1 Monday or not (2 replies)
  119. Solved: Scrolling in Form threw rows (17 replies)
  120. Inputing Userform data into spreadsheet (30 replies)
  121. Tabbing Issues (3 replies)
  122. Solved: ROUND OFF TO NEAREST INCREMENT IN 25 (3 replies)
  123. Open Bloomberg (3 replies)
  124. Solved: UserForm Navigation (16 replies)
  125. Solved: Auto Comment (4 replies)
  126. Save copy. (2 replies)
  127. SaveAs: Keep original copy open? (16 replies)
  128. Where does code go (2 replies)
  129. Exporting data from Access to Excel (6 replies)
  130. Solved: USEFORM COMBO BOX VALUE USING IF (3 replies)
  131. Pivot Table events (5 replies)
  132. Read Only File (4 replies)
  133. Solved: Work Sheet Naming (7 replies)
  134. Switch to workbook if already open (7 replies)
  135. Mouse Icon over Cell Change (4 replies)
  136. adding date with double click (7 replies)
  137. [SOLVED:] Refresh Pivot with larger cache (12 replies)
  138. Solved: Matching Date Types (3 replies)
  139. Solved: Using the EOMonth Function (2 replies)
  140. Solved: link to return to form (10 replies)
  141. copying a worksheet that is hidden? (2 replies)
  142. code to close workbook (1 replies)
  143. Data Validation - Combo box using Named Ranges ? INDIRECT (5 replies)
  144. Solved: Auto Date Populate in form (13 replies)
  145. Solved: Macro to AutoRun at Night on Network - will it work? (9 replies)
  146. Compare and Print with VBA HELP!! (10 replies)
  147. Set up table to search Web for specific Item details (8 replies)
  148. Copy "X" number of records to new file (21 replies)
  149. Solved: SUMPRODUCT WITH COLUMN() (10 replies)
  150. Solved: Delete Empty Rows (11 replies)
  151. UCase Help (22 replies)
  152. Solved: For Each Loop- Multiple columns? (2 replies)
  153. Solved: AutoFilters: need simple tutorial, and differences (?) for Mac users? (5 replies)
  154. Excel userform pass values to SQl query (5 replies)
  155. EXCEL MACROS: Convert Absolute Reference cell into Relative one (16 replies)
  156. 1004 error (2 replies)
  157. Listbox Values to Select ppt Shape (2 replies)
  158. Best loop to use? (23 replies)
  159. Solved: Excel Template and Excel Database (11 replies)
  160. Solved: Form Radio Buttons (7 replies)
  161. Solved: Rename tab (4 replies)
  162. lotus email problem (3 replies)
  163. nesting a vba function (9 replies)
  164. Using the MATCH command (12 replies)
  165. Solved: Combobox Value in Userform to a textbox in an activeworksheet (3 replies)
  166. Solved: Selecting Non-adjacent columns (3 replies)
  167. Solved: Merging Worksheets into one Master Sheet (21 replies)
  168. Solved: Eliminating the "Data May Exist in the Sheets Selected for deletion" window (1 replies)
  169. Solved: resetting a variable to empty (5 replies)
  170. Write Reserved Error With Save As Macro (5 replies)
  171. Start Range down 1 Row (19 replies)
  172. calculation state (3 replies)
  173. Copying chart parameters from one chart to another (10 replies)
  174. The sampler should give transactions of (5 replies)
  175. Individual Dates To Consecutive Dates (5 replies)
  176. Solved: How to protect macro code.. (2 replies)
  177. Cell Reference in another excel file (2 replies)
  178. Solved: Printing different columns (18 replies)
  179. -2147417848 Object Disconnedted from client (0 replies)
  180. getting worksheetnames as links (4 replies)
  181. Data from Web page / IE into Excel (0 replies)
  182. Cell on Click Event? (8 replies)
  183. Solved: Comparing a list between two worksheets (6 replies)
  184. Solved: Changing Date Format (1 replies)
  185. Select unique value (4 replies)
  186. Solved: Changing Date Format in an Array (5 replies)
  187. Prevent sub routines from running (1 replies)
  188. Trying to make a loop to shorten my code (2 replies)
  189. Web query help (21 replies)
  190. Input Mask? (13 replies)
  191. Solved: Testing the Left Header (2 replies)
  192. Merge Data from 2 lists into 1 without duplicates (3 replies)
  193. Vlookup if I don't know the name of the workbook (40 replies)
  194. Solved: Add to a Year if not formated as a number (4 replies)
  195. Solved: Copy a range from 1 workbook to another workbook (10 replies)
  196. Solved: PivotTable Finding x,y First Non-Blank Cell in Row Returning Column # (4 replies)
  197. Solved: Offset List Help (5 replies)
  198. Solved: Conditional Format of textbox on form (4 replies)
  199. Combine Workbooks based on Date (2 replies)
  200. detecting open WB at start up (8 replies)
  201. need help with VBA code for conditional formatting (1 replies)
  202. Shade all Blank rows in Range (7 replies)
  203. Line numbering in the VBE (7 replies)
  204. Solved: Run-time error '1004': Issue (2 replies)
  205. A Simple Email from Excel (8 replies)
  206. UserForm clear controls (8 replies)
  207. copying data from different workbooks. (5 replies)
  208. Compare two xls files and generate a report/result file (2 replies)
  209. Solved: generate ws from template adding data from range on main sheet (25 replies)
  210. Ignoring item in unique list formula? (3 replies)
  211. copying worksheets (6 replies)
  212. Solved: I am getting " ' " in front of text (8 replies)
  213. Filtering A Worksheet (12 replies)
  214. intersect function (4 replies)
  215. Solved: Test Date if it is Weekend or Holiday (8 replies)
  216. CVar'ing a string (1 replies)
  217. Solved: Variable Help (31 replies)
  218. Solved: UDF For Convering a Formula To Resource Addresses (8 replies)
  219. Find Excel workbooks in many SubFolders and create hyperlink for it (5 replies)
  220. Attach button to sheet/ access from Private Sub (10 replies)
  221. Solved: Locating Address without Selecting cell (2 replies)
  222. Solved: "Action" menu item? (5 replies)
  223. Do Calculation with Form before I enter on worksheet (4 replies)
  224. Re-setting Checkbox Number (4 replies)
  225. Solved: Use VBA to compare two columns in Excel and highlight the cells that are similar (4 replies)
  226. Sleeper: Few Quick Questions (14 replies)
  227. UserForm - clear contents for next entry (2 replies)
  228. Copy data with empty value (0 replies)
  229. Solved: How to save OLE object added in a sheet. (2 replies)
  230. Solved: Compare values in same sheet (8 replies)
  231. Run Macro (6 replies)
  232. Copy Particular Text to Excel File... (4 replies)
  233. Solved: Add a Clear Button (14 replies)
  234. [SOLVED:] A Problem in an User Definied Function About Color Info (7 replies)
  235. Need help, don't know VBA. (1 replies)
  236. Command in execution time (0 replies)
  237. Solved: Copy cells from a excel form to different worksheets (5 replies)
  238. Relative Reference (7 replies)
  239. Solved: Excel Auto Fill columns (16 replies)
  240. Solved: Error on "Save As" (5 replies)
  241. Hyperlink to another form. (6 replies)
  242. picking up file names in one folder (9 replies)
  243. Macro to attach numerous pdf files and email via lotus notes (6 replies)
  244. help in unhiding all hidden cells and worksheets (7 replies)
  245. Dropping off all characters after .xx decimal place (not rounding up or down) (4 replies)
  246. Solved: Chart from a list of cells with count of numbers as data (5 replies)
  247. Solved: Getting rid of message box (3 replies)
  248. Solved: Concatenate and Autonumbering (2 replies)
  249. Solved: Create Email with Hyperlink to Network Folder (3 replies)
  250. Copying Cell to another Worksheet (8 replies)