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. Conditional formatting in vba (more than three) select values from a worksheet (2 replies)
  2. Solved: macro to list unique data in a column (2 replies)
  3. Help with Macro code (8 replies)
  4. Solved: Opening unknown File names in known Folder (4 replies)
  5. Solved: problem with resize and autofill (2 replies)
  6. User Def Function to only act on active workbook (3 replies)
  7. Code using date not saving the result of output (14 replies)
  8. [SOLVED:] Creating Pareto Chart (20 replies)
  9. [SOLVED:] Quick question about loops (3 replies)
  10. Caopying and Pasting While Retaining the Original Cell Reference (5 replies)
  11. Solved: Word bookmark Help (8 replies)
  12. FileCopy to Network Drive (13 replies)
  13. CSV Import Issues (3 replies)
  14. Paste Copy special Value (5 replies)
  15. Solved: Automatically change font size (2 replies)
  16. Solved: Accounting format (2 replies)
  17. Userform will not Show after being Hidden (3 replies)
  18. Solved: Create New Sheet Based on Value In Column (7 replies)
  19. Copy, Find and add offset cell values (0 replies)
  20. Trim cells in variable range (1 replies)
  21. Getting a range to work in my vba code (4 replies)
  22. Solved: If value not found go to next cell (5 replies)
  23. Solved: Label blinking in the UserForm (1 replies)
  24. How to create a message box depending on values of the cell? Toughie =/ (10 replies)
  25. Solved: Userform Quick Q (2 replies)
  26. Tracking Changes / Sharing a workbook (6 replies)
  27. Looping through Range Vs Ranges (15 replies)
  28. Extract data from columns [sum] (1 replies)
  29. Solved: Renaming folder files (2 replies)
  30. Solved: Find unique values (3 replies)
  31. Solved: NETWORKDAYS formula amendment (8 replies)
  32. Form, listbox and multilines problem (1 replies)
  33. Solved: Changing TreeView Node Detail with Userform TextBox (2 replies)
  34. Solved: Adding rows with preconditioned cells (9 replies)
  35. Solved: How to re-apply named ranges (24 replies)
  36. Solved: Re: Shared Workbooks (2 replies)
  37. Command button to Hide/Unhide tabs (4 replies)
  38. Navigation menu to only show visible tabs (4 replies)
  39. Solved: Populate list box from selection in another. (2 replies)
  40. Generate random numbers based on odds (1 replies)
  41. Solved: Spell Check Unlocked Cells on Protected Sheet (1 replies)
  42. Solved: data going to wrong cell (4 replies)
  43. Solved: Formula help (2 replies)
  44. Function returning Arrays (3 replies)
  45. Difficult: Sum of days in consecutive months based on multiple criteria (7 replies)
  46. Which control does this? (2 replies)
  47. Quicker way to write a bunch of formulas?? (1 replies)
  48. Solved: Help with Experimental Grade Sheet (9 replies)
  49. Seperating records with a blank line (3 replies)
  50. Manipulating Arrays Using VBA (2 replies)
  51. For Each.. loop decisions (3 replies)
  52. Solved: Copy from one xls to other avoiding highlighted cells (6 replies)
  53. Amend VBA Code (2 replies)
  54. combo box help (1 replies)
  55. Excel in neverending loop (2 replies)
  56. Copy and paste withi selected range (12 replies)
  57. Solved: Importing multiple space delimited text file (6 replies)
  58. arranging data redux (4 replies)
  59. saving a backup file (2 replies)
  60. Split Cells help (9 replies)
  61. Solved: "Pick and choose" series to display on embedded chart (5 replies)
  62. Complie if error (5 replies)
  63. looping code with if's (0 replies)
  64. Solved: Camera tool use with picture object (6 replies)
  65. Solved: modifying existing chart Sourch data (5 replies)
  66. Creating a User controlled pause in VBA (2 replies)
  67. Downloading many html web pages, converting to text, then parsing out (5 replies)
  68. Ref Edit Control Missing (1 replies)
  69. EXCEL USING IF THEN STATEMENT (3 replies)
  70. Listbox Limit!! (4 replies)
  71. Move over Picture (1 replies)
  72. Using VBA for conditional Formatting (2 replies)
  73. Solved: save and rename workbook everyday at a given time (1 replies)
  74. Solved: How to check the type of an array (2 replies)
  75. question about forcemacros (1 replies)
  76. Linked Picture to be centred on Screen (8 replies)
  77. change part of a string (1 replies)
  78. Prevent 1004 Error For Select Method (11 replies)
  79. Using Formula To Find Last Used Column? (9 replies)
  80. lookup and conditional formatting with VBA (17 replies)
  81. TextBox Help (1 replies)
  82. Access Filter Criteria from Excel (0 replies)
  83. Solved: help optimizing case select (4 replies)
  84. Solved: userform and function call (3 replies)
  85. Solved: Generate numbers 1 - 90 for bingo (10 replies)
  86. Writing Excel cells with VBA variables (13 replies)
  87. Solved: Show current users on userform (2 replies)
  88. vb and command button help (3 replies)
  89. storing value, making registration tool (4 replies)
  90. [SOLVED:] Application.match failing (4 replies)
  91. Solved: add data based upon created categories (10 replies)
  92. progress bar is frozen (9 replies)
  93. Function returns empty array (9 replies)
  94. Sorting a Range with VBA (13 replies)
  95. Import Txt and Parse (3 replies)
  96. Creating a "refresh data" macro (3 replies)
  97. Solved: Excel - Opening files in string or in cell (10 replies)
  98. Page Header: Loop based on values in a range (5 replies)
  99. Runtime Error 1004 - ODBC ERROR - BackgroundQuery (0 replies)
  100. Worksheet Cell Calculation Order (1 replies)
  101. Maybe a Null question? (4 replies)
  102. Need Help with the Easist Question Ever (4 replies)
  103. View Excel Charts from Forms (1 replies)
  104. Solved: Problem with Typename for Multipage/Page in recursive function (2 replies)
  105. Copy Extenal workbook help (6 replies)
  106. excel data manipulation and sorting (7 replies)
  107. Listbox Additem + ListFillRange (9 replies)
  108. Solved: CustomList Index (2 replies)
  109. Solved: Allowing macro beetwen 4 - 5 PM (17 replies)
  110. Task Scheduler via COM (2 replies)
  111. For Each loop: exits too early (7 replies)
  112. copy and paste active cell down a column (25 replies)
  113. multiple e-mail addresses in SendTo,Notes client (3 replies)
  114. What routine to use? (9 replies)
  115. Solved: looping backwards using steps (1 replies)
  116. copy range from different sheets (3 replies)
  117. Solved: Toggling Display gridlines: (8 replies)
  118. Solved: Help with calling out another sub within a sub (1 replies)
  119. Solved: sheet history before save (3 replies)
  120. problem with preventing "" spreading all over the Spreadsheet (3 replies)
  121. Stop / Pause a Macro using Pause button (4 replies)
  122. Solved: Problem with my delete loop (7 replies)
  123. Solved: Make textbox visable or not visable on Userform (3 replies)
  124. Solved: Transpose Horiz Values to Vertical (1 replies)
  125. code help (newbie) (12 replies)
  126. Passing Objects: ByRef / ByVal (2 replies)
  127. Breaking numbers and letters (9 replies)
  128. Solved: Create Multiple Text Files From Cells & Save As Name In Adjacent Cell (7 replies)
  129. Solved: Assigning a date variable for use in a file extension (8 replies)
  130. User Form Help (2 replies)
  131. Assistance with formula arrangement (1 replies)
  132. Solved: linking text data between sheets (4 replies)
  133. UserForm control for a background process (0 replies)
  134. Solved: VBA for sorting column with formulas (3 replies)
  135. Solved: Format trend line dialog box (3 replies)
  136. Solved: [Excel] Open files listed in varialble, extract data (1 replies)
  137. Solved: Need help creating macro to insert col (3 replies)
  138. 1024 character limit help (4 replies)
  139. Loop to extract data (3 replies)
  140. Form TxtBox (6 replies)
  141. test if Excel 2007 is in Compatibility Mode (0 replies)
  142. Solved: Finding Information in one spreadsheet to populate another spreadsheet (4 replies)
  143. Solved: Help speed up this code (2 FOR loops seem to be the problem) (6 replies)
  144. selecting last row / cell (9 replies)
  145. formatting vba to work on a protected sheet. (5 replies)
  146. Using another source (2 replies)
  147. Solved: subtract two formula (2 replies)
  148. Solved: List File Names (12 replies)
  149. understanding arrays (5 replies)
  150. txtboxes and cells. Updating editing userform (5 replies)
  151. Solved: change formula (11 replies)
  152. conditional formula (10 replies)
  153. monte carlo output: statistics in Excel (How?) (4 replies)
  154. Solved: 2 formulas required - Part 2 (7 replies)
  155. Solved: 2 formulas required - Part 1 (6 replies)
  156. Solved: Treeview nodes (7 replies)
  157. Benefit of making sheet object rather than directly manipulating sheet (2 replies)
  158. Solved: Find/Replace in One Column over Entire Workbook (13 replies)
  159. Copy or link data between sheets (8 replies)
  160. Activate range on a different sheet (10 replies)
  161. Solved: Select item in list if only one exists (2 replies)
  162. Solved: incorporating condition or math into sumproduct (2 replies)
  163. Solved: problem with a conditional average (23 replies)
  164. Solved: Automate msgbox cancel (4 replies)
  165. Solved: Macro to warning user of duplicate entry (4 replies)
  166. CODE CANT BE WORK (9 replies)
  167. Excel VBA Copy & Paste (7 replies)
  168. Number format to dispaly on a label from text box (3 replies)
  169. CommandButton &i.Elabled = False (2 replies)
  170. Transposition and rearrangement of data using VBA (2 replies)
  171. Want a Userform (4 replies)
  172. Solved: Userform and data validation (12 replies)
  173. Solved: What's wrong with this function? (6 replies)
  174. Rolling Reference number (11 replies)
  175. Worksheet activate code in Add-in (3 replies)
  176. Excel macros (if statements etc) how? (4 replies)
  177. Search certain column in all worksheets and paste rows to seperate worksheet. (2 replies)
  178. Treeview Losing Checked Checkboxes (2 replies)
  179. Date Stamping a Cell Modification (6 replies)
  180. Check or selected rows in array? (8 replies)
  181. refreshing data in excel (1 replies)
  182. Trim not working and moving through a range (1 replies)
  183. Solved: Best way to select these ranges w/ macro? (5 replies)
  184. Sleeper: Date Dif function (4 replies)
  185. A complex IF formula (5 replies)
  186. Solved: Delete function failing (10 replies)
  187. Connections in MS Excel 2007 (0 replies)
  188. Getting around Pivot Table 256 Col Limitation (4 replies)
  189. MACRO/VBA help!!! :S new line... etc (5 replies)
  190. Date Format (4 replies)
  191. Solved: Hours to be worked by Month (14 replies)
  192. Solved: Stop Them Deleting Rows (2 replies)
  193. worksheet is not picked up in Vba (4 replies)
  194. Macro Security (17 replies)
  195. Extracting certain data to another sheet (1 replies)
  196. loop + offset/resize problem (4 replies)
  197. From one sheet to another... (5 replies)
  198. Solved: Special Transpose (2 replies)
  199. Solved: make a dynamic if statment? (4 replies)
  200. Alternative to Eomonth formulae question (3 replies)
  201. Solved: Fast Compare using Filter (6 replies)
  202. copy range, skip empty cells (6 replies)
  203. Solved: problem of structure (4 replies)
  204. Solved: Userform buttons to enter numbers into textbox (7 replies)
  205. Solved: problems saveing two copies. (2 replies)
  206. Solved: From one array to another (3 replies)
  207. Solved: any value in a range = 0 then return 0 ? (3 replies)
  208. Solved: Sum and compile list of entries (4 replies)
  209. Solved: using a worksheet function in vba (2 replies)
  210. Easy! How to make a button that generates a random number? (6 replies)
  211. Solved: case yes-no, can the code be smaler? (5 replies)
  212. Solved: alpha-numeric 2 (3 replies)
  213. Split string into multiple parts no bigger than 240 chars? (9 replies)
  214. Solved: Create a worksheet for each value in Column A (6 replies)
  215. [SOLVED:] Variable Columns Lengths (3 replies)
  216. problem using a function from an external library in vba (3 replies)
  217. Excel Macro Help Please (1 replies)
  218. Execel, OLEObjects (buttons) sometimes not firing, triggering (5 replies)
  219. C&P all data of all the sheets/workbooks in a folder. (4 replies)
  220. If no dependents msgbox and resume loop (14 replies)
  221. [Help Please]Parsing parameters to event (2 replies)
  222. Help! I'm working with two spread sheets (1 replies)
  223. Combobox Visibility After Drop List Selection (5 replies)
  224. Formatting entire row based on text in first column (1 replies)
  225. Solved: Problem auto-installing VBA add-in (10 replies)
  226. How to find the last duplicate value (6 replies)
  227. Pass a named range into function issue (5 replies)
  228. Listview help (0 replies)
  229. Summing a column based on two criteria in other columns (11 replies)
  230. Random number generation (6 replies)
  231. Solved: move up (9 replies)
  232. Clipboard is full (1 replies)
  233. Controlling Internet Explorer's "Print pop-up" (4 replies)
  234. Check if a file on the web exists (0 replies)
  235. VBA for time display (7 replies)
  236. Solved: Saving As Text adds double quotes to some lines! (1 replies)
  237. rectangle question (0 replies)
  238. Excel Right Click Menu Always Up (13 replies)
  239. Group 2 cells like in a userform. (7 replies)
  240. Count coloured cells and display result in table. (3 replies)
  241. Solved: Add Border if Statement (4 replies)
  242. Getting Data from an Excel Spreadsheet object to a normal excel spreadsheet (3 replies)
  243. Solved: Feeling dumb today!!! (13 replies)
  244. CommendBox (18 replies)
  245. Solved: Loop through one column on any sheet in workbook.... (5 replies)
  246. Solved: Code change to allow for Data table changes (14 replies)
  247. How to delete a row if it contains a word? (11 replies)
  248. Command Button to save, print and clear (8 replies)
  249. Using a combo box to select a named worksheet (3 replies)
  250. Solved: Combining macros (12 replies)