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. Protect workbook, save and close (6 replies)
  2. rc (1 replies)
  3. Auto Email (4 replies)
  4. Solved: Track Changes in Excel Feature (1 replies)
  5. Open csv file using VBA (2 replies)
  6. Printing solution request (0 replies)
  7. [SOLVED:] Count number of files in a folder (2 replies)
  8. Creating a TOC for only visible tabs? Excel VBA (5 replies)
  9. Solved: DropDown Question (5 replies)
  10. test of CF (17 replies)
  11. Solved: vb conditional formatting (6 replies)
  12. Solved: Another Query question (8 replies)
  13. Mesage box - Conditional formating (1 replies)
  14. Run process at set time (2 replies)
  15. [SOLVED:] To get specific part of filename from a folder (5 replies)
  16. Solved: Having trouble with "Offset" or the equivilent (3 replies)
  17. Random (18 replies)
  18. [SOLVED:] explanation (1 replies)
  19. Solved: Count according to date (2 replies)
  20. Conditional formating (1 replies)
  21. copy filter cells (2 replies)
  22. Record Formula Evaluation Steps (0 replies)
  23. Print_Area Formula (11 replies)
  24. trouble with .Resize (5 replies)
  25. One message box in a for loop (3 replies)
  26. Solved: To Auto Populate Value (10 replies)
  27. CALCULATE (14 replies)
  28. Automatically split a large text file in separate worksheets on import (24 replies)
  29. Solved: to extend the coloring (11 replies)
  30. copy data (3 replies)
  31. trigger proc. with a date (2 replies)
  32. Microsoft Speech Object Library (1 replies)
  33. Solved: KB entry "Reduce Excel File Size "give run time error 1004 (17 replies)
  34. Button to interrupt subroutine (6 replies)
  35. Sending email without using outlook (1 replies)
  36. Changing default field "All" in pivot table (0 replies)
  37. [SOLVED:] Ribbon management in Excel-2007 (8 replies)
  38. Solved: Calculate age from row eleven (2 replies)
  39. Solved: how can i add "count" and "Sum" in existing code (4 replies)
  40. [SOLVED:] Excel 2010-Run VBA code pressing a sheet button (6 replies)
  41. VBA: embedded excel chart (0 replies)
  42. Solved: Copy text from shapes (7 replies)
  43. Solved: Skip blank cells (8 replies)
  44. Converting manual chart to bar chart? (0 replies)
  45. Bar chart help any example or sample file ? (0 replies)
  46. Extract text from multiple text files (22 replies)
  47. Dynamically allowing/disallowing user sheet insert. (1 replies)
  48. Parse Text (7 replies)
  49. Mesage box in VBA (6 replies)
  50. Need help with delete (13 replies)
  51. Save file as excel through xl macro from web- in existing code (1 replies)
  52. [SOLVED:] Filtering using a listbox across multiple columns (17 replies)
  53. Solved: Custom Classes and Collections (4 replies)
  54. Solved: Web Query...creating data crawler (1 replies)
  55. Solved: Delete multiple rows & Unhide hidden rows (6 replies)
  56. How to Delete Visible Rows in VBA? (4 replies)
  57. Solved: Splitting data from one column into multiple columns in excel (9 replies)
  58. Solved: Multiple logical tests (11 replies)
  59. Solved: log only once per 5 sec. - only fix code (6 replies)
  60. Default Messages (3 replies)
  61. Prevent Worksheet Deletion (2 replies)
  62. Oorang: A query about your GUID program (2 replies)
  63. How to Save File & Overwrite Original?? (2 replies)
  64. Subscript out of range for importing files (1 replies)
  65. Solved: Vba Automate Emailer for Lotus 6.5.3 (0 replies)
  66. Solved: Conditional Numbering (2 replies)
  67. VBA Macro - Automating Web Querie (0 replies)
  68. Pulling Information from a String (6 replies)
  69. Solved: Rename "Microsoft Excel Objects" (6 replies)
  70. [SOLVED:] Daylight savings time (2 replies)
  71. Extract Data from Outlook and populate it into Excel (6 replies)
  72. Not sure if possible..brackets issue (16 replies)
  73. [SLEEPER:] Inserting Flash in Office2007 (3 replies)
  74. Automatic Directory File List (15 replies)
  75. Solved: Excel 2003 end(xlup) problem (8 replies)
  76. VBA Code for pivot table from multiple worksheet (0 replies)
  77. Beginner (6 replies)
  78. VBA If statements Variable help! (3 replies)
  79. Count Half of the Visible Rows (8 replies)
  80. [SOLVED:] Automate Chart with filtered values (9 replies)
  81. [SOLVED:] Performing a Successive Filter (4 replies)
  82. Column counting and Loop (2 replies)
  83. Solved: Is there a shorter way to write my VBA code? (7 replies)
  84. Need Help for WEB PAGE TextBox (2 replies)
  85. ask permission (3 replies)
  86. [SOLVED:] Tracking Comments (3 replies)
  87. Solved: How can I have a nested IF-function combined with an OR and AND-fun (5 replies)
  88. Solved: Turning ScreenUpdating On and Off (4 replies)
  89. Click Event (6 replies)
  90. Solved: Matching 2 customer record sheets (25 replies)
  91. Read fr Open File > if not open > open file > and read cells (4 replies)
  92. Resize JPG files to consistent size (5 replies)
  93. RefEdit control to clear contents (14 replies)
  94. Get MS Word ActiveX Control values from Excel VBA (10 replies)
  95. Solved: Run Macro on Specified File and Worksheet (10 replies)
  96. [SOLVED:] Separated tables in one page (6 replies)
  97. Solved: Find Text Position (9 replies)
  98. Nested Loops-In What Sequence? (2 replies)
  99. Workbook to track changes in other workbooks (0 replies)
  100. formula/code cleanup (1 replies)
  101. Conditional Drop-Down lists + auto filling (5 replies)
  102. Create Pivot table from multiple worksheet (4 replies)
  103. Protected Sheet Allows Macro to Execute (7 replies)
  104. Looping Ranges (1 replies)
  105. Entering cell comments using VBA (5 replies)
  106. Help with a couple lines of code please... (8 replies)
  107. [SOLVED:] Using InputBox to select Range (2 replies)
  108. Filter Rows with Duplicate values. (14 replies)
  109. Macro to Group columns on the basis of criteria (1 replies)
  110. Solved: email from within excel using outlook (9 replies)
  111. Wildcard character for VBA (2 replies)
  112. Dynamic hyperlink that can survive sorting (0 replies)
  113. [SOLVED:] Working with CutCopyPaste Mode (2 replies)
  114. Method to merge two excel files without links (1 replies)
  115. Macro to save file with active cell value with 3 date options (10 replies)
  116. Solved: Macro for printing (6 replies)
  117. XP Visual Styles to Excel UserForm (0 replies)
  118. Form Button Font Keeps getting smaller (2 replies)
  119. Solved: Looping with textboxes (2 replies)
  120. Solved: Open and Close File (6 replies)
  121. [SOLVED:] Prevent Function calls in worksheet when running macro (8 replies)
  122. Solved: Help with Objects in a Collection (3 replies)
  123. Group Variables together (5 replies)
  124. How do you create a VBA formula code based on Filename? (5 replies)
  125. copy selected cell with links (1 replies)
  126. Unloading User Forms (5 replies)
  127. Help with Variables in Ranges (3 replies)
  128. Sub Returning Workbook (2 replies)
  129. Solved: Scanning Program that converts document to excel (4 replies)
  130. Solved: Extract distinct list from a range (11 replies)
  131. Copying to multiple workbook coding.. (5 replies)
  132. Open a workbook with a long file path (6 replies)
  133. How do I put Msgbox in between formulas in VBA? (12 replies)
  134. Transfering data from UserForm to specific cell (7 replies)
  135. WebBrowser Control with Animated Gif (0 replies)
  136. Making graphs in loop (2 replies)
  137. Solved: Clicking CANCEL After Executing a Command (6 replies)
  138. Solved: copy defined rows (5 replies)
  139. Solved: Disjointed Information to Table (Solved) (2 replies)
  140. Solved: Add ListBox item if item exist just once... (3 replies)
  141. [SLEEPER:] Using VBA to move the mouse to a specific coordinate and left click? (3 replies)
  142. Solved: Test for Existence of Toolbar (4 replies)
  143. From Excel to XML via VBA (2 replies)
  144. FORMULA FOR REPORT IN EXCEL (5 replies)
  145. Solved: VBA Web Query to google finance/reuters (21 replies)
  146. Creating dynamic Range for combobox (7 replies)
  147. Move multiple sheets from multiple files (0 replies)
  148. Solved: Convert to Propercase Selectively (9 replies)
  149. Can't Exit Design Mode because 'ControlCommandButton1' cannot be created? (3 replies)
  150. Solved: Remove last 4 rows from a listbox... (3 replies)
  151. Solved: Is there a shortcut for this code? (14 replies)
  152. Paste Data From Excel To Access (0 replies)
  153. Checking existence of a text in SQL database table column. (6 replies)
  154. Solved: Change code to choose .txt file already open (5 replies)
  155. Entering Selected Cell Values in Multiple Textboxes (1 replies)
  156. Excel wants to talk to Access (0 replies)
  157. Macro Help (1 replies)
  158. Solved: Loop OpenText function (8 replies)
  159. How to improve the performance of this code (17 replies)
  160. Solved: Looping through autofilter, copy, paste (1 replies)
  161. help me plz (2 replies)
  162. Solved: Loop through a range and hide active Column (2 replies)
  163. Solved: caclulating birthday in a userform (5 replies)
  164. Solved: moving array to worksheet (1 replies)
  165. Populate List Box in Excel with visible rows when worksheet gets filtered (10 replies)
  166. Solved: Lookup Help (10 replies)
  167. Solved: OpenText Method: Excel remembers Last Import! (17 replies)
  168. [SOLVED:] Highlighting Duplicate numbers in excel only when they are next to each other (2 replies)
  169. Sleeper: Collection Class - Item Method (1 replies)
  170. Solved: A list of distinct values (8 replies)
  171. Solved: listbox items as variables (3 replies)
  172. Solved: Please help tech wizards! (6 replies)
  173. Macro To Merge Data from Different worksheets (4 replies)
  174. Solved: Pulling Value Only (not equations) (13 replies)
  175. counting results from searchareas. (1 replies)
  176. Solved: How to add new range in the VBA (4 replies)
  177. Solved: Copy data from 1 workbook into another (6 replies)
  178. Solved: Method "FileSearch" Problem (10 replies)
  179. How to escape characters in Microsoft Excel, such as an equals sign? (6 replies)
  180. Solved: How do you create a quiz with microsoft excel 2007? (4 replies)
  181. Solved: Looping through Worksheets and inserting a formula into a Range of Cells (4 replies)
  182. I/O Excel to PicAxe Micro (3 replies)
  183. Solved: Format Chart Area (8 replies)
  184. Solved: Time format in user form (3 replies)
  185. Solved: Error with Recorded Macro (4 replies)
  186. Help with VBA code (3 replies)
  187. VBA for batch upload (3 replies)
  188. Solved: Sound alert (11 replies)
  189. Solved: Copy .txt file (2 replies)
  190. Sub routine isn't sending outlook message.. (12 replies)
  191. Using a click button to select data relating to checkboxes (5 replies)
  192. Simple Copy and paste (11 replies)
  193. Solved: Colour change based on cell value (6 replies)
  194. Match columns linked to external workbook (1 replies)
  195. Solved: special sort (7 replies)
  196. Solved: If value found, copy range macro help! (5 replies)
  197. Interactive Drop Down List/file chooser (0 replies)
  198. Solved: Insert picture (2 replies)
  199. Help reg user form development (1 replies)
  200. VBA programming question on cell selection and optimization (9 replies)
  201. Changing CommandBars.Name (5 replies)
  202. Solved: Calling a Script From Another Module (1 replies)
  203. Solved: VLOOKUP accross sheets (1 replies)
  204. Command Button Shrinkage (3 replies)
  205. Preserving Objects and Collections (1 replies)
  206. Solved: Making CheckBox1 Selected By Default (1 replies)
  207. Populate a field on a webpage and submit and record data (5 replies)
  208. how to find last non empty cell in col and use it as input in a range (3 replies)
  209. Any of you guys familiar with web query... (3 replies)
  210. Getting Week Numbers to Display over Multiple Years without Resetting to 1 (11 replies)
  211. Solved: Cell value capture (6 replies)
  212. Save Data to a Closed Workbook. (5 replies)
  213. Solved: faster way to delete row (4 replies)
  214. Copy Worksheets to a new Workbook (2 replies)
  215. custom order? (1 replies)
  216. Library Not Registered error (11 replies)
  217. Solved: User Input With Options (6 replies)
  218. Solved: Sum the distinct values under a specific criteria (8 replies)
  219. How to acees server xml file (0 replies)
  220. Solved: extend the border line (5 replies)
  221. Solved: Formatting Dynamic Toolbar (13 replies)
  222. Solved: Adding a New Toolbar (5 replies)
  223. Solved: Changing time string? (26 replies)
  224. Solved: Copying Named Ranges (2 replies)
  225. Solved: Can't get If,Or, to work (5 replies)
  226. Runtime error '1004' Application-defined or object-defined error regarding if formula (12 replies)
  227. Copy a table from an excel sheet to an Embedded Excel Chart Object's Sheet (7 replies)
  228. Solved: Monthly to Quarterly Part 2 (6 replies)
  229. Solved: Scrollbar (2 replies)
  230. Solved: Count unique entries that occur over consecutive dates (7 replies)
  231. Solved: Condionally Formatting a Row Based on a Cell Condition (7 replies)
  232. Solved: import empty column QueryTables thnks (3 replies)
  233. Solved: Buttons (8 replies)
  234. Solved: Deleting Rows based on criteria (6 replies)
  235. Solved: Problem with amended xld.sheetmanager code (6 replies)
  236. comparision macro is very slow (6 replies)
  237. Solved: how can i change this code to identifiy the 2 digit no? (5 replies)
  238. Solved: Limit character input in a textbox (5 replies)
  239. Solved: Check if combo box is populated (10 replies)
  240. Solved: User Changeable File Paths (4 replies)
  241. Automatic upload excelsheet (html) to web (0 replies)
  242. Copy Folder to specified path... (4 replies)
  243. Solved: Excel match headers, append data (2 replies)
  244. Solved: Seperate each recipient into own tab (12 replies)
  245. Button press effect in Excel Shape (1 replies)
  246. Search folder with a value in cell (3 replies)
  247. Pull data to new workbook with new sheet per workbook (4 replies)
  248. Solved: vba to ID info in cells and find other cells with same info (18 replies)
  249. Scrolling issue, going too far (2 replies)
  250. Solved: Check 1st 4 chars & conditionally enter a string (10 replies)