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. Set trial period for use of your project (0 replies)
  2. Month selection (2 replies)
  3. Tool or editor require for understanding return value of each argument of so many nes (6 replies)
  4. [SOLVED:] Uncheck CheckBoxes if one is checked (7 replies)
  5. Solved: Worksheet Change Event (13 replies)
  6. Copy & Paste Dates with Macro (4 replies)
  7. Solved: index/match (12 replies)
  8. User form will not allow blank fields (4 replies)
  9. Need macro to list folder with name and size in excel. Thanks (6 replies)
  10. Solved: Events (5 replies)
  11. lookup function in VBA (6 replies)
  12. VBA Code to know the date of creating a new worksheet (4 replies)
  13. how to change multiple value instead of one value at a time? (6 replies)
  14. Solved: Filter from Drop Down Box (3 replies)
  15. Solved: Hlookup and Vlookup problem (2 replies)
  16. Stop dialog box popping up (6 replies)
  17. Combo Box / List box help (1 replies)
  18. Solved: could not set the value property. Invalid property value (2 replies)
  19. Excel 2007 macro for comparing multiple dates (3 replies)
  20. Solved: Use Vlookup in VBA Code (4 replies)
  21. Solved: VLOOKUP the Nth Occurance (3 replies)
  22. Grabbing Data..Excel VBA (3 replies)
  23. Is this a timeout issue? (0 replies)
  24. [SOLVED:] Extract a string from a cell (8 replies)
  25. Solved: How to create Yes or No Message Box? (6 replies)
  26. Solved: using name in VBA propertys vs Sheet name (4 replies)
  27. Solved: Selecting a Range of Rows (9 replies)
  28. Search Function in a User Form (2 replies)
  29. Executing Macro at Time with Excel Closed (0 replies)
  30. Solved: Date as an Index (8 replies)
  31. Solved: Removing certain string (2 replies)
  32. Solved: Detecting Conditional Formatting (3 replies)
  33. Solved: Football Team Record Ranking (10 replies)
  34. Help with Syntax Using ADO to Query Excel Worksheet (4 replies)
  35. Solved: Error Handling (2 replies)
  36. Solved: Add 1 when copying and linking. (3 replies)
  37. Multi Select List Box based on Advanced Filter (0 replies)
  38. Solved: Change cell colour if changes made (2 replies)
  39. Divide the Column Data using VBA (11 replies)
  40. vba MultiSelect ListBox based on advanced filter (0 replies)
  41. [SLEEPER:] Use combobox as history (0 replies)
  42. Solved: XY chart with values on top of each other (2 replies)
  43. [SOLVED:] How do you clear filter in macro? (2 replies)
  44. Split The Column Data based on first column values using VBA (1 replies)
  45. adding up interchanging word in a single cell (1 replies)
  46. Sorting While in .FilterMode (0 replies)
  47. [SLEEPER:] VBA Code Problems with Sending Excel DB through Outlook (2 replies)
  48. Solved: How to export bookmarks from word to excel (13 replies)
  49. Solved: Formula to allocate absolute values (9 replies)
  50. Set StartCell as ActiveCell (10 replies)
  51. Solved: Hide unhide rows in range (23 replies)
  52. [SLEEPER:] Use of Ajax in an inputbox? (4 replies)
  53. Solved: Why is this code simply exiting without reason? (6 replies)
  54. Write a value from a cell formula (1 replies)
  55. Solved: Excel VBA (19 replies)
  56. Solved: Delimiting in odd situations... (2 replies)
  57. Solved: Probably a quick solution to this! - finding rows (8 replies)
  58. Extract a list of employees according to month (5 replies)
  59. VBA for multiple excel file (0 replies)
  60. Solved: multiple file selection (5 replies)
  61. Solved: Clear cell contents without deleting formula (4 replies)
  62. Selection (4 replies)
  63. Excel Macro Help (2 replies)
  64. Solved: Using a Date variable in Excel 2007 macro (3 replies)
  65. Can this code be simplified (2 replies)
  66. Solved: Macro Recorder Code fails (12 replies)
  67. Excel to Word... little help required (4 replies)
  68. VBA to copy 3 worksheets and email (0 replies)
  69. VBA Error help please (3 replies)
  70. Conditional locking of row (13 replies)
  71. Playing with arrays... sort of (13 replies)
  72. Formulas (6 replies)
  73. Solved: Intersect (10 replies)
  74. Excel 2007 Macro Recorded (3 replies)
  75. [SLEEPER:] Download from Excel via URLDownloadToFile (4 replies)
  76. Solved: Listening to the active sheet's events from the personal macro (2 replies)
  77. Delete named Sheets if they exist (4 replies)
  78. Solved: how does xlMultiply work? and can i paste and multipy in one go? (4 replies)
  79. Sum months plus today (1 replies)
  80. Help With automatically reading a column (2 replies)
  81. Solved: Reading a .csv File? (4 replies)
  82. Solved: ActiveCell.FormulaR1C1 dynamic column (2 replies)
  83. Solved: Userform & Class Module Interaction (4 replies)
  84. Solved: xlCellType (6 replies)
  85. Solved: finding MAX number and matching symbol (3 replies)
  86. Problems with foreach loop in a modul (2 replies)
  87. translating math formula into vba (19 replies)
  88. [SOLVED:] Aligning data labels in a chart (8 replies)
  89. [SOLVED:] Working with a text file (5 replies)
  90. Solved: how to paste only value since there r some fuction in cells (2 replies)
  91. Solved: inserting date where cursor located (9 replies)
  92. Solved: Calling a Function and Resize (2 replies)
  93. Question on insert Object (1 replies)
  94. Return Row info based on Column dates (12 replies)
  95. Solved: load a one dimensional array from non-contiguo (2 replies)
  96. Sleeper: Can I run an executable within my VBA? (1 replies)
  97. Solved: Count Business Days Between 2 Dates (7 replies)
  98. Solved: Alignment on coding page (3 replies)
  99. Solved: Find,MatchCase PROBLEM (2 replies)
  100. Way to get innertext of all childnodes of a node? (0 replies)
  101. Color Banding Rows (2 replies)
  102. Using Custom Views (0 replies)
  103. Solved: Formula help (32 replies)
  104. Assigning a cell to a row that has a cell with a similar value (1 replies)
  105. Solved: Date picker 2003 (2 replies)
  106. Solved: If else doesn't work the way I expected (2 replies)
  107. Save Excel Userform as a Web Page (0 replies)
  108. Dynamic Formula put in formula with VBA (3 replies)
  109. Excel 2007-UPDATE Links ISSUE with excel 2003 file (0 replies)
  110. Changing AutoFilter Range (7 replies)
  111. [SLEEPER:] Is it possible to ask vba to write html code in to an html file? (18 replies)
  112. Creating sub-blocks within a large data-block (5 replies)
  113. delete duplicate text (1 replies)
  114. Multiselection areas: how to manage? (3 replies)
  115. Solved: Scroll worksheet when userform is present (2 replies)
  116. Need help on VBA coding.... (5 replies)
  117. picking range from "A1" to variable (1 replies)
  118. Userform Activate not firing in Excel 97 (5 replies)
  119. Pick a Workbook and mail its worksheets (4 replies)
  120. Solved: Error on Insert Picture code... (10 replies)
  121. [SOLVED:] On open excel (9 replies)
  122. How to Modify Userform? (4 replies)
  123. Macro to return picture in a cell? (1 replies)
  124. Remove duplication and fill a form (0 replies)
  125. Using arrays in vba excell (1 replies)
  126. Solved: Calling a Function, of Sorts (14 replies)
  127. Extract Data to Excel from a Website. (2 replies)
  128. Solved: label caption (2 replies)
  129. Loop but Subscript out of Range (8 replies)
  130. Solved: Copying comments from one workbook to another (2 replies)
  131. Pivot Table Show All (4 replies)
  132. Solved: Save chart as image plus refresh (3 replies)
  133. VBA code to open an Excel workbook readonly (5 replies)
  134. Formating lines in table/pivot table (3 replies)
  135. Average of n elements in an array (5 replies)
  136. Pulling data according to a cell value (1 replies)
  137. Not sure what to do. (4 replies)
  138. copy cells from excel table into a pre-formatted table in word (2 replies)
  139. Solved: copy the formula or address (2 replies)
  140. Auto Import Text file GetOpenFilename no dialog (1 replies)
  141. Userform Search help! (4 replies)
  142. Display label results in a texbox (6 replies)
  143. manage datas from a multilection rows (5 replies)
  144. gif animated picture on a user form !!! (2 replies)
  145. Solved: Removing Noncontiguous DropDown Arrows (2 replies)
  146. Solved: Dir Function - Sequential files (3 replies)
  147. Solved: Compare two sheets semi-manually (0 replies)
  148. Solved: Escape from Edit Mode (2 replies)
  149. Solved: Help Identifying Empty Cells (2 replies)
  150. Solved: Copy Paste non-adjacent cells in a range (2 replies)
  151. Solved: Alternative to RICI notation in formula (6 replies)
  152. Solved: Hyperlink to PDF file gives error 432 (6 replies)
  153. Solved: Search for value in columns and display results of the relevant rows (3 replies)
  154. Solved: How do I create an add in that automatically adds a new menu to the toolbar? (0 replies)
  155. Reading a text file by column in to an array? (4 replies)
  156. Solved: change variable ; from 2000000 to $2,000,000 (3 replies)
  157. Solved: A question about code finding a certain text (3 replies)
  158. Solved: PivotTable Name issue (2 replies)
  159. Solved: VBA and HTML help make them talk. (6 replies)
  160. Copying Values Down or Across (0 replies)
  161. [SLEEPER:] Passing Variable with .OnAction (4 replies)
  162. [SOLVED:] VBA for playing sound effect! (5 replies)
  163. Is it possible to export to html without using save as? (2 replies)
  164. Macro to provide count of results (4 replies)
  165. Excel Dashboard (0 replies)
  166. Solved: Userform ListBox Row selection (2 replies)
  167. Range.Formula for A1-ref.style notation goes wrong (7 replies)
  168. Mailing PDF from EXCEL (1 replies)
  169. search (2 replies)
  170. copy range with cell link (1 replies)
  171. How to Adjust Column Target (3 replies)
  172. Cascading ComboBoxes (0 replies)
  173. Writing data to chart/graph with a variable data range (1 replies)
  174. Macro/VBA find/copy/paste question (1 replies)
  175. Importing text file - (0 replies)
  176. Looping copy and paste macro (16 replies)
  177. Solved: Dynamic File Path - Code Tweak?! (2 replies)
  178. Solved: Calculate Number of pages (2 replies)
  179. Solved: Time Difference between two dates (1 replies)
  180. Open file with datestamp in filename (3 replies)
  181. Combine all sheets to Master sheet (6 replies)
  182. Copy the data of one cell to three Rows in excel sheet (2 replies)
  183. Creating a Simple Array (7 replies)
  184. Copy & paste based on value after stripping characters (0 replies)
  185. Solved: How to use str? (2 replies)
  186. Sort 2 Columns Code Needed (3 replies)
  187. Solved: Using one Calendar in multiple userform textboxes (3 replies)
  188. Solved: filter (4 replies)
  189. Sending Multiple Emails via VBA (2 replies)
  190. Change days each time (16 replies)
  191. Solved: Help with Find function VBA (2 replies)
  192. how to find the value and replace with diff value (7 replies)
  193. VBA macro simple adjust (4 replies)
  194. Solved: Using Select Case (10 replies)
  195. userform displaying table data (1 replies)
  196. How to loop a date (3 replies)
  197. Performing calculations using VBA (2 replies)
  198. Sleeper: Displaying a UDF within insertFunction (6 replies)
  199. VBA Lookup (6 replies)
  200. How do I add the red triangle in the right hand corner in Excel? (1 replies)
  201. Working with vba in two excel workbooks (5 replies)
  202. use if else loop (7 replies)
  203. search value in entire wb - only fixing code (4 replies)
  204. [SOLVED:] How do you convert negative number to positive? (3 replies)
  205. Solved: How to use replace function in VBA? (4 replies)
  206. [SOLVED:] Find a word (4 replies)
  207. Solved: Msg Box code for a RANGE (7 replies)
  208. Solved: Auto text-ellipse macro. Is it possible? (6 replies)
  209. Naming sheets in "Combine All Workbooks from One Folder Skipping Blank Sheets" (7 replies)
  210. Hide Workbook Title Bar (3 replies)
  211. combine a single sheet in 100 workbooks to another workbook and then summarize (2 replies)
  212. [SOLVED:] Using Range Names with a multiple IF Formula (4 replies)
  213. [SOLVED:] macro to convert all word files to excel from a folder (2 replies)
  214. Solved: loop help please and thank you! (6 replies)
  215. copy data from other sheets into another sheet (0 replies)
  216. pdf price lists to excel (0 replies)
  217. Solved: Self Destruct file (1 replies)
  218. Solved: Export from Word form to Excel (10 replies)
  219. Filter Pivot table by Month & Year (1 replies)
  220. Using Macro to Add Code (3 replies)
  221. Unable to record (2 replies)
  222. Protect workbook, save and close (6 replies)
  223. rc (1 replies)
  224. Auto Email (4 replies)
  225. Solved: Track Changes in Excel Feature (1 replies)
  226. Open csv file using VBA (2 replies)
  227. Printing solution request (0 replies)
  228. [SOLVED:] Count number of files in a folder (2 replies)
  229. Creating a TOC for only visible tabs? Excel VBA (5 replies)
  230. Solved: DropDown Question (5 replies)
  231. test of CF (17 replies)
  232. Solved: vb conditional formatting (6 replies)
  233. Solved: Another Query question (8 replies)
  234. Mesage box - Conditional formating (1 replies)
  235. Run process at set time (2 replies)
  236. [SOLVED:] To get specific part of filename from a folder (5 replies)
  237. Solved: Having trouble with "Offset" or the equivilent (3 replies)
  238. Random (18 replies)
  239. [SOLVED:] explanation (1 replies)
  240. Solved: Count according to date (2 replies)
  241. Conditional formating (1 replies)
  242. copy filter cells (2 replies)
  243. Record Formula Evaluation Steps (0 replies)
  244. Print_Area Formula (11 replies)
  245. trouble with .Resize (5 replies)
  246. One message box in a for loop (3 replies)
  247. Solved: To Auto Populate Value (10 replies)
  248. CALCULATE (14 replies)
  249. Automatically split a large text file in separate worksheets on import (24 replies)
  250. Solved: to extend the coloring (11 replies)