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. View Excel Charts from Forms (1 replies)
  2. Solved: Problem with Typename for Multipage/Page in recursive function (2 replies)
  3. Copy Extenal workbook help (6 replies)
  4. excel data manipulation and sorting (7 replies)
  5. Listbox Additem + ListFillRange (9 replies)
  6. Solved: CustomList Index (2 replies)
  7. Solved: Allowing macro beetwen 4 - 5 PM (17 replies)
  8. Task Scheduler via COM (2 replies)
  9. For Each loop: exits too early (7 replies)
  10. copy and paste active cell down a column (25 replies)
  11. multiple e-mail addresses in SendTo,Notes client (3 replies)
  12. What routine to use? (9 replies)
  13. Solved: looping backwards using steps (1 replies)
  14. copy range from different sheets (3 replies)
  15. Solved: Toggling Display gridlines: (8 replies)
  16. Solved: Help with calling out another sub within a sub (1 replies)
  17. Solved: sheet history before save (3 replies)
  18. problem with preventing "" spreading all over the Spreadsheet (3 replies)
  19. Stop / Pause a Macro using Pause button (4 replies)
  20. Solved: Problem with my delete loop (7 replies)
  21. Solved: Make textbox visable or not visable on Userform (3 replies)
  22. Solved: Transpose Horiz Values to Vertical (1 replies)
  23. code help (newbie) (12 replies)
  24. Passing Objects: ByRef / ByVal (2 replies)
  25. Breaking numbers and letters (9 replies)
  26. Solved: Create Multiple Text Files From Cells & Save As Name In Adjacent Cell (7 replies)
  27. Solved: Assigning a date variable for use in a file extension (8 replies)
  28. User Form Help (2 replies)
  29. Assistance with formula arrangement (1 replies)
  30. Solved: linking text data between sheets (4 replies)
  31. UserForm control for a background process (0 replies)
  32. Solved: VBA for sorting column with formulas (3 replies)
  33. Solved: Format trend line dialog box (3 replies)
  34. Solved: [Excel] Open files listed in varialble, extract data (1 replies)
  35. Solved: Need help creating macro to insert col (3 replies)
  36. 1024 character limit help (4 replies)
  37. Loop to extract data (3 replies)
  38. Form TxtBox (6 replies)
  39. test if Excel 2007 is in Compatibility Mode (0 replies)
  40. Solved: Finding Information in one spreadsheet to populate another spreadsheet (4 replies)
  41. Solved: Help speed up this code (2 FOR loops seem to be the problem) (6 replies)
  42. selecting last row / cell (9 replies)
  43. formatting vba to work on a protected sheet. (5 replies)
  44. Using another source (2 replies)
  45. Solved: subtract two formula (2 replies)
  46. Solved: List File Names (12 replies)
  47. understanding arrays (5 replies)
  48. txtboxes and cells. Updating editing userform (5 replies)
  49. Solved: change formula (11 replies)
  50. conditional formula (10 replies)
  51. monte carlo output: statistics in Excel (How?) (4 replies)
  52. Solved: 2 formulas required - Part 2 (7 replies)
  53. Solved: 2 formulas required - Part 1 (6 replies)
  54. Solved: Treeview nodes (7 replies)
  55. Benefit of making sheet object rather than directly manipulating sheet (2 replies)
  56. Solved: Find/Replace in One Column over Entire Workbook (13 replies)
  57. Copy or link data between sheets (8 replies)
  58. Activate range on a different sheet (10 replies)
  59. Solved: Select item in list if only one exists (2 replies)
  60. Solved: incorporating condition or math into sumproduct (2 replies)
  61. Solved: problem with a conditional average (23 replies)
  62. Solved: Automate msgbox cancel (4 replies)
  63. Solved: Macro to warning user of duplicate entry (4 replies)
  64. CODE CANT BE WORK (9 replies)
  65. Excel VBA Copy & Paste (7 replies)
  66. Number format to dispaly on a label from text box (3 replies)
  67. CommandButton &i.Elabled = False (2 replies)
  68. Transposition and rearrangement of data using VBA (2 replies)
  69. Want a Userform (4 replies)
  70. Solved: Userform and data validation (12 replies)
  71. Solved: What's wrong with this function? (6 replies)
  72. Rolling Reference number (11 replies)
  73. [SOLVED:] Worksheet activate code in Add-in (3 replies)
  74. Excel macros (if statements etc) how? (4 replies)
  75. Search certain column in all worksheets and paste rows to seperate worksheet. (2 replies)
  76. Treeview Losing Checked Checkboxes (2 replies)
  77. Date Stamping a Cell Modification (6 replies)
  78. Check or selected rows in array? (8 replies)
  79. refreshing data in excel (1 replies)
  80. Trim not working and moving through a range (1 replies)
  81. Solved: Best way to select these ranges w/ macro? (5 replies)
  82. Sleeper: Date Dif function (4 replies)
  83. A complex IF formula (5 replies)
  84. Solved: Delete function failing (10 replies)
  85. Connections in MS Excel 2007 (0 replies)
  86. Getting around Pivot Table 256 Col Limitation (4 replies)
  87. MACRO/VBA help!!! :S new line... etc (5 replies)
  88. Date Format (4 replies)
  89. Solved: Hours to be worked by Month (14 replies)
  90. Solved: Stop Them Deleting Rows (2 replies)
  91. worksheet is not picked up in Vba (4 replies)
  92. Macro Security (17 replies)
  93. Extracting certain data to another sheet (1 replies)
  94. loop + offset/resize problem (4 replies)
  95. From one sheet to another... (5 replies)
  96. [SOLVED:] Special Transpose (2 replies)
  97. Solved: make a dynamic if statment? (4 replies)
  98. Alternative to Eomonth formulae question (3 replies)
  99. Solved: Fast Compare using Filter (6 replies)
  100. copy range, skip empty cells (6 replies)
  101. Solved: problem of structure (4 replies)
  102. Solved: Userform buttons to enter numbers into textbox (7 replies)
  103. Solved: problems saveing two copies. (2 replies)
  104. Solved: From one array to another (3 replies)
  105. Solved: any value in a range = 0 then return 0 ? (3 replies)
  106. Solved: Sum and compile list of entries (4 replies)
  107. Solved: using a worksheet function in vba (2 replies)
  108. [SOLVED:] Easy! How to make a button that generates a random number? (6 replies)
  109. Solved: case yes-no, can the code be smaler? (5 replies)
  110. Solved: alpha-numeric 2 (3 replies)
  111. Split string into multiple parts no bigger than 240 chars? (9 replies)
  112. Solved: Create a worksheet for each value in Column A (6 replies)
  113. [SOLVED:] Variable Columns Lengths (3 replies)
  114. problem using a function from an external library in vba (3 replies)
  115. Excel Macro Help Please (1 replies)
  116. Execel, OLEObjects (buttons) sometimes not firing, triggering (5 replies)
  117. C&P all data of all the sheets/workbooks in a folder. (4 replies)
  118. If no dependents msgbox and resume loop (14 replies)
  119. [Help Please]Parsing parameters to event (2 replies)
  120. Help! I'm working with two spread sheets (1 replies)
  121. Combobox Visibility After Drop List Selection (5 replies)
  122. Formatting entire row based on text in first column (1 replies)
  123. Solved: Problem auto-installing VBA add-in (10 replies)
  124. How to find the last duplicate value (6 replies)
  125. Pass a named range into function issue (5 replies)
  126. Listview help (0 replies)
  127. Summing a column based on two criteria in other columns (11 replies)
  128. Random number generation (6 replies)
  129. Solved: move up (9 replies)
  130. [SOLVED:] Clipboard is full (1 replies)
  131. Controlling Internet Explorer's "Print pop-up" (4 replies)
  132. Check if a file on the web exists (0 replies)
  133. VBA for time display (7 replies)
  134. Solved: Saving As Text adds double quotes to some lines! (1 replies)
  135. rectangle question (0 replies)
  136. Excel Right Click Menu Always Up (13 replies)
  137. Group 2 cells like in a userform. (7 replies)
  138. Count coloured cells and display result in table. (3 replies)
  139. [SOLVED:] Add Border if Statement (4 replies)
  140. Getting Data from an Excel Spreadsheet object to a normal excel spreadsheet (3 replies)
  141. Solved: Feeling dumb today!!! (13 replies)
  142. CommendBox (18 replies)
  143. Solved: Loop through one column on any sheet in workbook.... (5 replies)
  144. Solved: Code change to allow for Data table changes (14 replies)
  145. How to delete a row if it contains a word? (11 replies)
  146. Command Button to save, print and clear (8 replies)
  147. Using a combo box to select a named worksheet (3 replies)
  148. Solved: Combining macros (12 replies)
  149. When looping through sheets remove subtotals only works on first (6 replies)
  150. [SOLVED:] How do you return / pass values? (7 replies)
  151. Solved: Notification when macro is executed (1 replies)
  152. Notification when macro is executed (4 replies)
  153. Subtotals using Macro ... (2 replies)
  154. Solved: Green if zero, Red if not (10 replies)
  155. New Excel Application (7 replies)
  156. Solved: Partial String ListBox search to populate another ListBox (3 replies)
  157. Copy and paste data after printing (1 replies)
  158. [SOLVED:] Move sheets to new book (array) (3 replies)
  159. collection issue with custom type variable (9 replies)
  160. Split text between cells Help Needed (0 replies)
  161. Sub or Function for IF ... (0 replies)
  162. Solved: Passing variables through properties (4 replies)
  163. Sort, Page Break and Page Header according to cell values in different worksheet (9 replies)
  164. Custom Sort (6 replies)
  165. Duplicate Master freeware utility? (3 replies)
  166. Simplify Code (3 replies)
  167. Solved: Remove ' from text (5 replies)
  168. Solved: Save in both Excel 2003 and 2007 (9 replies)
  169. Runtime error in macro (3 replies)
  170. Solved: Jump to last worksheet (10 replies)
  171. conditional adding through sheets in a loop. Novice. (3 replies)
  172. Multiple Charts To Multiple Slides (4 replies)
  173. Find and Replace Page Down in excel (3 replies)
  174. Solved: How can I create linked Vlookup data from multiple closed workbooks (10 replies)
  175. Solved: Restrict Menus & Right Click Menus & short keys (4 replies)
  176. Solved: Loop through sheets (1 replies)
  177. Solved: Edit code to change cell value (6 replies)
  178. Solved: find duplicate entries in colunms (2 replies)
  179. When using a combo bow to select a row (9 replies)
  180. Solved: Save button (2 replies)
  181. Solved: What can i do when it says not a legal object name.. and then wont let me do anythin? (2 replies)
  182. Solved: How can i?? Press a button and it will make a calculation of +30days! (4 replies)
  183. Solved: Save button (3 replies)
  184. UDT Question (4 replies)
  185. Placing in the same row as a spefic customer (1 replies)
  186. Place in first empty textbox????????? (0 replies)
  187. Code to allow A Customers ID to only go in a spread up to 3 times? (1 replies)
  188. Formula Error (3 replies)
  189. Sleeper: Linking worksheet together (0 replies)
  190. Solved: Removing numbers from a text block (2 replies)
  191. Solved: copy sheet and change formula reference (9 replies)
  192. Solved: Macro Problem - Hanging (8 replies)
  193. VBA Question - How to find the contents of one cell in another worksheet? (3 replies)
  194. [SOLVED:] Loop for Value True/ Copy 4 cells to other sheet (26 replies)
  195. [SOLVED:] Message Box Input calls Tab Name (7 replies)
  196. Print when Command button is pushed (4 replies)
  197. How to give a dataset corresponding ranges? (0 replies)
  198. Help using Excel as a database (10 replies)
  199. Font color (13 replies)
  200. highlight cells between two dates in cluding the cells with the dates (3 replies)
  201. Select check box on web page (5 replies)
  202. Run macro automatically when a cell value changes (8 replies)
  203. Number format Question? (4 replies)
  204. How to delete all rows that don't have a specific name - e.g. "XYZ" (8 replies)
  205. [SOLVED:] Insert column (2 replies)
  206. Excel Signing Invalid because of XLA location change (2 replies)
  207. Insert today's date, save file and close (2 replies)
  208. [SOLVED:] Alter Code To Allow Spread Sheet To Close (4 replies)
  209. IF STATEMENT TO extract result (8 replies)
  210. Advancedfilter Delete Row(s) (5 replies)
  211. Solved: Copy row of sheet2 (if data does not match sheet1). (3 replies)
  212. Solved: Copy range from one sheet to another (8 replies)
  213. Solved: adding locked cells via macro (16 replies)
  214. greatest date and time (6 replies)
  215. Pivot Page fields to new sheets (0 replies)
  216. Copy data from Multiple to SINGLE worksheet. (20 replies)
  217. Solved: Custom Formats (8 replies)
  218. Solved: Followhyperlink code (2 replies)
  219. VB code (2 replies)
  220. Last Duplicate Value in Column (7 replies)
  221. [SLEEPER:] Create request (1 replies)
  222. How to compare the difference between 2 excel files (2 replies)
  223. How to enter date into pop up, which enters into spreadsheet (5 replies)
  224. Solved: variable not defined in (5 replies)
  225. Solved: Vlookup from data in unopened file? (25 replies)
  226. Solved: Available Resources issue (4 replies)
  227. Edit a cell depending on previous choice. (12 replies)
  228. [SOLVED:] Help with Replace Function (2 replies)
  229. Combine2 Name Colums to Create emails (2 replies)
  230. Set SummaryRow format (0 replies)
  231. Solved: Save as Filename with a variable text (1 replies)
  232. Copy variable range and copy to another sheet (9 replies)
  233. Error's want to help (9 replies)
  234. Solved: It's late, please help simplify this formula (3 replies)
  235. Solved: Change PivotTable Data Field in VBA (2 replies)
  236. Solved: Hide Row Based On First Few Letters (8 replies)
  237. Solved: Leave TextBoxes Blank (3 replies)
  238. Copy data from web (1 replies)
  239. Solved: Populate Listbox with Mulitple Columns (4 replies)
  240. Double Entries (4 replies)
  241. Processing XSD schemas using VBA (3 replies)
  242. Solved: Very Custom Program (6 replies)
  243. SUM/COUNT CELLS BY FILL COLOUR (11 replies)
  244. Solved: sum values based upon 2 conditions (14 replies)
  245. excel spreadsheet to .EXE (1 replies)
  246. Solved: 2 dimensional dictionary object (7 replies)
  247. Hide value in Listbox if 2nd Column = 0 (1 replies)
  248. setting a workbook as a constant (3 replies)
  249. Count non-hidden cells in a pivot table (4 replies)
  250. Solved: Save As an Excel using VB (4 replies)