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: How do you set up this simple array? (12 replies)
  2. Delete everything on sheet except? (3 replies)
  3. Help to modify code (2 replies)
  4. Store data and put them on a new sheet? (2 replies)
  5. Solved: Test Large Change (3 replies)
  6. Solved: Someone hide the codes? (2 replies)
  7. Solved: prevent textbox selection without disabling it (2 replies)
  8. driving hours (0 replies)
  9. HELP needed with VBA MMULT (1 replies)
  10. Solved: How to combined Modul (5 replies)
  11. Solved: Calling a function from a worksheet formula (2 replies)
  12. Copy/Paste Macro issue (4 replies)
  13. Run-time error 1004 trying to select cells (7 replies)
  14. [SLEEPER:] Why does my code not work Internet Explorer (4 replies)
  15. Macro Slows with the same data... (4 replies)
  16. VBA Lookup Errors (1 replies)
  17. Solved: Create a sound (35 replies)
  18. User Defined Function - Payment(mode, price) (5 replies)
  19. Deducting amount of time (hrs) from a date and time stamp (dd:mm:yy hh:mm:ss) (2 replies)
  20. looping results (7 replies)
  21. Solved: Excel2007 .RemoveDuplicates (6 replies)
  22. Solved: Need to limit choices for the save as name. (6 replies)
  23. Solved: Formula for count by day and hour (2 replies)
  24. Workbook Open/Before Close events (3 replies)
  25. Small problems with generating a Bubble Chart in VBA (1 replies)
  26. [SOLVED:] Need to count rows in the copied range, or rows in the clipborad (3 replies)
  27. [SLEEPER:] User Defined Function - Mtwo = 2X (1 replies)
  28. pull letter above after subtotal (7 replies)
  29. Solved: Conditional Output to Pre-Formatted Worksheet (12 replies)
  30. Delete data from Pivot Table (2 replies)
  31. Solved: Merge data as value without formatting (4 replies)
  32. Rearrange Excel Sheet to uploadable File for SQL Server (2 replies)
  33. Solved: New Excel files based on Cell values (9 replies)
  34. How to get help quickly - and keep getting it. (1 replies)
  35. How can we update the date in a cell when we modify a text cell? (4 replies)
  36. Automatic Creation of combobox (4 replies)
  37. [SOLVED:] Clean up Sort (3 replies)
  38. Putting selected cells data into one cell (1 replies)
  39. Solved: Button to Copy & Move to another sheet ERROR (3 replies)
  40. File Size comparison by VBA (2 replies)
  41. Solved: cancel ESC key (1 replies)
  42. Search data and return latest status based on date & time (0 replies)
  43. User Form (7 replies)
  44. [SOLVED:] Topic - Help Debugging Code : Placing a range in the body of an email. (1 replies)
  45. Solved: Arrange sheet by name in between other sheets (6 replies)
  46. Excel 2007 - Can vba display the MenuFloaties mini toolbar? (0 replies)
  47. Disable Cut, Copy, Paste Request (6 replies)
  48. Need Help in creating a movie list catalogue (1 replies)
  49. Reading a text file (20 replies)
  50. Help with Solver in VBA (range related) (2 replies)
  51. Solved: Getting External Data From Web (2 replies)
  52. Solved: Vlookup with an Index & Match formula (5 replies)
  53. Copy Prices (with conditions - VBA) from one workbook to another (4 replies)
  54. Solved: Listbox+rangecopy+concatenate (7 replies)
  55. [SOLVED:] If statement based on active worksheet Index Name (2 replies)
  56. Getting data from different sheet and sort and sum (5 replies)
  57. Text Import Code crashes at same record (2 replies)
  58. [SOLVED:] VB Code to Copy a table and place it in an email. (4 replies)
  59. Set Formula and Notify if changed (2 replies)
  60. How to compare two sheets (1 replies)
  61. Not able to access elements from a webpage (0 replies)
  62. Solved: Resizing Array (4 replies)
  63. Exclude Sat & Sun while calcualting due date (11 replies)
  64. Automatically move cursor if value exist (2 replies)
  65. Solved: Displaying - 0 - while using VBA (0 replies)
  66. Listbox selection criteria report (0 replies)
  67. Solved: updating data from another workbook (7 replies)
  68. how came wb close by module showing in VBAProject window? (0 replies)
  69. Moving range to onther sheetbase on cell value (9 replies)
  70. Solved: Loop that works on all sheets in workbook (2 replies)
  71. If statement logic question (2 replies)
  72. Creating a folder with cell contents (1 replies)
  73. Solved: Help: Run-time error '1004': Application-defined or object defined error (2 replies)
  74. Little Regex Problem (1 replies)
  75. Solved: Collates data from many sheets to Master sheet (5 replies)
  76. email results (0 replies)
  77. Solved: Automatically import a .bas module (5 replies)
  78. Run a macro on a different wbk (10 replies)
  79. Replace and sort macro (1 replies)
  80. Debugging - Show workbook if code running on memory? (3 replies)
  81. Solved: Apply code only to column A (7 replies)
  82. Solved: *Automatically Unprotect & Protect sheet - Macro command button (14 replies)
  83. Solved: Getting data from other sheet with if statement and somprodukt (6 replies)
  84. Filling a range of cells using a VBA function (2 replies)
  85. Solved: match / lookup to code table on different sheet (3 replies)
  86. need a save as text macro with delimiter (12 replies)
  87. Amend Macro Store Info In Different Places (2 replies)
  88. Sync Pivot Tables (1 replies)
  89. How do you make a clickable button without creating a form? (2 replies)
  90. Macro To Add Grades Into System (2 replies)
  91. [SOLVED:] Grid combination logic problem (3 replies)
  92. add alert to txt if criteria met (6 replies)
  93. Solved: MATCHROW = 0 > HIGLIGHT (18 replies)
  94. Force Macro + Other Applications (0 replies)
  95. Solved: Convert Date (2 replies)
  96. Lookup data from many sheet and Skip blank (3 replies)
  97. [SLEEPER:] Close Wbk-a and open Wbk-b (1 replies)
  98. Application.EnableEvents problem (9 replies)
  99. Creating a Login Form (2 replies)
  100. checking that a user entered decimal number in textbox is only upto 4 decimal places (1 replies)
  101. Importing From txt File (3 replies)
  102. Solved: Change a Picture or Object Color using cell values (8 replies)
  103. Solved: Conditional formatting query (5 replies)
  104. Need help in creating complex macro. (13 replies)
  105. Get current keyboard layout with VBA (1 replies)
  106. Solved: Solved: (9 replies)
  107. Pasting a selection of data (4 replies)
  108. Two questions: Long and Dim (8 replies)
  109. Command Bttn import .csv file to new worksheet (2 replies)
  110. How to LinkColumn of a Saved Workbook (1 replies)
  111. Solved: Worksheet_Change with 2 requirements (4 replies)
  112. Solved: Clearing Pivot Cache (2 replies)
  113. Change cell color from user form (2 replies)
  114. User Form (1 replies)
  115. Solved: VSTO (2 replies)
  116. [SLEEPER:] Remove conditional formatting but keep format (14 replies)
  117. Generating a simple report based on some criteria (10 replies)
  118. Solved: Delete rows if cells in multiple columns are blank (7 replies)
  119. Solved: Date format changing when pushed to SQL Server (7 replies)
  120. Solved: IF Statement doesn't work (14 replies)
  121. How to Lookup data from different sheets to single workbook (2 replies)
  122. Solved: create notepad (2 replies)
  123. Solved: Relying on Exit Sub too much (4 replies)
  124. Integer & String (6 replies)
  125. Solved: select previous sheet that I viewed (8 replies)
  126. Hovering text not disappearing after click (8 replies)
  127. dissable richt click page setup (4 replies)
  128. Solved: "If FileExist" isn't seeing the file (2 replies)
  129. Solved: Add name to combo box (5 replies)
  130. [SOLVED:] Display logo pasted to worksheet as icon on desktop shortcut (7 replies)
  131. Read date and time from active cell to a date picker (3 replies)
  132. Solved: Lose formula reference in active cell (2 replies)
  133. Can I use vba to set page breaks and fit the sheet’s data to 3 pages? (1 replies)
  134. Excel Lookup Problem (1 replies)
  135. Format Percentage Problem (2 replies)
  136. Help on merging wbksheets (0 replies)
  137. Solved: Making Scripts More Efficient (5 replies)
  138. auto set page break to last row with data (5 replies)
  139. Font red and Bold specific dates returned on email sent. (1 replies)
  140. Not Sure How To Title This (2 replies)
  141. Linking 2 Combo Boxes Together? (3 replies)
  142. Solved: Calendar pop up with date AND time (4 replies)
  143. data validation - number or number / 2 (11 replies)
  144. Dynamic Array (5 replies)
  145. Solved: Why i get Vba Error in this code?? (6 replies)
  146. Split Text file data (1 replies)
  147. Macro help! (9 replies)
  148. Eliminate unwanted data... (1 replies)
  149. Can you force code to run in order? (15 replies)
  150. Solved: Display following year in combo box (2 replies)
  151. Solved: Formula to return latest date (3 replies)
  152. [SOLVED:] Test for empty directory - odd result (3 replies)
  153. VBA to automatically run (4 replies)
  154. Solved: Excel VBA to select rows after Pivot Table (2 replies)
  155. [SOLVED:] Excel keeps freezing for about 5-7 seconds (2 replies)
  156. Print Macro and Cell to Populate from table Help! (1 replies)
  157. Macro names changed in V2007 (2 replies)
  158. Solved: Hide/Show Rows based on % character in cell (16 replies)
  159. Loop A Script (3 replies)
  160. Embedded Spread Sheet - Span to next page (0 replies)
  161. Find and delete (1 replies)
  162. [SOLVED:] Dynamic Procedure call (2 replies)
  163. xlt question (2 replies)
  164. Copy And Compare vs Switch And Compare (5 replies)
  165. .xlsm row restrictions? (2 replies)
  166. [SLEEPER:] Want to use vb YES/NO question box (2 replies)
  167. Solved: Summing to a target (3 replies)
  168. efficient way of comparing whats already in a collection (6 replies)
  169. Set a value from different sheet in other sheet (8 replies)
  170. Solved: Shortcut to run macro (3 replies)
  171. Solved: Delete Row Based On Value (13 replies)
  172. Writing a .CSV file (.txt) from a Sheet (2 replies)
  173. Creating an OnClick event for an autopopulated userform (7 replies)
  174. Solved: How to import multiple sheets from different files in same folder to main workbook (16 replies)
  175. Loop web query (7 replies)
  176. Select sheets based on name (14 replies)
  177. Lock Cell after value updates to specific value (3 replies)
  178. [SOLVED:] Copy and rename sheet in sequential order (4 replies)
  179. Solved: An error with setting a wb. Why? (17 replies)
  180. Macro: Move Cells where QTY is in upper percentile (2 replies)
  181. Loop through folder of Excel files and copy sheet from one set into another (1 replies)
  182. Getting a 0 When Dividing (2 replies)
  183. Solved: Loop with Go to steps? (5 replies)
  184. Messagebox to remind user of 12 day limit (15 replies)
  185. Solved: General questions on excel objects... (11 replies)
  186. Convert String To Date (9 replies)
  187. Macro's for printing (3 replies)
  188. [SOLVED:] Copy worksheet with referencing old worksheet (12 replies)
  189. ref range to replace sheet name (5 replies)
  190. Solved: display worksheets in combo box except... (1 replies)
  191. Solved: Unable to change the name of this cell (3 replies)
  192. Solved: Open workbook to last Friday of current week (10 replies)
  193. Lock Cell Format? (1 replies)
  194. Excel VBA Access (3 replies)
  195. how to use VLOOKUP only for blank cells in column A (3 replies)
  196. Solved: slow macro (11 replies)
  197. Assign Value to Variable Type Range (4 replies)
  198. Solved: Delete row if default value (4 replies)
  199. Macro: Need to find all unmatched Data (22 replies)
  200. Solved: Fill by number of rows (2 replies)
  201. Data Validation - "A" and 2 number and 2 letters (3 replies)
  202. Which FileFormat code (enumeration) for XL 97-2003 ? (2 replies)
  203. Can anyone improvise this data and chart? (5 replies)
  204. Userform Validation - Unique Names & Numbers (15 replies)
  205. Error: Object Variable or With block variable not set (1 replies)
  206. Forgot the password I gave to protect a part of sheet (2 replies)
  207. Solved: Not sure how to fix this loop? Help Please (6 replies)
  208. set calendar to open at a specified date. (1 replies)
  209. Reordering rows where sort is not effective (0 replies)
  210. Solved: Click on protected sheet (20 replies)
  211. Need some newbie help with Cell validation (7 replies)
  212. Application.Volatile Method (8 replies)
  213. Override the built in SAVE (6 replies)
  214. Solved: Macro's slowing down my spreadsheet (0 replies)
  215. Check Cell for Blank (3 replies)
  216. Copying the entire workbook to a new workbook (5 replies)
  217. Control Inputbox as number only? (3 replies)
  218. Solved: Activate certain sheet based on cell content (2 replies)
  219. Generating one .TXT archive from the Sheet. (0 replies)
  220. Change all pivot table data sources (0 replies)
  221. Modifying Code for Whole to Flash (1 replies)
  222. Data Validation C2*D2 = E2 (3 replies)
  223. Compare dtmDate with a value in column A (6 replies)
  224. [SOLVED:] Add a WebService reference to an Excel 2010 sheet (21 replies)
  225. [SOLVED:] Set Msgbox with Default number? (2 replies)
  226. Solved: conditional formatting (1 replies)
  227. Solved: Label display (4 replies)
  228. [SLEEPER:] excel - checkbox (2 replies)
  229. Does VBA Lose Variable Definitions and/or Values between Subs? (14 replies)
  230. on change event according to pivot table (1 replies)
  231. Solved: caption SaveAs location (4 replies)
  232. looking for value position in table (3 replies)
  233. Solved: Total sum of Time in a column (5 replies)
  234. Solved: CNTL + N (2 replies)
  235. Solved: How many substrings returned by Split() ? (3 replies)
  236. Form position (5 replies)
  237. Solved: Data Validation List shortcoming(s) (3 replies)
  238. Solved: Code for vba to replace below formula (13 replies)
  239. problem with excel 2010 slicers (0 replies)
  240. How to delete a Empty column? (2 replies)
  241. [SOLVED:] How to Throttle SMTP Traffic (17 replies)
  242. Solved: InputBox Help (4 replies)
  243. Created a Drop Down Box based on certain criteria! (1 replies)
  244. Macro: look up another field and pull the data not matched (4 replies)
  245. Solved: Embedded Spread Sheet (4 replies)
  246. Solved: VBA Code, who can help? (14 replies)
  247. Solved: Match Name find Row No then copy values to sheet2 (4 replies)
  248. Solved: Address (4 replies)
  249. Solved: variable ProperCase (19 replies)
  250. iterate till equilibrium reached (7 replies)