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: Help adding a couple lines of code (7 replies)
  2. Solved: xlPasteSpecial method (9 replies)
  3. Solved: disabling insert / delete command in excel (6 replies)
  4. Solved: Integral cells as header (3 replies)
  5. [SOLVED:] Dynamic name Rage? (or better solution) (21 replies)
  6. Solved: Data won't copy to database (19 replies)
  7. Graphic problem when I print an excel file into PDF (9 replies)
  8. Solved: Assistance Reducing to Better Code (4 replies)
  9. Solved: Problem of accessibility within a project (22 replies)
  10. Unhide Rows (5 replies)
  11. Solved: Opening workbooks within subfolders (21 replies)
  12. how to copy and paste a row of cells from one worksheets to another worksheets? (2 replies)
  13. Shared Spreadsheet (1 replies)
  14. Doing a date out(radio button)twice where i want the 2nd time not allowed to (2 replies)
  15. Solved: How do you Redim Preserve a 2 dimensional array? (5 replies)
  16. Sumproduct syntax as a VBA Worksheet Function (1 replies)
  17. Fun - Ask user if they want to edit (on a timer) before running workbook_open (5 replies)
  18. Solved: help with this VBA (6 replies)
  19. Frustrated trying to Reorganize Dataset (1 replies)
  20. Solved: Looping Creation of Pivot Table (3 replies)
  21. Lost links to shortcuts (4 replies)
  22. Auto open procedure via vbscript (3 replies)
  23. Solved: UserStatus,GetObject and Application UserName (6 replies)
  24. Calculate future date w/ out weekends and holidays (10 replies)
  25. gmt function (2 replies)
  26. Solved: Worksheet naming based on cell data (3 replies)
  27. Solved: Adding Rows in Userform (10 replies)
  28. internal order of sheets, CodeName (10 replies)
  29. [SOLVED:] Sending email to Outlook with ClickYes (14 replies)
  30. Solved: Numbering by date (19 replies)
  31. Solved: Trimming Things Down... (3 replies)
  32. Switch to second worksheet or add new one (2 replies)
  33. Get Row Count after Filters have been Set (1 replies)
  34. Advice on Good Programming Books (12 replies)
  35. Sort A to G and S columns (13 replies)
  36. Solved: Problem Deleting Rows (2 replies)
  37. [SOLVED:] Auto - Filter (check on/off Status) (10 replies)
  38. How do I use createsummary? (1 replies)
  39. Friday discussion - Monty Hall (6 replies)
  40. Convert Macro to VBA (2 replies)
  41. Can we write both in left and right alignment in same cell? (5 replies)
  42. How to determine #/type of function arguments via CODE (3 replies)
  43. [SLEEPER:] Can you reference an enum value as a string (7 replies)
  44. Solved: consolidating columns (7 replies)
  45. create a sequal (1 replies)
  46. Looping (6 replies)
  47. Solved: Hiding and showing a chart with a cmd btn (5 replies)
  48. How to format fonts in VBA? (3 replies)
  49. Solved: Merge Rows Problem (3 replies)
  50. 2 Files (1 replies)
  51. Concantenate Loop (3 replies)
  52. Solved: Help w/auto "Save As" macro (10 replies)
  53. Copying & pasting with a For...Next Loop (43 replies)
  54. Change the position and size of the Pie Chart (3 replies)
  55. Solved: How to Access Objects/Tools (ie ListBoxes) of a UserForm? (3 replies)
  56. Solved: Excel to Word mailmerge problem (7 replies)
  57. Macro - please help with VB Code (5 replies)
  58. Solved: check entire cell for a word (7 replies)
  59. Sum If/ Data output problems (6 replies)
  60. Move chart from one sheet to a specific location on another sheet (1 replies)
  61. Solved: Find last used cell, then insert new row & paste data from other worksheet (16 replies)
  62. Solved: Compare text strings in macro with strings in WS (11 replies)
  63. help ps, run out time (2 replies)
  64. Solved: help,about use 2 vba at the same time (4 replies)
  65. Solved: Excel Templates (3 replies)
  66. Solved: After a macro or code is run the undo function doesn't work. (3 replies)
  67. Solved: Help With Hiding Colums (4 replies)
  68. Solved: When cell is selected need to change color/highlight the row and columns (11 replies)
  69. Solved: Log Excel Worksheet Activities (3 replies)
  70. why i dont get 100% correct results (5 replies)
  71. Solved: Sum If funtion help (11 replies)
  72. Personal workbook? (3 replies)
  73. Change cell colour and copy cell format over to word (1 replies)
  74. limited times or dates usage (6 replies)
  75. ABOUT SAVE (7 replies)
  76. Solved: Autofilter's Strengths And Weaknesses.. (1 replies)
  77. Alter The Name When Saving (2 replies)
  78. Solved: Filtering out cell contents (2 replies)
  79. Solved: How do I get the VBA Extensibility library? (3 replies)
  80. Solved: How do you name an imported module via code? (4 replies)
  81. Solved: Delete rows by dates (7 replies)
  82. Solved: Design Advice & VBA Usage (5 replies)
  83. Solved: Converting Excel Sheet into PDF (19 replies)
  84. Copying specific records from specific date period (3 replies)
  85. Solved: How do I do preformatting in excel and copy that formatting + data over to word? (7 replies)
  86. RefEdit (3 replies)
  87. Solved: Create a new word doc for every worksheet? (13 replies)
  88. Solved: ActivePrinter (5 replies)
  89. How to change the target of the hyperlinks in excel VBA ?? (5 replies)
  90. Solved: Find Method - Why & How? (2 replies)
  91. Automatic Add/Delete Rows or Columns (10 replies)
  92. Find Method and WholeWord in Excel (3 replies)
  93. Excel Version problem?? (3 replies)
  94. Calculating Duration (4 replies)
  95. Solved: Can't see Reference as object (5 replies)
  96. Solved: Check whether row is odd or even (2 replies)
  97. [SLEEPER:] Copy worksheet information to Word using VBA in Microsoft Excel (1 replies)
  98. Determine which strings are new and copy them to WS (1 replies)
  99. Solved: Count Text (7 replies)
  100. Controlling Defined Name Scope (6 replies)
  101. getObject disable update links or choose don't update (10 replies)
  102. Worksheet name as a variable (5 replies)
  103. macro from one workbook updates another (6 replies)
  104. Solved: Class With Events (3 replies)
  105. Solved: Deleting worksheets (3 replies)
  106. Macro to Edit Workbook Links (4 replies)
  107. Copy content from excel to word. (1 replies)
  108. Solved: Summing variable ranges (7 replies)
  109. Conditional Formatting cells containing certain (amongst other) values (5 replies)
  110. Moving Items Between ListBoxes (4 replies)
  111. Solved: Indirect Vlookup vba (6 replies)
  112. Solved: subtract time (9 replies)
  113. Find the last item and select it (4 replies)
  114. Solved: Active Workbook (14 replies)
  115. fifa 2006 (9 replies)
  116. Solved: Excel to get Data from an Access Database (16 replies)
  117. deletea ll sheets (1 replies)
  118. Solved: Sum rows according to column condition (5 replies)
  119. Importing libraries explicitly in macro code (1 replies)
  120. Solved: Help with a Loop in a Loop (2 replies)
  121. Using a cell reference/column value to copy rows to a new worksheet (4 replies)
  122. Solved: Making Excel invisible on opening (12 replies)
  123. Solved: If text then perform this, if not then skip. (3 replies)
  124. Solved: How to hide the Excel Icon in a custom menu bar (15 replies)
  125. Solved: Setting a date range (5 replies)
  126. Delete duplicates (2 replies)
  127. textbox autotab and maxlength properties (1 replies)
  128. Template-document new equivilant in Excel (3 replies)
  129. Solved: Convert formula to vba code (4 replies)
  130. Solved: Removing hyperlinks (6 replies)
  131. calling the internet (1 replies)
  132. pick up same artno but differnet attribute (1 replies)
  133. Getting list of table & field names from Access into Excel using VBA (1 replies)
  134. Solved: retrieve specified field data from other Excel file & append to current Excel file. (3 replies)
  135. WordWrap and TextBoxes (2 replies)
  136. Count Rows (30 replies)
  137. If this do that, If not Do the other (3 replies)
  138. Solved: Code is broken (3 replies)
  139. Switch to unknown named workbook (9 replies)
  140. Macro to Delete IF (17 replies)
  141. Solved: how to display all options of a combo box (3 replies)
  142. [SOLVED:] Reading Tag name, editing it and saving. (3 replies)
  143. Solved: Disable "X" Button on ActiveWorkBook (8 replies)
  144. [SLEEPER:] moving row of data from one sheet to another (3 replies)
  145. Copy worksheet information to Word using VBA in Microsoft Excel (3 replies)
  146. Scope of Two Defined Identical Names (2 replies)
  147. Password Protection (4 replies)
  148. Can you ppl help me test this macro? (3 replies)
  149. Solved: how to buttom changed from inactive to active (2 replies)
  150. Streamline code from MRecorder to Good Code Help (3 replies)
  151. Solved: Help understanding line of code (3 replies)
  152. Solved: How to Paste.Special.Values w/ this line of code (17 replies)
  153. multiselect list box (17 replies)
  154. Help on code found here (InputBox Type 8) (2 replies)
  155. Solved: Help: Adding function to line of code (9 replies)
  156. Inserting Values in a Multidimensional Array from Two Different Controls (6 replies)
  157. Solved: Excel macro question: matching text to numeral value & inserting the numerals + more! (4 replies)
  158. Solved: Finding a range based off of two comboboxes (1 replies)
  159. Format a cell before writing in it (2 replies)
  160. Solved: Problem with indexing on a user form (0 replies)
  161. Solved: Select Rows by Date (22 replies)
  162. Match & Index Functions (2 replies)
  163. Solved: select other object when a textbox is full (4 replies)
  164. Populate empty cells with zeroes? (3 replies)
  165. [SOLVED:] Can't use Right function??? (3 replies)
  166. Solved: do - until cell equals blank (5 replies)
  167. Solved: Copy specific rows (3 replies)
  168. Solved: MDI "like" child userforms ? (9 replies)
  169. summing months (5 replies)
  170. Where Are the Hidden AutoShapes?? (12 replies)
  171. Solved: For Each c In Range("Test") (13 replies)
  172. dates between dates??? (10 replies)
  173. put range of cells into variable (11 replies)
  174. Solved: Rewrite this line of code (6 replies)
  175. Merging cells and suppress excel's popup (4 replies)
  176. Solved: Sort Non-Adjacent Columns (3 replies)
  177. Solved: Sum all cells using Sheet Name, Row number, & Column number (3 replies)
  178. Solved: Intercept Late Binding (Double Click xl file) (3 replies)
  179. Copy a row, delete, then move on (2 replies)
  180. Solved: Insert Rows by taking the difference from another worksheet. (7 replies)
  181. Formatting a number (1 replies)
  182. Solved: Unprotect/Protect Workbook (2 replies)
  183. Userform - Column Heads (2 replies)
  184. Solved: Drive letters for Devices with Removable Storage (13 replies)
  185. Solved: Moving to a specific cell with VBA (5 replies)
  186. Solved: Copy update value from changing file name (2 replies)
  187. Solved: Check if Named Range exists (8 replies)
  188. Solved: Insert Deleted Cell At Bottom Of Range (5 replies)
  189. Solved: Create New Collection (10 replies)
  190. Lookup using VBA (3 replies)
  191. [SOLVED:] List All Macro Shortcut Keys... (3 replies)
  192. Pivottable Refresh (1 replies)
  193. Excel vba syntax for Access query (6 replies)
  194. Solved: Save on exit to a folder (8 replies)
  195. Solved: Getting value from interception of row and column. (7 replies)
  196. Solved: Calculate time (3 replies)
  197. Solved: copy and transfer specific rows (3 replies)
  198. Solved: Send a frame control to a procedure as a parameter (2 replies)
  199. Conditional copy for row-Date range (2 replies)
  200. [SOLVED:] Application.Calculation (5 replies)
  201. Where is UserForm_Initialize() ? (4 replies)
  202. Solved: Equations using adjacent worksheets (2 replies)
  203. text box search (6 replies)
  204. VBA Properties Locked (9 replies)
  205. maro to work on one sheet as opposed to all sheets in the workbook (1 replies)
  206. Solved: Progress Bar (3 replies)
  207. Solved: writing option button caption in a cell (3 replies)
  208. Solved: Row question (9 replies)
  209. Sleeper: Using loop Macros (2 replies)
  210. Solved: Copy between sheets (29 replies)
  211. Characteristics of an Invisible Sheet (8 replies)
  212. Merge 2 Named Ranges (20 replies)
  213. Execute Conditional Formatting Code on TWO events (2 replies)
  214. Problem between sheets (2 replies)
  215. Solved: Help! - copy rows based on column criteria (7 replies)
  216. [SLEEPER:] Ways to remove items from combobox (7 replies)
  217. Fairly new to VBA, what training..... (1 replies)
  218. Solved: help with changing properties of objects on a form (7 replies)
  219. Solved: Look up a date range (5 replies)
  220. Autofilter optimization (4 replies)
  221. Controlling userform data with combobox. (3 replies)
  222. Solved: Using named shapes (3 replies)
  223. run-time error '424' (3 replies)
  224. Save as causing change event on combo box (1 replies)
  225. Restore all built-in toolbars (4 replies)
  226. help with unusual date find (10 replies)
  227. Solved: Diffrentiating same week numbers , but of different years. (5 replies)
  228. IsNumber is not working (1 replies)
  229. Ordering a listbox (3 replies)
  230. IsMissing is not working! (3 replies)
  231. Call function (1 replies)
  232. Rename sheets from cell in active sheet (4 replies)
  233. Abstract summary data using formulae (5 replies)
  234. Shared File Utilizing Template (6 replies)
  235. Input box error handling (6 replies)
  236. Solved: Unusual Problem using mid and format in vba (2 replies)
  237. How to use SPLIT function in VBA (1 replies)
  238. Date Difference but as Text Format from Form (2 replies)
  239. Explain this bit of code (1 replies)
  240. Displaying a graph on a form (5 replies)
  241. [SOLVED:] Rearrange columns (6 replies)
  242. Solved: Inserting Rows (19 replies)
  243. Solved: Copying sheets and incrementing names (11 replies)
  244. [SOLVED:] Calling the "Duration" function in excel to be used in VBA? (3 replies)
  245. VBA Codes that i like to learn :) (8 replies)
  246. Help with printing macro - -please!!! (1 replies)
  247. Sleeper: Inserting email address (6 replies)
  248. Solved: based on Cell/Column content ,cut 1 sheet's row values and paste it in other sheet? (9 replies)
  249. Solved: Timed Loops (1 replies)
  250. Searching for a Chart Series by Series Name (4 replies)