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: Sub Menu in My Custom Menu (7 replies)
  2. Solved: Is there any tooltiptext in excel? (14 replies)
  3. Form List Help (16 replies)
  4. Help with making code more flexible (18 replies)
  5. [SOLVED:] Only allowing values to be copied between certain dates? (6 replies)
  6. problem in a form (28 replies)
  7. Solved: ListBox Columnwith (2 replies)
  8. checkdic as dictionary (4 replies)
  9. Merged Columns (5 replies)
  10. Help Setting which workbook a Macro will run (4 replies)
  11. Procedurally generated checkbox code (3 replies)
  12. Using ActiveX Objects in Excel (2 replies)
  13. Auto_open failure (9 replies)
  14. Solved: Form Help (3 replies)
  15. Email Selection (5 replies)
  16. Connecting To A Database Without The Local Machines Odbc (2 replies)
  17. Form Help (3 replies)
  18. Updating data in summary sheet (2 replies)
  19. Advice how to edit values in non-contig. range (13 replies)
  20. Multiple users (1 replies)
  21. Solved: Selection.End Complile Error: Method or Data Member not Found (7 replies)
  22. Solved: Anybody know how to speed up subtotals? (6 replies)
  23. Solved: Next Row in Spreadsheet (9 replies)
  24. chk and paste the range (1 replies)
  25. Sleeper: Msgbox automatically clicks yes (5 replies)
  26. Truncating Array Results in a List Box (2 replies)
  27. Solved: How To Automaticly Close A Workbook If Nothing Changed In 15 Minutes? (2 replies)
  28. Solved: excel/outlook create a "line-break" (3 replies)
  29. Solved: Worksheet Protection Vs Macro (4 replies)
  30. Solved: How to Search the Latest Date in a Worksheet (3 replies)
  31. Solved: List Box question that I can't find answer to (5 replies)
  32. Solved: Sorting Multi Arrays (7 replies)
  33. Return List of Folders Containing a Specific Word (4 replies)
  34. Solved: Can a form have data referred to another sheet (2 replies)
  35. Solved: Case Select (29 replies)
  36. Solved: Vlookup formula for unique entries in lists in cells in range? (21 replies)
  37. Solved: Please help to alter some existing code (8 replies)
  38. AutoFit of Merged Cells (1 replies)
  39. VBA Help (1 replies)
  40. Solved: Textbox Format Value (10 replies)
  41. Sum using match feature with multiple criteria (1 replies)
  42. print-out time (0 replies)
  43. print colour (4 replies)
  44. Sleeper: VBA cut-and-paste code stopped working 100%? (2 replies)
  45. Solved: Formula error (2 replies)
  46. Solved: Click Cell Insert Check Mark (2 replies)
  47. Extract Access Table Names (3 replies)
  48. Hiding sheet after copy same sheet into new workbook (12 replies)
  49. Help: Seperate data and insert new rows (2 replies)
  50. Solved: Formula Results are #N/A because od no data (2 replies)
  51. Dont allow users to select same in List Boxes (7 replies)
  52. I want my macro to do the same thing in 25 folders... (1 replies)
  53. Use icon from network drive for desktop shortcut (2 replies)
  54. Issues showing userform with Excel 2000 (service pack 3) (4 replies)
  55. Solved: Copying unsorted data to a sorted order in a new sheet (4 replies)
  56. Solved: set User Names to an array (4 replies)
  57. Progress bar indicater (2 replies)
  58. When "idle" Excel workbook opens Visual Basic Editor (2 replies)
  59. Solved: HOw to make a dynamic bar diagram? (18 replies)
  60. Solved: Delete Rows based on Criteria (8 replies)
  61. Solved: Text box Date Calculation Error - Type Mismatch (9 replies)
  62. Entering a date between 2 parameters (6 replies)
  63. Solved: VLookup problem when using QueryTables.Add (2 replies)
  64. Solved: Macro to Email Excel workbook (4 replies)
  65. an empty textbox in a formula (1 replies)
  66. Advice: Extract Embed Flash file in Excel / Word (0 replies)
  67. Use cell value to search for a file & Copy/Paste? (13 replies)
  68. Solved: Combine Non-Contiguous Ranges Hide Col. (6 replies)
  69. Collecting list of Photos and hyperlinking to them? (17 replies)
  70. This code errors out (7 replies)
  71. how to autoadjust the size of a cell in a worksheet? (1 replies)
  72. Help with speeding up a macro (8 replies)
  73. VBA Help (3 replies)
  74. Solved: InStr Error when using .Comment.Text (5 replies)
  75. How to Create folder in Web/sharepoint (2 replies)
  76. delete form (5 replies)
  77. Solved: CheckBox (4 replies)
  78. Solved: Convert chart into a insert comment picture (9 replies)
  79. Solved: Allow users to set default save directory. (38 replies)
  80. Solved: Capture picture, save to folder and create hyperlink in cell? (13 replies)
  81. Solved: Vlookup + ISBLANK? (2 replies)
  82. Excel 97 & 2000 Compatibility?? (2 replies)
  83. Color picker (2 replies)
  84. switch to a .exe installer (13 replies)
  85. Solved: Formula for incrementing a number in the middle of text? (13 replies)
  86. [SLEEPER:] How to modify only visible cells (5 replies)
  87. Solved: Allow user to set Percentage (1 replies)
  88. Cut & Paste Error, Excel Hang? (1 replies)
  89. Solved: Workbook links need password (2 replies)
  90. Solved: Conditional Formating by VBA creates its own condition (4 replies)
  91. Solved: Show if no setting (4 replies)
  92. help altering recorded code please (2 replies)
  93. Two Parameters in a web query (1 replies)
  94. Solved: Getting TextBox to display multiple Vlookup's on Combobox change? (2 replies)
  95. Solved: Defining a specific cell range (26 replies)
  96. Solved: how to define the cells? (2 replies)
  97. Solved: Set page as default tab (5 replies)
  98. Paste selection as Message Body (3 replies)
  99. Solved: search for first blank cell then paste clip board across sheets (22 replies)
  100. form - fullscreen (3 replies)
  101. Auto populate drop down box (6 replies)
  102. Solved: Line to close simple window (2 replies)
  103. [SLEEPER:] Inserting Table into word from Excel VBA (2 replies)
  104. Solved: Show text from textbox on worksheet in textbox on userform (4 replies)
  105. Solved: Forcing Conditional Formatting to Check Cell's value (11 replies)
  106. Opening all worksheets in a workbook (1 replies)
  107. How To Filtering Datas On a ListBox By First Date and Last Date? (3 replies)
  108. Solved: Custom Format hh:mm producing odd result? (17 replies)
  109. Solved: match loop up help (4 replies)
  110. how to add a control to the aditional controls available? (15 replies)
  111. Copying down and out of memory problem (4 replies)
  112. VBA Code to read the structure & data of an excel sheet having merged rows & columns (2 replies)
  113. Help! Insert row based on row values... (1 replies)
  114. Creating Shared Workbooks destroys hyperlinks? (7 replies)
  115. Why won't this work? (4 replies)
  116. Some problems with checkbox (11 replies)
  117. How to create a summary out of 2 columns (2 replies)
  118. Solved: Pulling hair here... :D (5 replies)
  119. Solved: Issue with running Solver in VBA (1 replies)
  120. Solved: Setting using Personal workbook to store settings (48 replies)
  121. Remember Toolbar Position (10 replies)
  122. Solved: How can I enable a right click on this code? (14 replies)
  123. Transpose (3 replies)
  124. Solved: Loop help (4 replies)
  125. Solved: Modifying a User form (12 replies)
  126. Pass a variable to a built-in dialog (8 replies)
  127. [SOLVED:] Using VLOOKUP with array in different workbook and referencing the filename (2 replies)
  128. ListFillRange (0 replies)
  129. Rearrange the Worksheets of Two Workbooks (2 replies)
  130. Sum using match feature with multiple criteria (4 replies)
  131. Dynamic pivot data (5 replies)
  132. Solved: Using all Spreadsheets in a folder to create table (6 replies)
  133. [[URGENT]] VBA help with the Taylor Series on Trigonometry (4 replies)
  134. Solved: Application.FileSearch Excel 2003 (4 replies)
  135. Help writing loop (5 replies)
  136. Solved: How to create a drop down list? (3 replies)
  137. Solved: Theory/Explanation/Benefits; Filldown vs. Copy (4 replies)
  138. Solved: SaveAs Macro Code (3 replies)
  139. [SOLVED:] How To Work With Boolean Values (3 replies)
  140. problem with Textalign (3 replies)
  141. Solved: With End With Copy PasteSpecial Help (5 replies)
  142. Solved: a VBA code example for Right Click Menu On a ListBox (11 replies)
  143. copy current sheet (2 replies)
  144. right click (6 replies)
  145. force a workbook save (5 replies)
  146. CM (1 replies)
  147. select case (13 replies)
  148. Sleeper: Recover information (3 replies)
  149. Macro In .xlt File Won't Work In .xls File? (6 replies)
  150. Why won't this (simple) VBA work?? (1 replies)
  151. weekly count (0 replies)
  152. do i need vba to do this? (regarding dynamic range) (1 replies)
  153. if file size larger than X KB, run zip/mail vba .... how? (1 replies)
  154. Solved: test for Add-Ins, prompt to activate if not (3 replies)
  155. Solved: Debugger anomaly (10 replies)
  156. Custom Views/Hidden Row VBA Solution? (5 replies)
  157. User Form Won't show (2 replies)
  158. Solved: This works horzintally but not vertically? (2 replies)
  159. Auto start macro problem (2 replies)
  160. Solved: Create User Defined Text File (2 replies)
  161. VBA to minimize file size? (3 replies)
  162. Solved: Why does one work but not the other? (14 replies)
  163. Combining Code Part Deux (4 replies)
  164. Solved: Input Box help (9 replies)
  165. Data Form in Excel (3 replies)
  166. Solved: Function - Lookup sub for file path (2 replies)
  167. Solved: Table customisation thru Pivot Table (5 replies)
  168. Solved: #NA problem (10 replies)
  169. Solved: Format problem (5 replies)
  170. double click (9 replies)
  171. Solved: A function that pulls earliest date based on multiple criteria (3 replies)
  172. why can i see it and other can't? (3 replies)
  173. Can you tell me why it sends two emails? (6 replies)
  174. Userform checkbox captions to a cell (1 replies)
  175. Search and Replace Special (12 replies)
  176. Changing Date Format in an array (1 replies)
  177. Combining code to make smaller (12 replies)
  178. Formulas that do not run (4 replies)
  179. Solved: how to check duplication of columns? (4 replies)
  180. Solved: Sum of columns (7 replies)
  181. textbox events? (14 replies)
  182. Solved: Chart Formatting (1 replies)
  183. Solved: POP UP MESSAGE (11 replies)
  184. Solved: Formulas, entered by macro (8 replies)
  185. Hiding blank rows below Pivot Table (27 replies)
  186. Solved: Gather tab names from workbook (9 replies)
  187. Cell format (5 replies)
  188. Solved: Copy paste special (2 replies)
  189. Solved: Excel VBA Email to more than one recipient (6 replies)
  190. Convert Excel Workbooks into Text files, Compare them & store result back ito Excel (6 replies)
  191. Solved: Dropdown list problem (4 replies)
  192. Is this code correct? (8 replies)
  193. Using 'Ontime' (4 replies)
  194. Importing a Text File (6 replies)
  195. Solved: Track File Usage (13 replies)
  196. Solved: Simple formula not working (13 replies)
  197. recopy value in column without dupes (1 replies)
  198. Classes, Instance, What is this all about? (14 replies)
  199. excel and sharepoint 2007 (1 replies)
  200. Solved: Deleting file at end of code (6 replies)
  201. Only locking particular cells without protecting the whole sheet? (13 replies)
  202. [SOLVED:] Hiding Command Toolbars (2 replies)
  203. Solved: protect formulas (6 replies)
  204. How to protect the macro code? (1 replies)
  205. Run Time errror 1004 (3 replies)
  206. Solved: Multi stage sorting and subtotaling of Excel Data Base (5 replies)
  207. Sheet selection + Shortcuts (4 replies)
  208. populate data based on a list (5 replies)
  209. Send as Attachment - Change coding from Excel 2003 to Excel 97 (7 replies)
  210. Solved: Determine is Sheet exists based on list (4 replies)
  211. Solved: Goto a worksheet selected by the user (2 replies)
  212. Solved: Code works on step through, but skips when run... (13 replies)
  213. Handling Array Error (6 replies)
  214. Solved: Cell reference in global declaration (4 replies)
  215. Select Row Copy anomaly (10 replies)
  216. Column Exists (1 replies)
  217. Copy values from one sheet to another (7 replies)
  218. Sheet Protection - Which has precedence? (4 replies)
  219. combining two Worksheet_SelectionChange(ByVal Target As Excel.Range) correctly (3 replies)
  220. Solved: Debug.Print (5 replies)
  221. Solved: Cell formatting (5 replies)
  222. Solved: Dealing with multiple columns with variables (2 replies)
  223. Deleting a formula from a cell once the result is given (11 replies)
  224. Assist in creating loop w/ multi-variables (14 replies)
  225. run macro for an entire folder contents (2 replies)
  226. Solved: WB + WS vba headache (8 replies)
  227. Macros do not work (1 replies)
  228. Solved: Test if Autofilter is on (2 replies)
  229. [SOLVED:] Create Image of selected cells and save outside of Excel (5 replies)
  230. Solved: create new workbook B from subtotals in workbook A (4 replies)
  231. Solved: reducing size of Excel files (4 replies)
  232. Solved: Tabbing Issue (9 replies)
  233. Solved: calling a sub in another add-in (7 replies)
  234. Solved: Forming a variable name (4 replies)
  235. Solved: Code help (3 replies)
  236. Formatting text in a formula (4 replies)
  237. how to write if a=b in VBA? (2 replies)
  238. Solved: Whole row becomes shaded / highlighted when selected (3 replies)
  239. Web Query Questions (1 replies)
  240. transfer of data from userform to sheet (29 replies)
  241. Whole row of active cell should be bold (14 replies)
  242. Sorting Columns (4 replies)
  243. Web Query -- URL Dynamically post (1 replies)
  244. Solved: Populate boxes on form with value from 1 cell (2 replies)
  245. Variables and Chart Series (2 replies)
  246. "Reset" Lastcell (8 replies)
  247. switch cells (10 replies)
  248. Solved: SETTING USER TO CLOSE WORKBOOK IN A BUTTON NOT IN WINDOW (23 replies)
  249. Cut and Paste Problem (2 replies)
  250. Input data into web form write to Excel (10 replies)