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. Conditional locking of row (13 replies)
  2. Playing with arrays... sort of (13 replies)
  3. Formulas (6 replies)
  4. Solved: Intersect (10 replies)
  5. Excel 2007 Macro Recorded (3 replies)
  6. Download from Excel via URLDownloadToFile (4 replies)
  7. Solved: Listening to the active sheet's events from the personal macro (2 replies)
  8. Delete named Sheets if they exist (4 replies)
  9. Solved: how does xlMultiply work? and can i paste and multipy in one go? (4 replies)
  10. Sum months plus today (1 replies)
  11. Help With automatically reading a column (2 replies)
  12. Solved: Reading a .csv File? (4 replies)
  13. Solved: ActiveCell.FormulaR1C1 dynamic column (2 replies)
  14. Solved: Userform & Class Module Interaction (4 replies)
  15. Solved: xlCellType (6 replies)
  16. Solved: finding MAX number and matching symbol (3 replies)
  17. Problems with foreach loop in a modul (2 replies)
  18. translating math formula into vba (19 replies)
  19. [SOLVED:] Aligning data labels in a chart (8 replies)
  20. [SOLVED:] Working with a text file (5 replies)
  21. Solved: how to paste only value since there r some fuction in cells (2 replies)
  22. Solved: inserting date where cursor located (9 replies)
  23. Solved: Calling a Function and Resize (2 replies)
  24. Question on insert Object (1 replies)
  25. Return Row info based on Column dates (12 replies)
  26. Solved: load a one dimensional array from non-contiguo (2 replies)
  27. Sleeper: Can I run an executable within my VBA? (1 replies)
  28. Solved: Count Business Days Between 2 Dates (7 replies)
  29. Solved: Alignment on coding page (3 replies)
  30. Solved: Find,MatchCase PROBLEM (2 replies)
  31. Way to get innertext of all childnodes of a node? (0 replies)
  32. Color Banding Rows (2 replies)
  33. Using Custom Views (0 replies)
  34. Solved: Formula help (32 replies)
  35. Assigning a cell to a row that has a cell with a similar value (1 replies)
  36. Solved: Date picker 2003 (2 replies)
  37. Solved: If else doesn't work the way I expected (2 replies)
  38. Save Excel Userform as a Web Page (0 replies)
  39. Dynamic Formula put in formula with VBA (3 replies)
  40. Excel 2007-UPDATE Links ISSUE with excel 2003 file (0 replies)
  41. Changing AutoFilter Range (7 replies)
  42. Is it possible to ask vba to write html code in to an html file? (18 replies)
  43. Creating sub-blocks within a large data-block (5 replies)
  44. delete duplicate text (1 replies)
  45. Multiselection areas: how to manage? (3 replies)
  46. Solved: Scroll worksheet when userform is present (2 replies)
  47. Need help on VBA coding.... (5 replies)
  48. picking range from "A1" to variable (1 replies)
  49. Userform Activate not firing in Excel 97 (5 replies)
  50. Pick a Workbook and mail its worksheets (4 replies)
  51. Solved: Error on Insert Picture code... (10 replies)
  52. Solved: On open excel (9 replies)
  53. How to Modify Userform? (4 replies)
  54. Macro to return picture in a cell? (1 replies)
  55. Remove duplication and fill a form (0 replies)
  56. Using arrays in vba excell (1 replies)
  57. Solved: Calling a Function, of Sorts (14 replies)
  58. Extract Data to Excel from a Website. (2 replies)
  59. Solved: label caption (2 replies)
  60. Loop but Subscript out of Range (8 replies)
  61. Solved: Copying comments from one workbook to another (2 replies)
  62. Pivot Table Show All (4 replies)
  63. Solved: Save chart as image plus refresh (3 replies)
  64. VBA code to open an Excel workbook readonly (5 replies)
  65. Formating lines in table/pivot table (3 replies)
  66. Average of n elements in an array (5 replies)
  67. Pulling data according to a cell value (1 replies)
  68. Not sure what to do. (4 replies)
  69. copy cells from excel table into a pre-formatted table in word (2 replies)
  70. Solved: copy the formula or address (2 replies)
  71. Auto Import Text file GetOpenFilename no dialog (1 replies)
  72. Userform Search help! (4 replies)
  73. Display label results in a texbox (6 replies)
  74. manage datas from a multilection rows (5 replies)
  75. gif animated picture on a user form !!! (2 replies)
  76. Solved: Removing Noncontiguous DropDown Arrows (2 replies)
  77. Solved: Dir Function - Sequential files (3 replies)
  78. Solved: Compare two sheets semi-manually (0 replies)
  79. Solved: Escape from Edit Mode (2 replies)
  80. Solved: Help Identifying Empty Cells (2 replies)
  81. Solved: Copy Paste non-adjacent cells in a range (2 replies)
  82. Solved: Alternative to RICI notation in formula (6 replies)
  83. Solved: Hyperlink to PDF file gives error 432 (6 replies)
  84. Solved: Search for value in columns and display results of the relevant rows (3 replies)
  85. Solved: How do I create an add in that automatically adds a new menu to the toolbar? (0 replies)
  86. Reading a text file by column in to an array? (4 replies)
  87. Solved: change variable ; from 2000000 to $2,000,000 (3 replies)
  88. Solved: A question about code finding a certain text (3 replies)
  89. Solved: PivotTable Name issue (2 replies)
  90. Solved: VBA and HTML help make them talk. (6 replies)
  91. Copying Values Down or Across (0 replies)
  92. Passing Variable with .OnAction (4 replies)
  93. [SOLVED:] VBA for playing sound effect! (5 replies)
  94. Is it possible to export to html without using save as? (2 replies)
  95. Macro to provide count of results (4 replies)
  96. Excel Dashboard (0 replies)
  97. Solved: Userform ListBox Row selection (2 replies)
  98. Range.Formula for A1-ref.style notation goes wrong (7 replies)
  99. Mailing PDF from EXCEL (1 replies)
  100. search (2 replies)
  101. copy range with cell link (1 replies)
  102. How to Adjust Column Target (3 replies)
  103. Cascading ComboBoxes (0 replies)
  104. Writing data to chart/graph with a variable data range (1 replies)
  105. Macro/VBA find/copy/paste question (1 replies)
  106. Importing text file - (0 replies)
  107. Looping copy and paste macro (16 replies)
  108. Solved: Dynamic File Path - Code Tweak?! (2 replies)
  109. Solved: Calculate Number of pages (2 replies)
  110. Solved: Time Difference between two dates (1 replies)
  111. Open file with datestamp in filename (3 replies)
  112. Combine all sheets to Master sheet (6 replies)
  113. Copy the data of one cell to three Rows in excel sheet (2 replies)
  114. Creating a Simple Array (7 replies)
  115. Copy & paste based on value after stripping characters (0 replies)
  116. Solved: How to use str? (2 replies)
  117. Sort 2 Columns Code Needed (3 replies)
  118. Solved: Using one Calendar in multiple userform textboxes (3 replies)
  119. Solved: filter (4 replies)
  120. Sending Multiple Emails via VBA (2 replies)
  121. Change days each time (16 replies)
  122. Solved: Help with Find function VBA (2 replies)
  123. how to find the value and replace with diff value (7 replies)
  124. VBA macro simple adjust (4 replies)
  125. Solved: Using Select Case (10 replies)
  126. userform displaying table data (1 replies)
  127. How to loop a date (3 replies)
  128. Performing calculations using VBA (2 replies)
  129. Sleeper: Displaying a UDF within insertFunction (6 replies)
  130. VBA Lookup (6 replies)
  131. How do I add the red triangle in the right hand corner in Excel? (1 replies)
  132. Working with vba in two excel workbooks (5 replies)
  133. use if else loop (7 replies)
  134. search value in entire wb - only fixing code (4 replies)
  135. [SOLVED:] How do you convert negative number to positive? (3 replies)
  136. Solved: How to use replace function in VBA? (4 replies)
  137. Find a word (4 replies)
  138. Solved: Msg Box code for a RANGE (7 replies)
  139. Solved: Auto text-ellipse macro. Is it possible? (6 replies)
  140. Naming sheets in "Combine All Workbooks from One Folder Skipping Blank Sheets" (7 replies)
  141. Hide Workbook Title Bar (3 replies)
  142. combine a single sheet in 100 workbooks to another workbook and then summarize (2 replies)
  143. [SOLVED:] Using Range Names with a multiple IF Formula (4 replies)
  144. [SOLVED:] macro to convert all word files to excel from a folder (2 replies)
  145. Solved: loop help please and thank you! (6 replies)
  146. copy data from other sheets into another sheet (0 replies)
  147. pdf price lists to excel (0 replies)
  148. Solved: Self Destruct file (1 replies)
  149. Solved: Export from Word form to Excel (10 replies)
  150. Filter Pivot table by Month & Year (1 replies)
  151. Using Macro to Add Code (3 replies)
  152. Unable to record (2 replies)
  153. Protect workbook, save and close (6 replies)
  154. rc (1 replies)
  155. Auto Email (4 replies)
  156. Solved: Track Changes in Excel Feature (1 replies)
  157. Open csv file using VBA (2 replies)
  158. Printing solution request (0 replies)
  159. [SOLVED:] Count number of files in a folder (2 replies)
  160. Creating a TOC for only visible tabs? Excel VBA (5 replies)
  161. Solved: DropDown Question (5 replies)
  162. test of CF (17 replies)
  163. Solved: vb conditional formatting (6 replies)
  164. Solved: Another Query question (8 replies)
  165. Mesage box - Conditional formating (1 replies)
  166. Run process at set time (2 replies)
  167. [SOLVED:] To get specific part of filename from a folder (5 replies)
  168. Solved: Having trouble with "Offset" or the equivilent (3 replies)
  169. Random (18 replies)
  170. [SOLVED:] explanation (1 replies)
  171. Solved: Count according to date (2 replies)
  172. Conditional formating (1 replies)
  173. copy filter cells (2 replies)
  174. Record Formula Evaluation Steps (0 replies)
  175. Print_Area Formula (11 replies)
  176. trouble with .Resize (5 replies)
  177. One message box in a for loop (3 replies)
  178. Solved: To Auto Populate Value (10 replies)
  179. CALCULATE (14 replies)
  180. Automatically split a large text file in separate worksheets on import (24 replies)
  181. Solved: to extend the coloring (11 replies)
  182. copy data (3 replies)
  183. trigger proc. with a date (2 replies)
  184. Microsoft Speech Object Library (1 replies)
  185. Solved: KB entry "Reduce Excel File Size "give run time error 1004 (17 replies)
  186. Button to interrupt subroutine (6 replies)
  187. Sending email without using outlook (1 replies)
  188. Changing default field "All" in pivot table (0 replies)
  189. [SOLVED:] Ribbon management in Excel-2007 (8 replies)
  190. Solved: Calculate age from row eleven (2 replies)
  191. Solved: how can i add "count" and "Sum" in existing code (4 replies)
  192. [SOLVED:] Excel 2010-Run VBA code pressing a sheet button (6 replies)
  193. VBA: embedded excel chart (0 replies)
  194. Solved: Copy text from shapes (7 replies)
  195. Solved: Skip blank cells (8 replies)
  196. Converting manual chart to bar chart? (0 replies)
  197. Bar chart help any example or sample file ? (0 replies)
  198. Extract text from multiple text files (22 replies)
  199. Dynamically allowing/disallowing user sheet insert. (1 replies)
  200. Parse Text (7 replies)
  201. Mesage box in VBA (6 replies)
  202. Need help with delete (13 replies)
  203. Save file as excel through xl macro from web- in existing code (1 replies)
  204. [SOLVED:] Filtering using a listbox across multiple columns (17 replies)
  205. Solved: Custom Classes and Collections (4 replies)
  206. Solved: Web Query...creating data crawler (1 replies)
  207. Solved: Delete multiple rows & Unhide hidden rows (6 replies)
  208. How to Delete Visible Rows in VBA? (4 replies)
  209. Solved: Splitting data from one column into multiple columns in excel (9 replies)
  210. Solved: Multiple logical tests (11 replies)
  211. Solved: log only once per 5 sec. - only fix code (6 replies)
  212. Default Messages (3 replies)
  213. Prevent Worksheet Deletion (2 replies)
  214. Oorang: A query about your GUID program (2 replies)
  215. How to Save File & Overwrite Original?? (2 replies)
  216. Subscript out of range for importing files (1 replies)
  217. Solved: Vba Automate Emailer for Lotus 6.5.3 (0 replies)
  218. Solved: Conditional Numbering (2 replies)
  219. VBA Macro - Automating Web Querie (0 replies)
  220. Pulling Information from a String (6 replies)
  221. Solved: Rename "Microsoft Excel Objects" (6 replies)
  222. [SOLVED:] Daylight savings time (2 replies)
  223. Extract Data from Outlook and populate it into Excel (6 replies)
  224. Not sure if possible..brackets issue (16 replies)
  225. [SLEEPER:] Inserting Flash in Office2007 (3 replies)
  226. Automatic Directory File List (15 replies)
  227. Solved: Excel 2003 end(xlup) problem (8 replies)
  228. VBA Code for pivot table from multiple worksheet (0 replies)
  229. Beginner (6 replies)
  230. VBA If statements Variable help! (3 replies)
  231. Count Half of the Visible Rows (8 replies)
  232. [SOLVED:] Automate Chart with filtered values (9 replies)
  233. [SOLVED:] Performing a Successive Filter (4 replies)
  234. Column counting and Loop (2 replies)
  235. Solved: Is there a shorter way to write my VBA code? (7 replies)
  236. Need Help for WEB PAGE TextBox (2 replies)
  237. ask permission (3 replies)
  238. [SOLVED:] Tracking Comments (3 replies)
  239. Solved: How can I have a nested IF-function combined with an OR and AND-fun (5 replies)
  240. Solved: Turning ScreenUpdating On and Off (4 replies)
  241. Click Event (6 replies)
  242. Solved: Matching 2 customer record sheets (25 replies)
  243. Read fr Open File > if not open > open file > and read cells (4 replies)
  244. Resize JPG files to consistent size (5 replies)
  245. RefEdit control to clear contents (14 replies)
  246. Get MS Word ActiveX Control values from Excel VBA (10 replies)
  247. Solved: Run Macro on Specified File and Worksheet (10 replies)
  248. [SOLVED:] Separated tables in one page (6 replies)
  249. Solved: Find Text Position (9 replies)
  250. Nested Loops-In What Sequence? (2 replies)