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. Working with Multiple Appls Simultaneously (4 replies)
  2. Add week ending date to newly created and renamed sheet? (3 replies)
  3. Format display in the comboBox (16 replies)
  4. Solved: Looping through Columns (3 replies)
  5. Make decisions (6 replies)
  6. How to obtain properties of graphical "line" (1 replies)
  7. Solved: Copy Cell Values from Non-adjacent columns (4 replies)
  8. creating graphs from vba form (17 replies)
  9. Error Checking (3 replies)
  10. Blink Control (5 replies)
  11. charting with vba (3 replies)
  12. Macro replacing text in each row by column (3 replies)
  13. Extracting Unique Values from a Column (4 replies)
  14. Running macro periodically (11 replies)
  15. Formula for cell value (11 replies)
  16. create moviedatabase, search IMDB.com (5 replies)
  17. Solved: Workbook_Open view in 100% zoom (25 replies)
  18. Reposting as original attachment was corrupt (3 replies)
  19. Solved: getting the file not found error (3 replies)
  20. Solved: Incrementing to next record (2 replies)
  21. Solved: Preventing a user from saving a file as a different name. (6 replies)
  22. find data from one workbook to another workbook (2 replies)
  23. [SOLVED:] Save location (4 replies)
  24. Reading Word files and search for key words (0 replies)
  25. Text to Columns question (2 replies)
  26. Solved: Hide Buttons in code? (3 replies)
  27. Flow chart (7 replies)
  28. Solved: Index / Match Multiple Criteria Issue (4 replies)
  29. Tidying up the code and adding functionality (0 replies)
  30. Flashing Cell (5 replies)
  31. 2 different color at the same cell? (6 replies)
  32. Solved: Top 3 highest values in range (5 replies)
  33. Macro to ask to find file (4 replies)
  34. [SOLVED:] Incorporating a version number (incremental) in filename (4 replies)
  35. Solved: Help with macro (4 replies)
  36. Solved: Last used cell (12 replies)
  37. Solved: Fill down formula (11 replies)
  38. making define name ranges to work for other worksheets (1 replies)
  39. nested If statement (12 replies)
  40. writting sum function in VBA (2 replies)
  41. Close out without saving (6 replies)
  42. COUNTIF for more than 1 thing on the same formula (5 replies)
  43. Solved: List box items selected but wrong message (2 replies)
  44. Macro to generate random number then User needs to guess that value (18 replies)
  45. Solved: Count tabs in Workbook (6 replies)
  46. Solved: Remove commas and spaces in the middle of a string (2 replies)
  47. Show running time of macro (4 replies)
  48. Filling Mandatory Cells in Excel (9 replies)
  49. VBA macro code to find last worked row or column (7 replies)
  50. Open multiple files as workbooks (2 replies)
  51. Listbox RowSource Requires Range or String (7 replies)
  52. Solved: Tool allocation forecast with multiple IF statements (6 replies)
  53. cannot createobject using "internetexplorer.application" (3 replies)
  54. Solved: Mousemove event with shape (3 replies)
  55. Solved: VBA - Get Range of a Range ??? How? (2 replies)
  56. Solved: range question (8 replies)
  57. Solved: How to Format Font in Middle of String? (8 replies)
  58. Solved: CountIF based on logical operators (1 replies)
  59. Solved: file generation + naming from a variable (3 replies)
  60. Solved: How to get a URL address from the cell value (7 replies)
  61. Sleeper: Copy data to new sheet to remove duplicates (3 replies)
  62. Convert data for Pivot Table (4 replies)
  63. Solved: Using String in a cell as reference for a cell (2 replies)
  64. Solved: Hide Columns Form (2 replies)
  65. Attaching Objects Code (1 replies)
  66. Solved: Get average table for each month in Column L (2 replies)
  67. Solved: Highlight the entire row on click (14 replies)
  68. Solved: Sorting by month of year (11 replies)
  69. Update macro to add tan border as shown in worksheet example (1 replies)
  70. Solved: Set Worksheet Name and Locate Range Info (7 replies)
  71. [SOLVED:] Ungrouping all Row and Column ranges in workbook (20 replies)
  72. Control Treeview (4 replies)
  73. Solved: Enter password as ***** (2 replies)
  74. ADODB, SQL, INSERT - force the type of inserted data (0 replies)
  75. Solved: Run Time Error 13 & Format Func in userform (6 replies)
  76. A sound on conditional formatting (3 replies)
  77. Advanced Filter Creating Named Range? (4 replies)
  78. Solved: Problem with Date Format (4 replies)
  79. Solved: Help in finishing the code (1 replies)
  80. Query data from two databases (2 replies)
  81. insert data in dialog box... (2 replies)
  82. Solved: How to Rename a Defined Name (1 replies)
  83. Solved: Extracting specific data (6 replies)
  84. Permutation two (4 replies)
  85. Solved: How to Identify Worksheet Name for Each Range (11 replies)
  86. Loop thru range, find and copy data to matching sheets (1 replies)
  87. excel programming issues (8 replies)
  88. Show user form (4 replies)
  89. Solved: VLOOKUP resuts (3 replies)
  90. code tweaking (1 replies)
  91. Solved: MenuMaker - disabling menu items (4 replies)
  92. Solved: Use textbox to display data related to the child node (6 replies)
  93. Solved: Filter Combo Box Value (4 replies)
  94. Solved: past due report (1 replies)
  95. Solved: Refer to Range Names on Different Worksheets (6 replies)
  96. Solved: Scrollbar Control Reverse counting (3 replies)
  97. Solved: Removing All Duplicates (8 replies)
  98. Userform as a variable and moving data (7 replies)
  99. Solved: Using Treeview Control (7 replies)
  100. detele unnecessary rows (8 replies)
  101. Solved: Advance Filter & Last Rows Sum (9 replies)
  102. Solved: Use a variable to reference a control? (11 replies)
  103. Solved: Reverse code on a macro (4 replies)
  104. Solved: copy data in sheet1 and paste in sheet2 (7 replies)
  105. Code to install addin feature (3 replies)
  106. Solved: Check contents of cells in header row (7 replies)
  107. Solved: Search Form Help (4 replies)
  108. Do While Loop Help (9 replies)
  109. creating a chart using VBA (3 replies)
  110. How to plot on a image file embedded in excel (0 replies)
  111. [SOLVED:] To edit data using UserForm (2 replies)
  112. Solved: Extract info of a point on a chart (2 replies)
  113. Un-wanted audio alert (3 replies)
  114. Append File Names to an Existing List of File Names (5 replies)
  115. problem with filter condition (2 replies)
  116. Display HTML code in Form textbox (2 replies)
  117. userform review function (2 replies)
  118. [HELP] Charts.Add and Range (3 replies)
  119. Check if a Dynamic Array has been ReDim'ed... (1 replies)
  120. Solved: Process checklist (5 replies)
  121. Solved: Floating listbox to navigate within a single worksheet (3 replies)
  122. Solved: Formula in VBA code - modification requested to avoid Error (7 replies)
  123. Select last 30 cells (2 replies)
  124. Solved: Match function (5 replies)
  125. Clear constants in a selection (3 replies)
  126. compile error (1 replies)
  127. workbook_open: simple question (3 replies)
  128. worksheets order + protection (2 replies)
  129. Solved: The use of [] brackets for assigning values or arrays (5 replies)
  130. How to check the data column and empty column??? (3 replies)
  131. Solved: How to loop through the columns??? (2 replies)
  132. Solved: Using For Loop to get info from Text box (3 replies)
  133. determining user domain account (AD) from VBA (2 replies)
  134. Solved: Edit MP3 tags in Excel / VBA (2 replies)
  135. Conting consective cells based on criteria (1 replies)
  136. Solved: send sheet (2 replies)
  137. Solved: Check and copy rows (11 replies)
  138. Cell Formatting (1 replies)
  139. Compare Sheet1 and Sheet2 Results in Sheet3 (2 replies)
  140. Solved: autofilter question (3 replies)
  141. insert comments from countif (7 replies)
  142. [SLEEPER:] Copying Data to Specific Tab (13 replies)
  143. Workbooks.Open using network path (6 replies)
  144. Alignment of new data and add boarders (3 replies)
  145. Solved: Charting Macro Problem (5 replies)
  146. Save File Without Showing Window (2 replies)
  147. Solved: Matching (21 replies)
  148. Looping/Copying/Other (1 replies)
  149. Showing Formula with values in other language (36 replies)
  150. DRJ's conditional formatting (11 replies)
  151. Solved: Replacing Text (4 replies)
  152. Solved: If cell = "" then highlight cell (21 replies)
  153. removing 0's macro based on columns (1 replies)
  154. Ideas to speeds up PivotTable VBA (2 replies)
  155. 2nd Userform amend posted worksheet to not show UFC Column B (1 replies)
  156. Solved: Sumproduct (Formula not working correctly) (2 replies)
  157. Subtotal calculation using Macro (1 replies)
  158. Solved: move records (5 replies)
  159. Solved: Password Protecting particular rows in excel (11 replies)
  160. Solved: trying to import csv in macro from web. (5 replies)
  161. Trying to call access functions in excel (3 replies)
  162. Disable 'Save' and 'Save As' dialogs (15 replies)
  163. Validating an entry against a database (3 replies)
  164. How to disable the selection of Workbook (5 replies)
  165. Solved: Validating a textbox (1 replies)
  166. [SLEEPER:] Write To Web Page (1 replies)
  167. Copy a sheet from all workbooks in a folder (4 replies)
  168. Solved: Copy a file to the users desktop (3 replies)
  169. Excel (2 replies)
  170. Solved: How to make the mouse Scroll locked (2 replies)
  171. macroto recreate fucntion of grey ADD/REMOVE button onto blue ADD/remove button (0 replies)
  172. Grabbing the cell value before it is changed (or on cell selection) (3 replies)
  173. Solved: Merging two columns as a unique column (11 replies)
  174. Datediff in vba (4 replies)
  175. Refresh Data (1 replies)
  176. need help protecting source code.. (10 replies)
  177. Solved: Problem in auto loading toolpak add-in (6 replies)
  178. Data Extraction (3 replies)
  179. Merge all unique values into one in a required column (14 replies)
  180. Format Msgbox (1 replies)
  181. Finding Unique ID Number & Fill the Cells (19 replies)
  182. Formula help for counting indexed cells? (7 replies)
  183. Extract certain data from file. (1 replies)
  184. Challenging Macro to reverse the function of an existing macro (2 replies)
  185. Solved: Find Empty column (3 replies)
  186. How to hide the workbook while exeuting macro? (6 replies)
  187. Undo option (6 replies)
  188. Code to match two sheets and display differences (3 replies)
  189. Solved: VBA help... Gaining access to training or information (6 replies)
  190. Solved: Mandatory fields (9 replies)
  191. Solved: Tricky formula help? (4 replies)
  192. Solved: Macro can only be executed if specific cells are selected (21 replies)
  193. Solved: If value in a row = value in another column store in another cell (3 replies)
  194. Set trial time limit on workbook? (10 replies)
  195. Solved: How to insert values in rows through for loop (2 replies)
  196. [SOLVED:] How find the empty column immediately after the data column??? (6 replies)
  197. Test if vba password is set. (2 replies)
  198. [SOLVED:] Disable 'Save As' dialog (4 replies)
  199. Solved: combine mulitple columns (5 replies)
  200. Solved: Matching two sheets help needed (6 replies)
  201. Solved: DTPicker1 in Userform help (6 replies)
  202. Solved: Painfully slow Copy & Paste from Web onto a sheet. (4 replies)
  203. Solved: Condition with StatusBar based on Row number (4 replies)
  204. Solved: Code to automatically enter data update date (6 replies)
  205. Solved: Macro hangs and need an extra step add to the macro (12 replies)
  206. remove corrupt excel names - programmatically? (8 replies)
  207. Solved: Getting 2 pieces of data from one source (cell) (12 replies)
  208. Solved: VBA VLOOKUP error (2 replies)
  209. Solved: how to skip no dates data in chart (2 replies)
  210. Solved: Sheet name in formula instead of caption (15 replies)
  211. Solved: Conditional Print Preview (9 replies)
  212. Solved: VBA Hyperlink from a Cell ? (4 replies)
  213. Solved: A function as a variable? Pass function as parameter? function pointer? (5 replies)
  214. Grouping Cells + Printing (2 replies)
  215. Solved: selecting and copying a range where a variable is found (5 replies)
  216. Range assignment in chart (1 replies)
  217. Solved: Add a extra step to current macro button (6 replies)
  218. Copy between Excel applications (7 replies)
  219. Solved: non-modal userform to reflect values with Worksheet_SelectionChange (7 replies)
  220. Problems grabbing hrefs in HTML docs (2 replies)
  221. Swapping multiple cells accross a row (11 replies)
  222. Solved: Dollar symbol in formula (5 replies)
  223. Solved: eliminating blank spaces inside string (2 replies)
  224. Problems with calculating hours worked (11 replies)
  225. Solved: Trying to work out which userform has been opened (4 replies)
  226. Combobox Selection Problem (7 replies)
  227. Autorun externally held macro without opening external file (3 replies)
  228. Data Validation: Listbox (4 replies)
  229. How to do Unit testing in Excel as part of Test Driven Development? (2 replies)
  230. Solved: how to use variables with rows selection (3 replies)
  231. Print selected rows to labels (4 replies)
  232. compare records (6 replies)
  233. Solved: Print information from rows (2 replies)
  234. Excel bug? (5 replies)
  235. saving changes to xlt doc (1 replies)
  236. Error when deleting (1 replies)
  237. View/Print Non-empty columns only (3 replies)
  238. Multiformat Lookup (3 replies)
  239. UserForm (11 replies)
  240. Solved: Copy format Range into another Range (4 replies)
  241. Solved: Filtering Pivot Items by value (4 replies)
  242. Permutation with a handicap (5 replies)
  243. To show multiple contacts pick one (2 replies)
  244. change the defined name range names to correspond to workbook (book1.xls) - (1 replies)
  245. Combobox.value reference (8 replies)
  246. Solved: Glitch in Macro (16 replies)
  247. Improuvement af this macros (1 replies)
  248. Unknown Symbols keep appearing!! (4 replies)
  249. Accessing Web page from Excel (1 replies)
  250. Transpose Row into Combobox (7 replies)