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. Printing Comments (3 replies)
  2. Removing #na from excel cell (4 replies)
  3. Tabulation Form (4 replies)
  4. Solved: Problem With A Text Box On A Chart (5 replies)
  5. Check and Transpose (1 replies)
  6. USER FORM - lots of small problems - PLEASE HELP! (8 replies)
  7. Solved: Writing to VBE crashes Excel (2 replies)
  8. Removing Toolbar etc (24 replies)
  9. macro to print payslips (2 replies)
  10. Solved: Help AutoFilter 2 criteria at one time (3 replies)
  11. Solved: Analog Clock (3 replies)
  12. Checking Textboxes (2 replies)
  13. Solved: Formula to Script (7 replies)
  14. Getting data from diferent files in same Folder (4 replies)
  15. Help... I am so lost (3 replies)
  16. send Registry Settings with email (16 replies)
  17. copy and paste to new row (6 replies)
  18. Solved: Version Control (10 replies)
  19. Solved: Please Help - Major Problem (4 replies)
  20. Auto Filter (8 replies)
  21. Solved: Internal rate of return Function (7 replies)
  22. Solved: simple problem im sure (6 replies)
  23. Named Ranges in Excel VBA (1 replies)
  24. open worksheet (2 replies)
  25. how to define color of the cell by coding (2 replies)
  26. Sleeper: Advance Filter with command button (1 replies)
  27. Calculate doesn't seem to do anything (7 replies)
  28. Solved: Downloading XLS files from Web page (3 replies)
  29. Solved: Help with this code? (6 replies)
  30. Solved: Cut from Word and paste in Excel (3 replies)
  31. Search for the string and move the cells accordingly (2 replies)
  32. Solved: Web browser control (3 replies)
  33. Search a Userform Listbox for matching text from another Listbox (4 replies)
  34. UserForm Concept help (6 replies)
  35. Extracting max & min values with a condition (29 replies)
  36. BeforeDoubleClick Event (5 replies)
  37. Calling a UserForm when a user clicks a cell (15 replies)
  38. If Txtbox equals Chr then Show Image (14 replies)
  39. Solved: Worksheet_Calculate event (17 replies)
  40. Formula in a Control (5 replies)
  41. Header Problem with "text CC F&B" (3 replies)
  42. Solved: Thinking outside the Square (41 replies)
  43. Querying from Access (2 replies)
  44. Solved: Make list boxes visible=False (2 replies)
  45. Macro to generate documents from database (8 replies)
  46. Date Wise Max code (5 replies)
  47. Solved: Locate max number from column A (2 replies)
  48. Run time error '1004':Select method of worksheet class failed (3 replies)
  49. Copy certain range from the sheet matching conditions (2 replies)
  50. Interactive selection of worksheet and range (3 replies)
  51. Found some interesting code: (4 replies)
  52. If-Then (12 replies)
  53. "Picture too large/truncated" error? (19 replies)
  54. Solved: Set Slider to Current Year (6 replies)
  55. Copying Custom Menu to another Computer (7 replies)
  56. Simple Filter (2 replies)
  57. Solved: Save As (22 replies)
  58. Solved: Run Time error 1004 (5 replies)
  59. loop that add lines alternately (7 replies)
  60. Solved: how to empty combobox? (1 replies)
  61. Telephone Dial (4 replies)
  62. Userform, Textbox data validation (4 replies)
  63. Solved: Combining cells using a function key (3 replies)
  64. Solved: More than 2 criteria - possible?? (22 replies)
  65. Solved: Adding Txt Boxes in Form (32 replies)
  66. Userform to Macro (1 replies)
  67. Prevent two network users from opening same workbook? (12 replies)
  68. Solved: Email code crashes if workbook isn't saved (8 replies)
  69. Solved: printing a dynamic named range problem with non contiguous data? (4 replies)
  70. Solved: Trimming "Leading" spaces from cells in VBA? (8 replies)
  71. Save Workbook on Webpage (4 replies)
  72. Coding of userform (2 replies)
  73. Running a macro for any workbook/worksheet (1 replies)
  74. Solved: Versatile Form (10 replies)
  75. same code does not workon diffrent sheet with same type of data (3 replies)
  76. copy range to diffrent book (9 replies)
  77. Solved: variables in formulas (2 replies)
  78. Locking embeded word object in excel (2 replies)
  79. Solved: If value "tick mark" then ... (3 replies)
  80. Solved: Mask in form (11 replies)
  81. Solved: Shorten this VBA code (2 replies)
  82. [SOLVED:] Display Picture in frame on userform follwing hyperlink? (10 replies)
  83. Conditional Copy of Data using the macro (8 replies)
  84. Transferring to VB.net (5 replies)
  85. Excel to SQL Connection? (1 replies)
  86. Solved: Build list of sheet names and create cell validation? (3 replies)
  87. Solved: Sub Menu in My Custom Menu (7 replies)
  88. Solved: Is there any tooltiptext in excel? (14 replies)
  89. Form List Help (16 replies)
  90. Help with making code more flexible (18 replies)
  91. [SOLVED:] Only allowing values to be copied between certain dates? (6 replies)
  92. problem in a form (28 replies)
  93. Solved: ListBox Columnwith (2 replies)
  94. checkdic as dictionary (4 replies)
  95. Merged Columns (5 replies)
  96. Help Setting which workbook a Macro will run (4 replies)
  97. Procedurally generated checkbox code (3 replies)
  98. Using ActiveX Objects in Excel (2 replies)
  99. Auto_open failure (9 replies)
  100. Solved: Form Help (3 replies)
  101. Email Selection (5 replies)
  102. Connecting To A Database Without The Local Machines Odbc (2 replies)
  103. Form Help (3 replies)
  104. Updating data in summary sheet (2 replies)
  105. Advice how to edit values in non-contig. range (13 replies)
  106. Multiple users (1 replies)
  107. Solved: Selection.End Complile Error: Method or Data Member not Found (7 replies)
  108. Solved: Anybody know how to speed up subtotals? (6 replies)
  109. Solved: Next Row in Spreadsheet (9 replies)
  110. chk and paste the range (1 replies)
  111. Sleeper: Msgbox automatically clicks yes (5 replies)
  112. Truncating Array Results in a List Box (2 replies)
  113. Solved: How To Automaticly Close A Workbook If Nothing Changed In 15 Minutes? (2 replies)
  114. Solved: excel/outlook create a "line-break" (3 replies)
  115. Solved: Worksheet Protection Vs Macro (4 replies)
  116. Solved: How to Search the Latest Date in a Worksheet (3 replies)
  117. Solved: List Box question that I can't find answer to (5 replies)
  118. Solved: Sorting Multi Arrays (7 replies)
  119. Return List of Folders Containing a Specific Word (4 replies)
  120. Solved: Can a form have data referred to another sheet (2 replies)
  121. Solved: Case Select (29 replies)
  122. Solved: Vlookup formula for unique entries in lists in cells in range? (21 replies)
  123. Solved: Please help to alter some existing code (8 replies)
  124. AutoFit of Merged Cells (1 replies)
  125. VBA Help (1 replies)
  126. Solved: Textbox Format Value (10 replies)
  127. Sum using match feature with multiple criteria (1 replies)
  128. print-out time (0 replies)
  129. print colour (4 replies)
  130. Sleeper: VBA cut-and-paste code stopped working 100%? (2 replies)
  131. Solved: Formula error (2 replies)
  132. Solved: Click Cell Insert Check Mark (2 replies)
  133. Extract Access Table Names (3 replies)
  134. Hiding sheet after copy same sheet into new workbook (12 replies)
  135. Help: Seperate data and insert new rows (2 replies)
  136. Solved: Formula Results are #N/A because od no data (2 replies)
  137. Dont allow users to select same in List Boxes (7 replies)
  138. I want my macro to do the same thing in 25 folders... (1 replies)
  139. Use icon from network drive for desktop shortcut (2 replies)
  140. Issues showing userform with Excel 2000 (service pack 3) (4 replies)
  141. Solved: Copying unsorted data to a sorted order in a new sheet (4 replies)
  142. Solved: set User Names to an array (4 replies)
  143. Progress bar indicater (2 replies)
  144. When "idle" Excel workbook opens Visual Basic Editor (2 replies)
  145. Solved: HOw to make a dynamic bar diagram? (18 replies)
  146. Solved: Delete Rows based on Criteria (8 replies)
  147. Solved: Text box Date Calculation Error - Type Mismatch (9 replies)
  148. Entering a date between 2 parameters (6 replies)
  149. Solved: VLookup problem when using QueryTables.Add (2 replies)
  150. Solved: Macro to Email Excel workbook (4 replies)
  151. an empty textbox in a formula (1 replies)
  152. Advice: Extract Embed Flash file in Excel / Word (0 replies)
  153. Use cell value to search for a file & Copy/Paste? (13 replies)
  154. Solved: Combine Non-Contiguous Ranges Hide Col. (6 replies)
  155. Collecting list of Photos and hyperlinking to them? (17 replies)
  156. This code errors out (7 replies)
  157. how to autoadjust the size of a cell in a worksheet? (1 replies)
  158. Help with speeding up a macro (8 replies)
  159. VBA Help (3 replies)
  160. Solved: InStr Error when using .Comment.Text (5 replies)
  161. How to Create folder in Web/sharepoint (2 replies)
  162. delete form (5 replies)
  163. Solved: CheckBox (4 replies)
  164. Solved: Convert chart into a insert comment picture (9 replies)
  165. Solved: Allow users to set default save directory. (38 replies)
  166. Solved: Capture picture, save to folder and create hyperlink in cell? (13 replies)
  167. Solved: Vlookup + ISBLANK? (2 replies)
  168. Excel 97 & 2000 Compatibility?? (2 replies)
  169. Color picker (2 replies)
  170. switch to a .exe installer (13 replies)
  171. Solved: Formula for incrementing a number in the middle of text? (13 replies)
  172. How to modify only visible cells (5 replies)
  173. Solved: Allow user to set Percentage (1 replies)
  174. Cut & Paste Error, Excel Hang? (1 replies)
  175. Solved: Workbook links need password (2 replies)
  176. Solved: Conditional Formating by VBA creates its own condition (4 replies)
  177. Solved: Show if no setting (4 replies)
  178. help altering recorded code please (2 replies)
  179. Two Parameters in a web query (1 replies)
  180. Solved: Getting TextBox to display multiple Vlookup's on Combobox change? (2 replies)
  181. Solved: Defining a specific cell range (26 replies)
  182. Solved: how to define the cells? (2 replies)
  183. Solved: Set page as default tab (5 replies)
  184. Paste selection as Message Body (3 replies)
  185. Solved: search for first blank cell then paste clip board across sheets (22 replies)
  186. form - fullscreen (3 replies)
  187. Auto populate drop down box (6 replies)
  188. Solved: Line to close simple window (2 replies)
  189. Inserting Table into word from Excel VBA (2 replies)
  190. Solved: Show text from textbox on worksheet in textbox on userform (4 replies)
  191. Solved: Forcing Conditional Formatting to Check Cell's value (11 replies)
  192. Opening all worksheets in a workbook (1 replies)
  193. How To Filtering Datas On a ListBox By First Date and Last Date? (3 replies)
  194. Solved: Custom Format hh:mm producing odd result? (17 replies)
  195. Solved: match loop up help (4 replies)
  196. how to add a control to the aditional controls available? (15 replies)
  197. Copying down and out of memory problem (4 replies)
  198. VBA Code to read the structure & data of an excel sheet having merged rows & columns (2 replies)
  199. Help! Insert row based on row values... (1 replies)
  200. Creating Shared Workbooks destroys hyperlinks? (7 replies)
  201. Why won't this work? (4 replies)
  202. Some problems with checkbox (11 replies)
  203. How to create a summary out of 2 columns (2 replies)
  204. Solved: Pulling hair here... :D (5 replies)
  205. Solved: Issue with running Solver in VBA (1 replies)
  206. Solved: Setting using Personal workbook to store settings (48 replies)
  207. Remember Toolbar Position (10 replies)
  208. Solved: How can I enable a right click on this code? (14 replies)
  209. Transpose (3 replies)
  210. Solved: Loop help (4 replies)
  211. Solved: Modifying a User form (12 replies)
  212. Pass a variable to a built-in dialog (8 replies)
  213. Solved: Using VLOOKUP with array in different workbook and referencing the filename (2 replies)
  214. ListFillRange (0 replies)
  215. Rearrange the Worksheets of Two Workbooks (2 replies)
  216. Sum using match feature with multiple criteria (4 replies)
  217. Dynamic pivot data (5 replies)
  218. Solved: Using all Spreadsheets in a folder to create table (6 replies)
  219. [[URGENT]] VBA help with the Taylor Series on Trigonometry (4 replies)
  220. Solved: Application.FileSearch Excel 2003 (4 replies)
  221. Help writing loop (5 replies)
  222. Solved: How to create a drop down list? (3 replies)
  223. Solved: Theory/Explanation/Benefits; Filldown vs. Copy (4 replies)
  224. Solved: SaveAs Macro Code (3 replies)
  225. [SOLVED:] How To Work With Boolean Values (3 replies)
  226. problem with Textalign (3 replies)
  227. Solved: With End With Copy PasteSpecial Help (5 replies)
  228. Solved: a VBA code example for Right Click Menu On a ListBox (11 replies)
  229. copy current sheet (2 replies)
  230. right click (6 replies)
  231. force a workbook save (5 replies)
  232. CM (1 replies)
  233. select case (13 replies)
  234. Sleeper: Recover information (3 replies)
  235. Macro In .xlt File Won't Work In .xls File? (6 replies)
  236. Why won't this (simple) VBA work?? (1 replies)
  237. weekly count (0 replies)
  238. do i need vba to do this? (regarding dynamic range) (1 replies)
  239. if file size larger than X KB, run zip/mail vba .... how? (1 replies)
  240. Solved: test for Add-Ins, prompt to activate if not (3 replies)
  241. Solved: Debugger anomaly (10 replies)
  242. Custom Views/Hidden Row VBA Solution? (5 replies)
  243. User Form Won't show (2 replies)
  244. Solved: This works horzintally but not vertically? (2 replies)
  245. Auto start macro problem (2 replies)
  246. Solved: Create User Defined Text File (2 replies)
  247. VBA to minimize file size? (3 replies)
  248. Solved: Why does one work but not the other? (14 replies)
  249. Combining Code Part Deux (4 replies)
  250. Solved: Input Box help (9 replies)