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. Solved: VBA modules crash Excel (7 replies)
  2. Solved: How to add comments to a entire column (5 replies)
  3. Solved: Transposing data where some data is in merged cells (8 replies)
  4. Solved: textbox value = cell range (9 replies)
  5. [SOLVED:] Select Sheet Tabs Dynamically (7 replies)
  6. License Key (Or Something Like This) (6 replies)
  7. Web Query & Userforms (5 replies)
  8. Solved: deleting a range based on cell value on another sheet (8 replies)
  9. Storing range object temporarily in code not possible? (5 replies)
  10. Error with sumproduct (7 replies)
  11. Delete empty space at end of row (6 replies)
  12. oldvalue help (3 replies)
  13. Download attachments from outlook folders. (3 replies)
  14. Solved: How to get only specific information from a .txt file using macro (16 replies)
  15. Code Problem Saving Data To Another Workbook (12 replies)
  16. Solved: Finding the last empty column in a row? (3 replies)
  17. Can't figure it out .... Weird Bug!! (4 replies)
  18. Vba Code to filter a Column automatically (8 replies)
  19. [SOLVED:] Updating Functions within a Sub (8 replies)
  20. Solved: Conditional Formatting Via Worksheet Event Code (8 replies)
  21. Block textbox for numbers or text. (7 replies)
  22. Solved: Hide a list box (form controls) (3 replies)
  23. Need audio player to be embedded in form (4 replies)
  24. Solved: delete rows (4 replies)
  25. Setting Series Colours the same accross charts (9 replies)
  26. Exit from main sub (10 replies)
  27. Is there an alternative way of doing conditional formatting using vba? (1 replies)
  28. Solved: ListBox, Option, MultiSelect (9 replies)
  29. Solved: Form data to spreadsheet.... (7 replies)
  30. Solved: Date Formatting (4 replies)
  31. yearfrac() (3 replies)
  32. [SLEEPER:] Shell Cmd Works on Some Computers, But Not Others (2 replies)
  33. Spreadsheets Don't always Refresh in Macro (1 replies)
  34. [SOLVED:] Can I use vba to clear failed print jobs? (2 replies)
  35. What is data modelling in ms excel? (1 replies)
  36. Userform Input Saved To Different Workbook (3 replies)
  37. [SOLVED:] How to open a .txt file using excel vba (8 replies)
  38. Macro checking if currency change is right (2 replies)
  39. Solved: formatting IF's (4 replies)
  40. Email from excel via groupwise 8 using vba (0 replies)
  41. 2 months and sumarize amount of missed clients with formula (3 replies)
  42. Solved: Refer to the Last Row (2 replies)
  43. Solved: VBA Function to Automatically Update (9 replies)
  44. Help Refreshing table filters when updating a value (5 replies)
  45. Function fails to update values? (2 replies)
  46. [SLEEPER:] Sheets.Copy inverts colors?? (4 replies)
  47. Chart on VBA Form (5 replies)
  48. Solved: Is MyUserForm in ThisWorkbook (6 replies)
  49. Solved: Global Variables and Functions (9 replies)
  50. Solved: Cell value to be used for row definition... (4 replies)
  51. Use Triggered Event in all workbooks (1 replies)
  52. Solved: Copying data from one workbook and then transposing and pasting to another workbook (2 replies)
  53. Solved: Excel 2003/07 - How do I assign a UNC path to a USB Drive (6 replies)
  54. Solved: Excel 2003/07 - Is it possible to unshare a workbook using code? (2 replies)
  55. Solved: Multiple small issues (5 replies)
  56. Lookup with interval (2 replies)
  57. Filter worksheet data as per the value selected in Validation Listbox (3 replies)
  58. Solved: assign value to array (3 replies)
  59. Help creating a search button on excel (10 replies)
  60. Solved: Fractions (3 replies)
  61. If file is not in use or open then execute macro (4 replies)
  62. Solved: change the font color automatically (2 replies)
  63. Auto add row and copy formula (3 replies)
  64. Solved: Excel 2003 - Is it complicated to save to a shared network drive? (2 replies)
  65. Calculate Interest on monthly values (3 replies)
  66. Syntax for converting printing decimal number in English to Spanish (4 replies)
  67. how to continue original workbook macro after calling other workbook macro? (3 replies)
  68. How to get VBA to read a directory from a cell. (4 replies)
  69. Creating and deleting pivot tables and charts with VBA (0 replies)
  70. Macro to pull Duplicate ID # and Absent (3 replies)
  71. Solved: easy time formula (5 replies)
  72. Screen Refresh (3 replies)
  73. Solved: Workbook (8 replies)
  74. excel 2007 compare to excel 2010 (7 replies)
  75. [SOLVED:] Open workbook (2 replies)
  76. Need to know if a file is corrupt (7 replies)
  77. Solved: Embed and Extract .exe (5 replies)
  78. Solved: Compile names (2 replies)
  79. Solved: VBA Help Plz (2 replies)
  80. Editing Text file (1 replies)
  81. [SOLVED:] Dynamic Ranges not working with Data Validation (5 replies)
  82. Updating Defined Named Lists (Difficult) (3 replies)
  83. Solved: Copy last 6 columns (11 replies)
  84. VBA Multidimensional Array Question Help (5 replies)
  85. Solved: help (5 replies)
  86. Solved: helpwith WorkSheet Selection_ change & command button (4 replies)
  87. Solved: If Then code (3 replies)
  88. ByRef doesn't pass values in dialog initialization (15 replies)
  89. Need to build CRC-16 CCITT calculator (5 replies)
  90. Create Table Dialog Problems (1 replies)
  91. Need Help: Auto-acept To replace (4 replies)
  92. Using "For Next" to a button name (2 replies)
  93. Copy a .jpeg (2 replies)
  94. Solved: mergesheet with formula (6 replies)
  95. Solved: Visual Basic Editor in Excel (9 replies)
  96. Filtering With VBA Macro (2 replies)
  97. Dynamic Array (5 replies)
  98. Color for multi range (7 replies)
  99. Solved: On sheet change macro. (2 replies)
  100. Solved: Macro to Allocate charges to each client code (2 replies)
  101. Take contents of cells and use them to compose an email - Text Body Problem (0 replies)
  102. Excel VBA dynamic array in a class (1 replies)
  103. VLOOKUP but the cell will be different everyday (13 replies)
  104. Solved: Count rows based on fill color red (4 replies)
  105. Solved: Activate workbook with excel add-in (6 replies)
  106. Solved: Cell Content into Different Rows (12 replies)
  107. Solved: Worksheet Array Selection (2 replies)
  108. Regular expressions (1 replies)
  109. [SOLVED:] Date stamp required when cell changes from "open" to "closed" (6 replies)
  110. Task list (3 replies)
  111. Solved: Replace Formula with code (6 replies)
  112. Solved: Get the DateModified of the import file in a cell (5 replies)
  113. How to update a graph automatically based on formulas in a table (1 replies)
  114. How to add cells from 2 different spreadsheets? (1 replies)
  115. Thisworkbook.path (14 replies)
  116. Solved: how to print specific sheets? (3 replies)
  117. Excel 2007 Ribbon (9 replies)
  118. Identify Latest Date Based on Group Type (1 replies)
  119. Solved: Call sub on active worksheet using macro on Personal Macro Workbook (9 replies)
  120. how do i check the last data on Column B and return a text (3 replies)
  121. Solved: Data Validation - character limit (16 replies)
  122. [SOLVED:] Is it possible to change the caption to a right click menu command? (2 replies)
  123. toggle borders quick access ribbon excel 2010 (2 replies)
  124. Data clubing Help (6 replies)
  125. File Browser In Excel To import Another Excel Spreadshead (3 replies)
  126. Solved: Inserting A New Row For Each Account Number In A Spreadsheet (6 replies)
  127. User Defined Lookup Function (2 replies)
  128. Solved: Index Match using named ranges (3 replies)
  129. Solved: Shell Command and Flash Drive Paths (13 replies)
  130. Sheet(1) in formula? (4 replies)
  131. Solved: Hidden Worksheets (2 replies)
  132. Clear .jpeg in a specific range (1 replies)
  133. What is AVG and how is it used in ms excel? (3 replies)
  134. Help needed to macro macro global (5 replies)
  135. Extract Data From another sheet using VBA (2 replies)
  136. Solved: Clear .Jpeg (6 replies)
  137. Report using array? (3 replies)
  138. Reg: Dropdown width (3 replies)
  139. Splash Screen with no close (1 replies)
  140. Runtime 424 Error "Object Required (4 replies)
  141. Cannot open all files in folder, file name problem, VBA help please! (2 replies)
  142. Need some help creating sku's from multiple worksheets (4 replies)
  143. Can vba take control of the web site by hitting tab key? (2 replies)
  144. [SLEEPER:] Urgent help re interpretation of code (3 replies)
  145. Solved: Criteria1:=strDate (4 replies)
  146. loops within a loop to sum blocks of data (3 replies)
  147. Converting formulas to numbers (2 replies)
  148. Solved: Copy a Picture (2 replies)
  149. How to back up excel file at regular interval? (2 replies)
  150. I am totlay lost with VBA (4 replies)
  151. Display Picture & Play Sound for 5 seconds (4 replies)
  152. Solved: Save sheet to new workbook (4 replies)
  153. Solved: row count for specific column (4 replies)
  154. Solved: condense long code (3 replies)
  155. Excel VBA Help (8 replies)
  156. Basic Sorting Question (non Array) (3 replies)
  157. Solved: Apply exchange rate to many cells (7 replies)
  158. Solved: How to print each worksheet individually from master worksheet (2 replies)
  159. Issue with printing worksheets to pdf. (2 replies)
  160. Show system tray balloon tooltip in VBA (4 replies)
  161. Solved: Sleep - Problem (2 replies)
  162. Solved: Userform do not load properly (15 replies)
  163. Solved: Sheets.Copy won't work (7 replies)
  164. Solved: transparent command button vba (2 replies)
  165. Solved: automatic arrangement of values from lowest to highest and vice versa (6 replies)
  166. Solved: Copy a Picture (2 replies)
  167. Import/Copy SQL Table Data to Excel Worksheet (13 replies)
  168. Solved: Check Internet Explorer Version from Excel (2 replies)
  169. Variables from other subs (4 replies)
  170. Trouble with Pivot table (2 replies)
  171. Solved: Extract Key Words (7 replies)
  172. VBA code doesn't work on different data set (2 replies)
  173. Problem with filtering a list (2 replies)
  174. listbox usage in vba (1 replies)
  175. Userform - is this possible? (6 replies)
  176. How to have excel show the input variables in a custom made functions? (1 replies)
  177. Solved: Userform - ComboBox list problem (7 replies)
  178. Workbooks("").checkin (3 replies)
  179. Solved: Insert .JPEG (6 replies)
  180. [SOLVED:] Autofilter-if criteria doesn't exist? (10 replies)
  181. Solved: Drop Down Window (5 replies)
  182. Textbox does not copy from a chart (0 replies)
  183. Solved: Conditional Edit in Excel using VBA (6 replies)
  184. ListObjects(1).DataBodyRange.Cells.SpecialCells(xlCellTypeVisible).Count is erroneous (3 replies)
  185. Hasheaders in listobjects.add method (1 replies)
  186. Autoshape textbox vba (0 replies)
  187. How to create a file? (7 replies)
  188. Solved: Hiding the Excel Ribbon (2 replies)
  189. Hide row if ? (5 replies)
  190. Solved: VBA code to copy certain cells from active row? (8 replies)
  191. Solved: Matching & Deleting rows (16 replies)
  192. Copy ranges from different worksheet to new worksheet (1 replies)
  193. Solved: Extract Data Matched Year Only (15 replies)
  194. VBA VS COM ADD IN (1 replies)
  195. associate a list with a cell and get the selected value,using vba (1 replies)
  196. Excel VBA (1 replies)
  197. Combining worksheets (1 replies)
  198. OnAction Syntax (7 replies)
  199. [SLEEPER:] dynamic file name (3 replies)
  200. Excel help rquired on following ( Sample )!!!!!! (0 replies)
  201. how to close excel file and application (2 replies)
  202. [SOLVED:] Open a workbook at a certain time of day (2 replies)
  203. Solved: Check two sheets, and amend if criteria met. (3 replies)
  204. Show cell column in userform (1 replies)
  205. Lookup Strings in cell and return max and min values for each (1 replies)
  206. vba to automatically change the selection in dropdown list (3 replies)
  207. Solved: value of cell continues to a cell below? (6 replies)
  208. email + no pop up warning message? (5 replies)
  209. Solved: Using spreadsheet with a userform activated (3 replies)
  210. Autofilter with dates nightmare! (2 replies)
  211. Help with calculating Correl from 2-D array (2 replies)
  212. Dim help needed (9 replies)
  213. [SOLVED:] Conditiona formating (3 replies)
  214. "Begins with" Filters for Number Columns? (1 replies)
  215. Named Range reference to remote workbook (2 replies)
  216. [SOLVED:] Hide row if ? (8 replies)
  217. make a column read only using vba (1 replies)
  218. Need Help on copy paste as image in lotusnotes from excel (1 replies)
  219. Solved: 64-bit compilation (13 replies)
  220. how to add pagebreaks (1 replies)
  221. Excel macro to send meeting requests through outlook (10 replies)
  222. Data in every page footer (2 replies)
  223. Shell command in an If? (19 replies)
  224. Can excel verify domain server name. (2 replies)
  225. [SOLVED:] Splitting the name of dropdown (3 replies)
  226. [SLEEPER:] Copy word to excel (1 replies)
  227. worksheets list in workbook without opening workbook in VBA (3 replies)
  228. How to auto-populate a multiple page PDF form? (5 replies)
  229. stupid dates!!! (10 replies)
  230. Some dificulties to convert text in numbers in a cell (4 replies)
  231. Solved: CommandBars.Add DropDown LinkedCell? (5 replies)
  232. [SLEEPER:] Need to build a webpage that auto-populate an Acrobat form from Excel (0 replies)
  233. Sort columns and create sequence number (2 replies)
  234. Solved: Create Matrix (5 replies)
  235. VBA Code to include outlook Signature automatically while sending mails through excel (1 replies)
  236. Solved: BACK FILLING DATA (15 replies)
  237. why do i get path/file access error always? (7 replies)
  238. [SLEEPER:] Solved: VBA spiral (3 replies)
  239. auto numbered Vouchers need tracking sheet (5 replies)
  240. Strange Excel Behavior When Closing (1 replies)
  241. Solved: Use round in VBA? (5 replies)
  242. fitting shapes in a frame (5 replies)
  243. Customizing Subtotal (4 replies)
  244. How can I write an if, or, lookup formula in VBA (7 replies)
  245. Internet Explorer | Automate clicks on Google search results (6 replies)
  246. Solved: Inserting Blank Columns (4 replies)
  247. Solved: Delete part of a row based on a empty cell (5 replies)
  248. Variables containing spaces (3 replies)
  249. Solved: Limiting UI (0 replies)
  250. Autosum duplicates within X-axis values when creating a chart (2 replies)