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: Subtracting Totals (2 replies)
  2. Hide Rows and Columns (7 replies)
  3. Solved: Query Data in Excel WorkBook and Return Results in Same Workbook (2 replies)
  4. Solved: TXTbox filter (4 replies)
  5. How do I get full Name into a Variable? (2 replies)
  6. VBA macros used update and transfer data from sql (1 replies)
  7. Solved: Clear Cell Content (4 replies)
  8. Mysterious file growth on sorting (4 replies)
  9. Random numbers in range (5 replies)
  10. Open and Delete all VBA Components -- on locked Files (3 replies)
  11. Mouse-click event (5 replies)
  12. combo box custom rowsource and data on the fly (0 replies)
  13. Speed up the macro-page layout? (5 replies)
  14. Solved: Data Input Restrictions (7 replies)
  15. Using Variable Index with FormulaR1C1 (2 replies)
  16. Static Variable (4 replies)
  17. Solved: compare columns from two sheets (7 replies)
  18. Solved: Saving a Workbook (13 replies)
  19. Solved: Unhide 5 Rows below when entering date Row Above (2 replies)
  20. get data from txt file (3 replies)
  21. Area under curve -Integral Sumproduct? (1 replies)
  22. Solved: Restricting Access to Spreadsheet by Network User Name/ID (16 replies)
  23. Some kind of lookup or macro?? (1 replies)
  24. Sleeper: may be userform (0 replies)
  25. Before send as attachment (1 replies)
  26. Match and copy values from one workbook to another (13 replies)
  27. find selected combobox item's row (2 replies)
  28. run time error '438' - Object doesn't support this property or method (2 replies)
  29. [SOLVED:] MsgBox (2 replies)
  30. Trying to write code in a shorter way (3 replies)
  31. Count of blank values in Pivot table (5 replies)
  32. Filter Column B based on Column A values (1 replies)
  33. Solved: Elseif select case not working (5 replies)
  34. Copy files (9 replies)
  35. Solved: Macro to calculate only in cells filled with blue color (1 replies)
  36. Transfer Form Data To Worksheet (1 replies)
  37. How to create a macro that updates a spreadsheet calculation (4 replies)
  38. What do each of these VLookups mean? (1 replies)
  39. Expected End of Statement (15 replies)
  40. Copy duplicate instead of deleting (3 replies)
  41. Conditional Formatting with a Named Range (3 replies)
  42. Macros that can do automatic calculations with v-lookups on large data sets (1 replies)
  43. Not able to extract text from a webpage (3 replies)
  44. code for printers (2 replies)
  45. extract only specific words/lines from a txt file (12 replies)
  46. Solved: How to trigger macros from Validation List? (3 replies)
  47. Automatically send email (1 replies)
  48. Solved: Call an AddIn - Compile Error (3 replies)
  49. How do I open hyperlinks in a new window? (2 replies)
  50. Adding Records to an Excel table Vba (2 replies)
  51. Setting a Range Equal to an Array (4 replies)
  52. Solved: Count filled cells (17 replies)
  53. Solved: Copy Data from Sheet 1 to sheet 2 with auto (2 replies)
  54. Solved: open all file type (3 replies)
  55. To recover Spreadsheet (1 replies)
  56. Solved: If statement in an Array Formula (13 replies)
  57. Solved: How do you insert Columns using VBA? (2 replies)
  58. Solved: "erroneous" result with IF condition!! (7 replies)
  59. Solved: Set a variable as todays date minus X days. (2 replies)
  60. Solved: Need help with VBA syntax (10 replies)
  61. Solved: Getting macro to work on network and local drive ?? (10 replies)
  62. How to create a scaled down bar chart from a pivot table. Can this be done? (1 replies)
  63. Solved: Excel 2003/07 - I need to Bold two portion's of a string? (2 replies)
  64. Solved: Creating CSV file: double-quote problem (2 replies)
  65. Solved: Excel 2003/07 - Why does using Application.ScreenUpdating not hiding sheet select (1 replies)
  66. Solved: Pause/resume execution (3 replies)
  67. Compile error (9 replies)
  68. Solved: SaveAsUI.... cleanup before close. (4 replies)
  69. Solved: If with an OR or & (5 replies)
  70. excel (9 replies)
  71. Looping a Macro (2 replies)
  72. Solved: Highlight row when a cell within it has been selected and 'un-highlight' when not (3 replies)
  73. Solved: Excel 2003 to 2007 "ENABLE MACROS" (4 replies)
  74. Variable Not Defined (15 replies)
  75. How to save a excel sheet into .txt file using macro (4 replies)
  76. Snake Eyes Program (3 replies)
  77. uncompress a (zlib-compressed) string using ZLib in VBA (3 replies)
  78. Mortgage Application Userform (7 replies)
  79. Solved: Cycling through multiple files in a directory (4 replies)
  80. Solved: Why using Range() works but Cells() doesn't?? (4 replies)
  81. Help to modify: "Combine All Data From All Worksheets in All Workbooks" (mvidas) (1 replies)
  82. Solved: Trying to use Line Input, but only vbLF (6 replies)
  83. Solved: Sumproduct for Months (4 replies)
  84. Checking hyperlinks in excel macro (4 replies)
  85. Solved: LHS and RHS of Comma (1 replies)
  86. Macro Data Input Message (8 replies)
  87. Extract Data under Hyperlinks from a webpage in excel (10 replies)
  88. Solved: read file with marker (3 replies)
  89. could not load an object because it is not available on this machine (3 replies)
  90. Code to move row data to columns (2 replies)
  91. Solved: Search and Attach file to email using VBA (31 replies)
  92. Solved: interactive test in excel 2003 (8 replies)
  93. Solved: VBA modules crash Excel (7 replies)
  94. Solved: How to add comments to a entire column (5 replies)
  95. Solved: Transposing data where some data is in merged cells (8 replies)
  96. Solved: textbox value = cell range (9 replies)
  97. [SOLVED:] Select Sheet Tabs Dynamically (7 replies)
  98. License Key (Or Something Like This) (6 replies)
  99. Web Query & Userforms (5 replies)
  100. Solved: deleting a range based on cell value on another sheet (8 replies)
  101. Storing range object temporarily in code not possible? (5 replies)
  102. Error with sumproduct (7 replies)
  103. Delete empty space at end of row (6 replies)
  104. oldvalue help (3 replies)
  105. Download attachments from outlook folders. (3 replies)
  106. Solved: How to get only specific information from a .txt file using macro (16 replies)
  107. Code Problem Saving Data To Another Workbook (12 replies)
  108. Solved: Finding the last empty column in a row? (3 replies)
  109. Can't figure it out .... Weird Bug!! (4 replies)
  110. Vba Code to filter a Column automatically (8 replies)
  111. [SOLVED:] Updating Functions within a Sub (8 replies)
  112. Solved: Conditional Formatting Via Worksheet Event Code (8 replies)
  113. Block textbox for numbers or text. (7 replies)
  114. Solved: Hide a list box (form controls) (3 replies)
  115. Need audio player to be embedded in form (4 replies)
  116. Solved: delete rows (4 replies)
  117. Setting Series Colours the same accross charts (9 replies)
  118. Exit from main sub (10 replies)
  119. Is there an alternative way of doing conditional formatting using vba? (1 replies)
  120. Solved: ListBox, Option, MultiSelect (9 replies)
  121. Solved: Form data to spreadsheet.... (7 replies)
  122. Solved: Date Formatting (4 replies)
  123. yearfrac() (3 replies)
  124. Shell Cmd Works on Some Computers, But Not Others (2 replies)
  125. Spreadsheets Don't always Refresh in Macro (1 replies)
  126. [SOLVED:] Can I use vba to clear failed print jobs? (2 replies)
  127. What is data modelling in ms excel? (1 replies)
  128. Userform Input Saved To Different Workbook (3 replies)
  129. [SOLVED:] How to open a .txt file using excel vba (8 replies)
  130. Macro checking if currency change is right (2 replies)
  131. Solved: formatting IF's (4 replies)
  132. Email from excel via groupwise 8 using vba (0 replies)
  133. 2 months and sumarize amount of missed clients with formula (3 replies)
  134. Solved: Refer to the Last Row (2 replies)
  135. Solved: VBA Function to Automatically Update (9 replies)
  136. Help Refreshing table filters when updating a value (5 replies)
  137. Function fails to update values? (2 replies)
  138. Sheets.Copy inverts colors?? (4 replies)
  139. Chart on VBA Form (5 replies)
  140. Solved: Is MyUserForm in ThisWorkbook (6 replies)
  141. Solved: Global Variables and Functions (9 replies)
  142. Solved: Cell value to be used for row definition... (4 replies)
  143. Use Triggered Event in all workbooks (1 replies)
  144. Solved: Copying data from one workbook and then transposing and pasting to another workbook (2 replies)
  145. Solved: Excel 2003/07 - How do I assign a UNC path to a USB Drive (6 replies)
  146. Solved: Excel 2003/07 - Is it possible to unshare a workbook using code? (2 replies)
  147. Solved: Multiple small issues (5 replies)
  148. Lookup with interval (2 replies)
  149. Filter worksheet data as per the value selected in Validation Listbox (3 replies)
  150. Solved: assign value to array (3 replies)
  151. Help creating a search button on excel (10 replies)
  152. Solved: Fractions (3 replies)
  153. If file is not in use or open then execute macro (4 replies)
  154. Solved: change the font color automatically (2 replies)
  155. Auto add row and copy formula (3 replies)
  156. Solved: Excel 2003 - Is it complicated to save to a shared network drive? (2 replies)
  157. Calculate Interest on monthly values (3 replies)
  158. Syntax for converting printing decimal number in English to Spanish (4 replies)
  159. how to continue original workbook macro after calling other workbook macro? (3 replies)
  160. How to get VBA to read a directory from a cell. (4 replies)
  161. Creating and deleting pivot tables and charts with VBA (0 replies)
  162. Macro to pull Duplicate ID # and Absent (3 replies)
  163. Solved: easy time formula (5 replies)
  164. Screen Refresh (3 replies)
  165. Solved: Workbook (8 replies)
  166. excel 2007 compare to excel 2010 (7 replies)
  167. [SOLVED:] Open workbook (2 replies)
  168. Need to know if a file is corrupt (7 replies)
  169. Solved: Embed and Extract .exe (5 replies)
  170. Solved: Compile names (2 replies)
  171. Solved: VBA Help Plz (2 replies)
  172. Editing Text file (1 replies)
  173. [SOLVED:] Dynamic Ranges not working with Data Validation (5 replies)
  174. Updating Defined Named Lists (Difficult) (3 replies)
  175. Solved: Copy last 6 columns (11 replies)
  176. VBA Multidimensional Array Question Help (5 replies)
  177. Solved: help (5 replies)
  178. Solved: helpwith WorkSheet Selection_ change & command button (4 replies)
  179. Solved: If Then code (3 replies)
  180. ByRef doesn't pass values in dialog initialization (15 replies)
  181. Need to build CRC-16 CCITT calculator (5 replies)
  182. Create Table Dialog Problems (1 replies)
  183. Need Help: Auto-acept To replace (4 replies)
  184. Using "For Next" to a button name (2 replies)
  185. Copy a .jpeg (2 replies)
  186. Solved: mergesheet with formula (6 replies)
  187. Solved: Visual Basic Editor in Excel (9 replies)
  188. Filtering With VBA Macro (2 replies)
  189. Dynamic Array (5 replies)
  190. Color for multi range (7 replies)
  191. Solved: On sheet change macro. (2 replies)
  192. Solved: Macro to Allocate charges to each client code (2 replies)
  193. Take contents of cells and use them to compose an email - Text Body Problem (0 replies)
  194. Excel VBA dynamic array in a class (1 replies)
  195. VLOOKUP but the cell will be different everyday (13 replies)
  196. Solved: Count rows based on fill color red (4 replies)
  197. Solved: Activate workbook with excel add-in (6 replies)
  198. Solved: Cell Content into Different Rows (12 replies)
  199. Solved: Worksheet Array Selection (2 replies)
  200. Regular expressions (1 replies)
  201. Solved: Date stamp required when cell changes from "open" to "closed" (6 replies)
  202. Task list (3 replies)
  203. Solved: Replace Formula with code (6 replies)
  204. Solved: Get the DateModified of the import file in a cell (5 replies)
  205. How to update a graph automatically based on formulas in a table (1 replies)
  206. How to add cells from 2 different spreadsheets? (1 replies)
  207. Thisworkbook.path (14 replies)
  208. Solved: how to print specific sheets? (3 replies)
  209. Excel 2007 Ribbon (9 replies)
  210. Identify Latest Date Based on Group Type (1 replies)
  211. Solved: Call sub on active worksheet using macro on Personal Macro Workbook (9 replies)
  212. how do i check the last data on Column B and return a text (3 replies)
  213. Solved: Data Validation - character limit (16 replies)
  214. Solved: Excel 2003/2007 - Is it possible to change the caption to a right click menu command? (2 replies)
  215. toggle borders quick access ribbon excel 2010 (2 replies)
  216. Data clubing Help (6 replies)
  217. File Browser In Excel To import Another Excel Spreadshead (3 replies)
  218. Solved: Inserting A New Row For Each Account Number In A Spreadsheet (6 replies)
  219. User Defined Lookup Function (2 replies)
  220. Solved: Index Match using named ranges (3 replies)
  221. Solved: Shell Command and Flash Drive Paths (13 replies)
  222. Sheet(1) in formula? (4 replies)
  223. Solved: Hidden Worksheets (2 replies)
  224. Clear .jpeg in a specific range (1 replies)
  225. What is AVG and how is it used in ms excel? (3 replies)
  226. Help needed to macro macro global (5 replies)
  227. Extract Data From another sheet using VBA (2 replies)
  228. Solved: Clear .Jpeg (6 replies)
  229. Report using array? (3 replies)
  230. Reg: Dropdown width (3 replies)
  231. Splash Screen with no close (1 replies)
  232. Runtime 424 Error "Object Required (4 replies)
  233. Cannot open all files in folder, file name problem, VBA help please! (2 replies)
  234. Need some help creating sku's from multiple worksheets (4 replies)
  235. Can vba take control of the web site by hitting tab key? (2 replies)
  236. [SLEEPER:] Urgent help re interpretation of code (3 replies)
  237. Solved: Criteria1:=strDate (4 replies)
  238. loops within a loop to sum blocks of data (3 replies)
  239. Converting formulas to numbers (2 replies)
  240. Solved: Copy a Picture (2 replies)
  241. How to back up excel file at regular interval? (2 replies)
  242. I am totlay lost with VBA (4 replies)
  243. Display Picture & Play Sound for 5 seconds (4 replies)
  244. Solved: Save sheet to new workbook (4 replies)
  245. Solved: row count for specific column (4 replies)
  246. Solved: condense long code (3 replies)
  247. Excel VBA Help (8 replies)
  248. Basic Sorting Question (non Array) (3 replies)
  249. Solved: Apply exchange rate to many cells (7 replies)
  250. Solved: How to print each worksheet individually from master worksheet (2 replies)