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. Start Range down 1 Row (19 replies)
  2. calculation state (3 replies)
  3. Copying chart parameters from one chart to another (10 replies)
  4. The sampler should give transactions of (5 replies)
  5. Individual Dates To Consecutive Dates (5 replies)
  6. Solved: How to protect macro code.. (2 replies)
  7. Cell Reference in another excel file (2 replies)
  8. Solved: Printing different columns (18 replies)
  9. -2147417848 Object Disconnedted from client (0 replies)
  10. getting worksheetnames as links (4 replies)
  11. Data from Web page / IE into Excel (0 replies)
  12. Cell on Click Event? (8 replies)
  13. Solved: Comparing a list between two worksheets (6 replies)
  14. Solved: Changing Date Format (1 replies)
  15. Select unique value (4 replies)
  16. Solved: Changing Date Format in an Array (5 replies)
  17. Prevent sub routines from running (1 replies)
  18. Trying to make a loop to shorten my code (2 replies)
  19. Web query help (21 replies)
  20. Input Mask? (13 replies)
  21. Solved: Testing the Left Header (2 replies)
  22. Merge Data from 2 lists into 1 without duplicates (3 replies)
  23. Vlookup if I don't know the name of the workbook (40 replies)
  24. Solved: Add to a Year if not formated as a number (4 replies)
  25. Solved: Copy a range from 1 workbook to another workbook (10 replies)
  26. Solved: PivotTable Finding x,y First Non-Blank Cell in Row Returning Column # (4 replies)
  27. Solved: Offset List Help (5 replies)
  28. Solved: Conditional Format of textbox on form (4 replies)
  29. Combine Workbooks based on Date (2 replies)
  30. detecting open WB at start up (8 replies)
  31. need help with VBA code for conditional formatting (1 replies)
  32. Shade all Blank rows in Range (7 replies)
  33. Line numbering in the VBE (7 replies)
  34. Solved: Run-time error '1004': Issue (2 replies)
  35. A Simple Email from Excel (8 replies)
  36. UserForm clear controls (8 replies)
  37. copying data from different workbooks. (5 replies)
  38. Compare two xls files and generate a report/result file (2 replies)
  39. Solved: generate ws from template adding data from range on main sheet (25 replies)
  40. Ignoring item in unique list formula? (3 replies)
  41. copying worksheets (6 replies)
  42. Solved: I am getting " ' " in front of text (8 replies)
  43. Filtering A Worksheet (12 replies)
  44. intersect function (4 replies)
  45. Solved: Test Date if it is Weekend or Holiday (8 replies)
  46. CVar'ing a string (1 replies)
  47. Solved: Variable Help (31 replies)
  48. Solved: UDF For Convering a Formula To Resource Addresses (8 replies)
  49. Find Excel workbooks in many SubFolders and create hyperlink for it (5 replies)
  50. Attach button to sheet/ access from Private Sub (10 replies)
  51. Solved: Locating Address without Selecting cell (2 replies)
  52. Solved: "Action" menu item? (5 replies)
  53. Do Calculation with Form before I enter on worksheet (4 replies)
  54. Re-setting Checkbox Number (4 replies)
  55. Solved: Use VBA to compare two columns in Excel and highlight the cells that are similar (4 replies)
  56. Sleeper: Few Quick Questions (14 replies)
  57. UserForm - clear contents for next entry (2 replies)
  58. Copy data with empty value (0 replies)
  59. Solved: How to save OLE object added in a sheet. (2 replies)
  60. Solved: Compare values in same sheet (8 replies)
  61. Run Macro (6 replies)
  62. Copy Particular Text to Excel File... (4 replies)
  63. Solved: Add a Clear Button (14 replies)
  64. [SOLVED:] A Problem in an User Definied Function About Color Info (7 replies)
  65. Need help, don't know VBA. (1 replies)
  66. Command in execution time (0 replies)
  67. Solved: Copy cells from a excel form to different worksheets (5 replies)
  68. Relative Reference (7 replies)
  69. Solved: Excel Auto Fill columns (16 replies)
  70. Solved: Error on "Save As" (5 replies)
  71. Hyperlink to another form. (6 replies)
  72. picking up file names in one folder (9 replies)
  73. Macro to attach numerous pdf files and email via lotus notes (6 replies)
  74. help in unhiding all hidden cells and worksheets (7 replies)
  75. Dropping off all characters after .xx decimal place (not rounding up or down) (4 replies)
  76. Solved: Chart from a list of cells with count of numbers as data (5 replies)
  77. Solved: Getting rid of message box (3 replies)
  78. Solved: Concatenate and Autonumbering (2 replies)
  79. Solved: Create Email with Hyperlink to Network Folder (3 replies)
  80. Copying Cell to another Worksheet (8 replies)
  81. Solved: Question re: Browse For Folder KBase article (12 replies)
  82. Help w/ Loop (9 replies)
  83. SubFolders of GetFolder(x).SubFolders (29 replies)
  84. function category (2 replies)
  85. Help With Sorting (8 replies)
  86. Clear cell edit (12 replies)
  87. reminder box (11 replies)
  88. Using user-defined functions in formulas (2 replies)
  89. Can I combine these into 4 lines? (2 replies)
  90. UserForm- Select records from Access (1 replies)
  91. Solved: Delete rows based on Criteria in two cols (3 replies)
  92. Copying and Storing VBA Code in DB (10 replies)
  93. printing issue (2 replies)
  94. Solved: Delete Rows with same information (8 replies)
  95. Solved: Help required for Excel VBA query (15 replies)
  96. Solved: Checkbox help (14 replies)
  97. Highlight if less then subtotal (19 replies)
  98. Solved: create User Friendly Spreadsheet (13 replies)
  99. Listbox worksheet help (9 replies)
  100. copy data in the last row automatically (5 replies)
  101. Solved: Setting the Directory - SaveAs (3 replies)
  102. amending Array MATCH formula to cope with blanks? (4 replies)
  103. Solved: Curing #NUM! when formula finds no match? (1 replies)
  104. Summing non contiguous range minus last 2 cells of range? (6 replies)
  105. 2-Part Workbook Question- Save & Save As (43 replies)
  106. Solved: Range in VBA (12 replies)
  107. Retrieving data based on a combobox selection (11 replies)
  108. Solved: countif and offset help for 2 work sheets (10 replies)
  109. Solved: Speedy PageSetup (15 replies)
  110. Hyperlinks within a userform (1 replies)
  111. Transfer Array to worksheet (3 replies)
  112. Deleting Checkboxes (9 replies)
  113. I lose page break formatting when attempting to print (3 replies)
  114. data store in access .. (13 replies)
  115. UserForm, Copy Data (10 replies)
  116. userform help wanted (1 replies)
  117. Datepicker Null value. (8 replies)
  118. Solved: generate reports.. need help... (8 replies)
  119. Solved: Compare Worksheets (2 replies)
  120. Solved: Open & copy from files with differing names (8 replies)
  121. My Print Layout Reverts Right Before Printing (0 replies)
  122. Change Print to 'Landscape' (4 replies)
  123. Need help with a function called PAYBACK (5 replies)
  124. Solved: CheckBox Delete in Macro (2 replies)
  125. Sleeper: Moving Items in a ListBox (6 replies)
  126. create and run a worksheet template macro in a middle of other process !!! (5 replies)
  127. check if a file exists (4 replies)
  128. Solved: Why won't this work? (19 replies)
  129. stop closing a worksheet unless press a button (1 replies)
  130. Solved: Sheet Change Event (4 replies)
  131. Solved: Copying UserForm between project files (13 replies)
  132. Solved: copy data from one worksheet to another in same workbook (6 replies)
  133. Countdown Clock (1 replies)
  134. Solved: How to check the values stored in excel sheet thru VBA (8 replies)
  135. Saving after autodeleting (4 replies)
  136. Automatically run macro every 5 minutes (1 replies)
  137. Excel not properly closing (3 replies)
  138. looping cut & paste (8 replies)
  139. ActiveCell - shifting from one workbook to another (2 replies)
  140. Comparing columns (0 replies)
  141. Solved: Format Extracted Data (13 replies)
  142. UserForm-ListBox (10 replies)
  143. Solved: Convert to txt (6 replies)
  144. Save small icons as pictures (4 replies)
  145. Newbie Function Compile Error (8 replies)
  146. Solved: Unhide only certain sheets Macro (11 replies)
  147. Solved: Listbox starting value - vlookup disappears? (5 replies)
  148. Solved: Statusbar progress percentage value (3 replies)
  149. Date Format - Non-English (6 replies)
  150. Options of Excel 2007 (2 replies)
  151. Making a report based on 4 sheets (16 replies)
  152. Solved: Application-defined or object-defined error (7 replies)
  153. VBA DateDiff() Problem (6 replies)
  154. Menu bar on a User Form (3 replies)
  155. Copying to list (19 replies)
  156. Solved: Setting Available References (2 replies)
  157. How to solve the strings and sentence (4 replies)
  158. Sorting in PivotTable or Hiding a PivotField (0 replies)
  159. Solved: Find text, return near by text based on an offset(more efficient way?) (9 replies)
  160. random problem (1 replies)
  161. PivotTable question (0 replies)
  162. Global Variable accross multiple procedures (2 replies)
  163. Solved: How come this works on 2007 but not on 2003 (12 replies)
  164. Importing html's source code into Excel ! (0 replies)
  165. Solved: Forms 101... showing range of cells on a user form (13 replies)
  166. Concept only required (107 replies)
  167. Worksheet Change Event (2 replies)
  168. how to modify Novell Groupwise VBA script? (11 replies)
  169. Insert Row based on partial cell value (2 replies)
  170. Find Blank Row and Sum Cells Above it?? (5 replies)
  171. Solved: Unhide and hide desired sheets from macro (10 replies)
  172. Copy worksheets to new workbooks (4 replies)
  173. to modify an existing code (5 replies)
  174. create .xls file from false condition (1 replies)
  175. Username and Password (9 replies)
  176. A useful Risk Liklihood Matrix (2 replies)
  177. help on duplication code (14 replies)
  178. Solved: Create hyperlink and activate it (4 replies)
  179. Sorting inside single cell (5 replies)
  180. Email On Click Cell (1 replies)
  181. Break down a string (3 replies)
  182. Find Last Row for "x" (4 replies)
  183. Calculate how many items are in the data field (2 replies)
  184. Solved: Compute Months And Days From Decimal Value... (7 replies)
  185. simple (i think) text manipulation (2 replies)
  186. relative-absolute (10 replies)
  187. Solved: BorderAround only displays on 1 quadrant (4 replies)
  188. Solved: Counting based on Cell Values (5 replies)
  189. Solved: select plot area sheet using cell reference (0 replies)
  190. Solved: Mega help required to remove 1000 block of code (6 replies)
  191. Solved: I want to add hundreds of TXT files into one XLS file (5 replies)
  192. using loops to search through a text file (6 replies)
  193. help on creating new sheets (1 replies)
  194. Solved: Find Last Row With Border (11 replies)
  195. Solved: images (2 replies)
  196. PrintScreen Request (6 replies)
  197. macro for recording changings (14 replies)
  198. automatic sorting (1 replies)
  199. Solved: Object Required error when inserting data from Excel to Access (1 replies)
  200. Solved: BeforeDoubleClick setting column and row? (2 replies)
  201. How to Internet Explorer's HomePage textbox is enable via VBA? (0 replies)
  202. Hiding Unused Worksheets (6 replies)
  203. Mid Formula - extract numerals.. (4 replies)
  204. Solved: Unable to add another record thru click event (2 replies)
  205. EVal function in Excel VBA (5 replies)
  206. Huffman Coding (0 replies)
  207. VBA uploading spreadsheets (3 replies)
  208. Solved: Getting Data from Password Protected Workbook (3 replies)
  209. I need to parse out data into separate columns (2 replies)
  210. Solved: What are the differences between two? (4 replies)
  211. Fun with FUNCTIONS!!! (8 replies)
  212. Copy only visible cells (1 replies)
  213. Expand column range in code (6 replies)
  214. Solved: Weird Problem (3 replies)
  215. Solved: Copy RightHeader onto sheet (2 replies)
  216. My macros connects to Oracle and writes to file but no Excel (1 replies)
  217. when to use error code? (1 replies)
  218. start header and footers on 2nd sheet (3 replies)
  219. Solved: Limit the Number of Sheets in A Workbook (9 replies)
  220. Copy data from CloseWorkbook to OpenWorkbook (2 replies)
  221. Populating listbox in User Forms (0 replies)
  222. Set field lengths (5 replies)
  223. Solved: Adding New Sheet w/ Sequential Date (12 replies)
  224. [SOLVED:] Condense this code ? (9 replies)
  225. Solved: Return cell address of VLOOKUP (4 replies)
  226. Solved: Checkmark in Active Cell (9 replies)
  227. Sheet Names of XLS within a drop down list (4 replies)
  228. Fill Down Automatically? (3 replies)
  229. Refresh All XMLMaps (2 replies)
  230. Assist in developing new procedure: Lists. (2 replies)
  231. Solved: If condition false reply by e-mail with variable hyperlink (33 replies)
  232. Solved: Transfer range from excel to access (9 replies)
  233. Built-in Help is not working (4 replies)
  234. insert value into A1 (2 replies)
  235. Solved: Delete entire row that are duplicates. (2 replies)
  236. duplicate warning code for 3 columns (7 replies)
  237. macro to open userform and close everything else (1 replies)
  238. Selecting a Random Statement (1 replies)
  239. Solved: create workbook, delete workbook (2 replies)
  240. conditional formating if Teddy I (21 replies)
  241. Array Formula (7 replies)
  242. select and delete a certain date (10 replies)
  243. Qualifying Object Reference Help (7 replies)
  244. Centering answer in Msgbox? (1 replies)
  245. [SOLVED:] Why is Next used/necessary (11 replies)
  246. Solved: Install Office 2007 (7 replies)
  247. IF statment with cell formating (6 replies)
  248. Vlookup reverse (6 replies)
  249. Solved: Locating a Knowledgebase Workbook (8 replies)
  250. Solved: need help with #value! error (6 replies)