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. Solved: Copy Paste non-adjacent cells in a range (2 replies)
  2. Solved: Alternative to RICI notation in formula (6 replies)
  3. Solved: Hyperlink to PDF file gives error 432 (6 replies)
  4. Solved: Search for value in columns and display results of the relevant rows (3 replies)
  5. Solved: How do I create an add in that automatically adds a new menu to the toolbar? (0 replies)
  6. Reading a text file by column in to an array? (4 replies)
  7. Solved: change variable ; from 2000000 to $2,000,000 (3 replies)
  8. Solved: A question about code finding a certain text (3 replies)
  9. Solved: PivotTable Name issue (2 replies)
  10. Solved: VBA and HTML help make them talk. (6 replies)
  11. Copying Values Down or Across (0 replies)
  12. Passing Variable with .OnAction (4 replies)
  13. [SOLVED:] VBA for playing sound effect! (5 replies)
  14. Is it possible to export to html without using save as? (2 replies)
  15. Macro to provide count of results (4 replies)
  16. Excel Dashboard (0 replies)
  17. Solved: Userform ListBox Row selection (2 replies)
  18. Range.Formula for A1-ref.style notation goes wrong (7 replies)
  19. Mailing PDF from EXCEL (1 replies)
  20. search (2 replies)
  21. copy range with cell link (1 replies)
  22. How to Adjust Column Target (3 replies)
  23. Cascading ComboBoxes (0 replies)
  24. Writing data to chart/graph with a variable data range (1 replies)
  25. Macro/VBA find/copy/paste question (1 replies)
  26. Importing text file - (0 replies)
  27. Looping copy and paste macro (16 replies)
  28. Solved: Dynamic File Path - Code Tweak?! (2 replies)
  29. Solved: Calculate Number of pages (2 replies)
  30. Solved: Time Difference between two dates (1 replies)
  31. Open file with datestamp in filename (3 replies)
  32. Combine all sheets to Master sheet (6 replies)
  33. Copy the data of one cell to three Rows in excel sheet (2 replies)
  34. Creating a Simple Array (7 replies)
  35. Copy & paste based on value after stripping characters (0 replies)
  36. Solved: How to use str? (2 replies)
  37. Sort 2 Columns Code Needed (3 replies)
  38. Solved: Using one Calendar in multiple userform textboxes (3 replies)
  39. Solved: filter (4 replies)
  40. Sending Multiple Emails via VBA (2 replies)
  41. Change days each time (16 replies)
  42. Solved: Help with Find function VBA (2 replies)
  43. how to find the value and replace with diff value (7 replies)
  44. VBA macro simple adjust (4 replies)
  45. Solved: Using Select Case (10 replies)
  46. userform displaying table data (1 replies)
  47. How to loop a date (3 replies)
  48. Performing calculations using VBA (2 replies)
  49. Sleeper: Displaying a UDF within insertFunction (6 replies)
  50. VBA Lookup (6 replies)
  51. How do I add the red triangle in the right hand corner in Excel? (1 replies)
  52. Working with vba in two excel workbooks (5 replies)
  53. use if else loop (7 replies)
  54. search value in entire wb - only fixing code (4 replies)
  55. Solved: How do you convert negative number to positive? (3 replies)
  56. Solved: How to use replace function in VBA? (4 replies)
  57. Find a word (4 replies)
  58. Solved: Msg Box code for a RANGE (7 replies)
  59. Solved: Auto text-ellipse macro. Is it possible? (6 replies)
  60. Naming sheets in "Combine All Workbooks from One Folder Skipping Blank Sheets" (7 replies)
  61. Hide Workbook Title Bar (3 replies)
  62. combine a single sheet in 100 workbooks to another workbook and then summarize (2 replies)
  63. [SOLVED:] Using Range Names with a multiple IF Formula (4 replies)
  64. [SOLVED:] macro to convert all word files to excel from a folder (2 replies)
  65. Solved: loop help please and thank you! (6 replies)
  66. copy data from other sheets into another sheet (0 replies)
  67. pdf price lists to excel (0 replies)
  68. Solved: Self Destruct file (1 replies)
  69. Solved: Export from Word form to Excel (10 replies)
  70. Filter Pivot table by Month & Year (1 replies)
  71. Using Macro to Add Code (3 replies)
  72. Unable to record (2 replies)
  73. Protect workbook, save and close (6 replies)
  74. rc (1 replies)
  75. Auto Email (4 replies)
  76. Solved: Track Changes in Excel Feature (1 replies)
  77. Open csv file using VBA (2 replies)
  78. Printing solution request (0 replies)
  79. Solved: Count number of files in a folder (2 replies)
  80. Creating a TOC for only visible tabs? Excel VBA (5 replies)
  81. Solved: DropDown Question (5 replies)
  82. test of CF (17 replies)
  83. Solved: vb conditional formatting (6 replies)
  84. Solved: Another Query question (8 replies)
  85. Mesage box - Conditional formating (1 replies)
  86. Run process at set time (2 replies)
  87. [SOLVED:] To get specific part of filename from a folder (5 replies)
  88. Solved: Having trouble with "Offset" or the equivilent (3 replies)
  89. Random (18 replies)
  90. explanation (1 replies)
  91. Solved: Count according to date (2 replies)
  92. Conditional formating (1 replies)
  93. copy filter cells (2 replies)
  94. Record Formula Evaluation Steps (0 replies)
  95. Print_Area Formula (11 replies)
  96. trouble with .Resize (5 replies)
  97. One message box in a for loop (3 replies)
  98. Solved: To Auto Populate Value (10 replies)
  99. CALCULATE (14 replies)
  100. Automatically split a large text file in separate worksheets on import (24 replies)
  101. Solved: to extend the coloring (11 replies)
  102. copy data (3 replies)
  103. trigger proc. with a date (2 replies)
  104. Microsoft Speech Object Library (1 replies)
  105. Solved: KB entry "Reduce Excel File Size "give run time error 1004 (17 replies)
  106. Button to interrupt subroutine (6 replies)
  107. Sending email without using outlook (1 replies)
  108. Changing default field "All" in pivot table (0 replies)
  109. [SOLVED:] Ribbon management in Excel-2007 (8 replies)
  110. Solved: Calculate age from row eleven (2 replies)
  111. Solved: how can i add "count" and "Sum" in existing code (4 replies)
  112. [SOLVED:] Excel 2010-Run VBA code pressing a sheet button (6 replies)
  113. VBA: embedded excel chart (0 replies)
  114. Solved: Copy text from shapes (7 replies)
  115. Solved: Skip blank cells (8 replies)
  116. Converting manual chart to bar chart? (0 replies)
  117. Bar chart help any example or sample file ? (0 replies)
  118. Extract text from multiple text files (22 replies)
  119. Dynamically allowing/disallowing user sheet insert. (1 replies)
  120. Parse Text (7 replies)
  121. Mesage box in VBA (6 replies)
  122. Need help with delete (13 replies)
  123. Save file as excel through xl macro from web- in existing code (1 replies)
  124. Filtering using a listbox across multiple columns (17 replies)
  125. Solved: Custom Classes and Collections (4 replies)
  126. Solved: Web Query...creating data crawler (1 replies)
  127. Solved: Delete multiple rows & Unhide hidden rows (6 replies)
  128. How to Delete Visible Rows in VBA? (4 replies)
  129. Solved: Splitting data from one column into multiple columns in excel (9 replies)
  130. Solved: Multiple logical tests (11 replies)
  131. Solved: log only once per 5 sec. - only fix code (6 replies)
  132. Default Messages (3 replies)
  133. Prevent Worksheet Deletion (2 replies)
  134. Oorang: A query about your GUID program (2 replies)
  135. How to Save File & Overwrite Original?? (2 replies)
  136. Subscript out of range for importing files (1 replies)
  137. Solved: Vba Automate Emailer for Lotus 6.5.3 (0 replies)
  138. Solved: Conditional Numbering (2 replies)
  139. VBA Macro - Automating Web Querie (0 replies)
  140. Pulling Information from a String (6 replies)
  141. Solved: Rename "Microsoft Excel Objects" (6 replies)
  142. [SOLVED:] Daylight savings time (2 replies)
  143. Extract Data from Outlook and populate it into Excel (6 replies)
  144. Not sure if possible..brackets issue (16 replies)
  145. [SLEEPER:] Inserting Flash in Office2007 (3 replies)
  146. Automatic Directory File List (15 replies)
  147. Solved: Excel 2003 end(xlup) problem (8 replies)
  148. VBA Code for pivot table from multiple worksheet (0 replies)
  149. Beginner (6 replies)
  150. VBA If statements Variable help! (3 replies)
  151. Count Half of the Visible Rows (8 replies)
  152. [SOLVED:] Automate Chart with filtered values (9 replies)
  153. [SOLVED:] Performing a Successive Filter (4 replies)
  154. Column counting and Loop (2 replies)
  155. Solved: Is there a shorter way to write my VBA code? (7 replies)
  156. Need Help for WEB PAGE TextBox (2 replies)
  157. ask permission (3 replies)
  158. [SOLVED:] Tracking Comments (3 replies)
  159. Solved: How can I have a nested IF-function combined with an OR and AND-fun (5 replies)
  160. Solved: Turning ScreenUpdating On and Off (4 replies)
  161. Click Event (6 replies)
  162. Solved: Matching 2 customer record sheets (25 replies)
  163. Read fr Open File > if not open > open file > and read cells (4 replies)
  164. Resize JPG files to consistent size (5 replies)
  165. RefEdit control to clear contents (14 replies)
  166. Get MS Word ActiveX Control values from Excel VBA (10 replies)
  167. Solved: Run Macro on Specified File and Worksheet (10 replies)
  168. Solved: Separated tables in one page (6 replies)
  169. Solved: Find Text Position (9 replies)
  170. Nested Loops-In What Sequence? (2 replies)
  171. Workbook to track changes in other workbooks (0 replies)
  172. formula/code cleanup (1 replies)
  173. Conditional Drop-Down lists + auto filling (5 replies)
  174. Create Pivot table from multiple worksheet (4 replies)
  175. Protected Sheet Allows Macro to Execute (7 replies)
  176. Looping Ranges (1 replies)
  177. Entering cell comments using VBA (5 replies)
  178. Help with a couple lines of code please... (8 replies)
  179. [SOLVED:] Using InputBox to select Range (2 replies)
  180. Filter Rows with Duplicate values. (14 replies)
  181. Macro to Group columns on the basis of criteria (1 replies)
  182. Solved: email from within excel using outlook (9 replies)
  183. Wildcard character for VBA (2 replies)
  184. Dynamic hyperlink that can survive sorting (0 replies)
  185. [SOLVED:] Working with CutCopyPaste Mode (2 replies)
  186. Method to merge two excel files without links (1 replies)
  187. Macro to save file with active cell value with 3 date options (10 replies)
  188. Solved: Macro for printing (6 replies)
  189. XP Visual Styles to Excel UserForm (0 replies)
  190. Form Button Font Keeps getting smaller (2 replies)
  191. Solved: Looping with textboxes (2 replies)
  192. Solved: Open and Close File (6 replies)
  193. [SOLVED:] Prevent Function calls in worksheet when running macro (8 replies)
  194. Solved: Help with Objects in a Collection (3 replies)
  195. Group Variables together (5 replies)
  196. How do you create a VBA formula code based on Filename? (5 replies)
  197. copy selected cell with links (1 replies)
  198. Unloading User Forms (5 replies)
  199. Help with Variables in Ranges (3 replies)
  200. Sub Returning Workbook (2 replies)
  201. Solved: Scanning Program that converts document to excel (4 replies)
  202. Solved: Extract distinct list from a range (11 replies)
  203. Copying to multiple workbook coding.. (5 replies)
  204. Open a workbook with a long file path (6 replies)
  205. How do I put Msgbox in between formulas in VBA? (12 replies)
  206. Transfering data from UserForm to specific cell (7 replies)
  207. WebBrowser Control with Animated Gif (0 replies)
  208. Making graphs in loop (2 replies)
  209. Solved: Clicking CANCEL After Executing a Command (6 replies)
  210. Solved: copy defined rows (5 replies)
  211. Solved: Disjointed Information to Table (Solved) (2 replies)
  212. Solved: Add ListBox item if item exist just once... (3 replies)
  213. Sleeper: Using VBA to move the mouse to a specific coordinate and left click? (3 replies)
  214. Solved: Test for Existence of Toolbar (4 replies)
  215. From Excel to XML via VBA (2 replies)
  216. FORMULA FOR REPORT IN EXCEL (5 replies)
  217. Solved: VBA Web Query to google finance/reuters (21 replies)
  218. Creating dynamic Range for combobox (7 replies)
  219. Move multiple sheets from multiple files (0 replies)
  220. Solved: Convert to Propercase Selectively (9 replies)
  221. Can't Exit Design Mode because 'ControlCommandButton1' cannot be created? (3 replies)
  222. Solved: Remove last 4 rows from a listbox... (3 replies)
  223. Solved: Is there a shortcut for this code? (14 replies)
  224. Paste Data From Excel To Access (0 replies)
  225. Checking existence of a text in SQL database table column. (6 replies)
  226. Solved: Change code to choose .txt file already open (5 replies)
  227. Entering Selected Cell Values in Multiple Textboxes (1 replies)
  228. Excel wants to talk to Access (0 replies)
  229. Macro Help (1 replies)
  230. Solved: Loop OpenText function (8 replies)
  231. How to improve the performance of this code (17 replies)
  232. Solved: Looping through autofilter, copy, paste (1 replies)
  233. help me plz (2 replies)
  234. Solved: Loop through a range and hide active Column (2 replies)
  235. Solved: caclulating birthday in a userform (5 replies)
  236. Solved: moving array to worksheet (1 replies)
  237. Populate List Box in Excel with visible rows when worksheet gets filtered (10 replies)
  238. Solved: Lookup Help (10 replies)
  239. Solved: OpenText Method: Excel remembers Last Import! (17 replies)
  240. Highlighting Duplicate numbers in excel only when they are next to each other (2 replies)
  241. Sleeper: Collection Class - Item Method (1 replies)
  242. Solved: A list of distinct values (8 replies)
  243. Solved: listbox items as variables (3 replies)
  244. Solved: Please help tech wizards! (6 replies)
  245. Macro To Merge Data from Different worksheets (4 replies)
  246. Solved: Pulling Value Only (not equations) (13 replies)
  247. counting results from searchareas. (1 replies)
  248. Solved: How to add new range in the VBA (4 replies)
  249. Solved: Copy data from 1 workbook into another (6 replies)
  250. Solved: Method "FileSearch" Problem (10 replies)