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. Autosum duplicates within X-axis values when creating a chart (2 replies)
  2. VBA to Find and Replace Only in 1 Column (5 replies)
  3. Solved: Update or insert (4 replies)
  4. Simple way to refer to a workbook whose name varies (2 replies)
  5. VBA form printing problem (1 replies)
  6. Dependents from multiple sheets? (2 replies)
  7. Class Deep Copy (3 replies)
  8. Solved: Open Ms On Screen Keyboard (7 replies)
  9. Detecting changed cells on calculation (4 replies)
  10. Solved: Error msg" Object variable or with block variable not set" (8 replies)
  11. Search criteria, cut, and paste in new worksheet (3 replies)
  12. Solved: add sheet with hyperlink (3 replies)
  13. VBA Excel Help (2 replies)
  14. [SOLVED:] Excel 2003/07 How can I get the value of the activecell from another sheet? (2 replies)
  15. Userform/interface question (8 replies)
  16. MouseUp Event using Scroll Bars (1 replies)
  17. Solved: Cell Text Formatting - Irregular Text Date to Date Value (14 replies)
  18. Solved: Duplicating the cell above the current cell (11 replies)
  19. Help with simple cursor/screen reposition for data entry (2 replies)
  20. Passing combobox value on one user form to another user form (1 replies)
  21. INSERT (8 replies)
  22. Solved: Is this possible to replace (3 replies)
  23. numeric (1 replies)
  24. Solved: unloading linked userforms (5 replies)
  25. TextBox MouseDown and MouseUp Events (4 replies)
  26. Solved: How to Make Worksheet Expand and/or Collapse Rows (10 replies)
  27. Filling out web form (0 replies)
  28. Solved: Return value for a false statment (9 replies)
  29. Solved: time counter format (mm:ss) (11 replies)
  30. Solved: Multidimensional Arrays (17 replies)
  31. Solved: Understanding Collections (4 replies)
  32. Solved: Prompt before Exit (2 replies)
  33. How to use WSDL/SOAP to Get Forex Rates into Excel (5 replies)
  34. add text files (0 replies)
  35. Sumif and sum as per mod. Num define on header (4 replies)
  36. Input Box Run time Error 1424 (5 replies)
  37. Toggle Button Click (4 replies)
  38. Solved: Data Validation based on multiple criteria (1 replies)
  39. Solved: VBA lookup function inputbox (3 replies)
  40. refedit control - class not registered (3 replies)
  41. Is there a setting to warn before deleting a cell? (0 replies)
  42. Solved: getting lat/lon coordinates out of Google Earth and into Excel (4 replies)
  43. Solved: Strange and ridiculous problem with my excel-2007 (2 replies)
  44. Unhide hidden sheet? (6 replies)
  45. Connecting Excel 2007 with Oracle DB (3 replies)
  46. Object variable or with block variable not set (3 replies)
  47. Solved: Info (1 replies)
  48. Solved: To split the one table into multiple table (22 replies)
  49. Solved: count_data (8 replies)
  50. Macro to show Worksheet (3 replies)
  51. Defining a Name for a Formula (6 replies)
  52. Solved: Find a text in workbook and... (7 replies)
  53. How can I save setting for Application.EditDirectlyInCell? (4 replies)
  54. Solved: problem with .clear when combined to function with.rowsource (4 replies)
  55. Interrupt Handling (5 replies)
  56. Detecting Keystrokes (2 replies)
  57. Base cell C.F. if there's an active cell in a range? (2 replies)
  58. Formula for Calculating Sales Margins less all discounts (3 replies)
  59. object not found (2 replies)
  60. DDE Link is Locking Up Excel Spreadsheet (3 replies)
  61. How to emulate data base in MS Excel? (6 replies)
  62. Timesheet logger (7 replies)
  63. show the entry of drop down when mouse over a particular value is done (2 replies)
  64. [SOLVED:] Value of column from selected row (2 replies)
  65. [SOLVED:] A quicker way to do this (13 replies)
  66. Contents of dropdown not properly visible (1 replies)
  67. Solved: multi users (2 replies)
  68. Solved: name of folder (12 replies)
  69. Solved: For loop and textboxes (13 replies)
  70. Solved: Combobox items (5 replies)
  71. Macro to Copy Paste Data in a Worksheet (4 replies)
  72. Solved: Reference and format a variable in one expression? (2 replies)
  73. Urgent VBA Help Required!! (5 replies)
  74. Excel Data Validation List (5 replies)
  75. Losing Date formating when creating CSV File using VBA (1 replies)
  76. Extract data from a JAVA Applet (0 replies)
  77. Solved: combo box entry (2 replies)
  78. Simple loop help! (15 replies)
  79. VBA help with arrays and Ifs (3 replies)
  80. Need help to setup restriction (countries) on an already existed VBA (8 replies)
  81. [SLEEPER:] Match formula help (9 replies)
  82. Solved: Address Division and Reorganization (3 replies)
  83. count files extension (1 replies)
  84. combobox2 list dependent on combobox1 sleection (1 replies)
  85. Solved: Assigning library to project via macro (17 replies)
  86. Chart is not updating (2 replies)
  87. match formulas help (2 replies)
  88. Compare cell values & do an autofill (15 replies)
  89. Solved: Vlookup function in VBA Excel (4 replies)
  90. Call a Macro from another Worksheet (1 replies)
  91. Toggle data (2 replies)
  92. RibbonX behaves differently under Windows 7 (7 replies)
  93. Date Picker (1 replies)
  94. Time lapse (4 replies)
  95. Copy filtered and non filtered data (1 replies)
  96. Store data in DB (9 replies)
  97. Force enableventes=true (3 replies)
  98. Sleeper: Code issues (7 replies)
  99. Solved: How to Insert Code into This Workbook Mod (5 replies)
  100. [SOLVED:] Autofill Rows Dynamically (6 replies)
  101. Range of Cells Color Change depedent on another Cell! (1 replies)
  102. how to convert row range to column range? (2 replies)
  103. Solved: Explain Code Please (1 replies)
  104. Solved: Macro: Delete Highlighted Rows (3 replies)
  105. Solved: Hidden Ribbon (2 replies)
  106. VBA: Entire Row Color (6 replies)
  107. loop through range upload to database (5 replies)
  108. Only highlight wrongly capitalized (4 replies)
  109. Solved: Search within a string (2 replies)
  110. Convert Rows to Columns (4 replies)
  111. VBA to create folder and Save As the file (1 replies)
  112. Programmatically creating Hyperlinks to File Names/locations from VBA & Excel (1 replies)
  113. Excel Macro not working correctly HELP!!! (5 replies)
  114. Strange lag when using classes (0 replies)
  115. Solved: Copying files to specific folders, determined by file prefix (12 replies)
  116. Accessing Object methods/properties error (2 replies)
  117. VBA code to email different attachment to different person using outlook (5 replies)
  118. Solved: array function help (9 replies)
  119. Looking for coder, easy project (5 replies)
  120. Macro inserting rows between two columns containin a specifict text (1 replies)
  121. Macro for Special Copy Paste Format (6 replies)
  122. Solved: Conditional Formatting with VBA (6 replies)
  123. VBA Conditional Formatting (6 replies)
  124. Getting on track with array's (5 replies)
  125. Pivot table Help (1 replies)
  126. [SLEEPER:] Unique Only Count (2 replies)
  127. Graphic Getter and Code Creator (13 replies)
  128. Solved: bypassing the Compatibility Check in Excel 2007 (1 replies)
  129. Solved: Duplicates... How to Count and Add Them. (4 replies)
  130. Function returning multiple values (1 replies)
  131. Loop formula to remove last letter of productcode if it is a letter (5 replies)
  132. How to Indentify ODBC drivers installed on a Machine using VBA (1 replies)
  133. Solved: Toggle button to hide/unhide worksheets (2 replies)
  134. text in ColumnHeads (3 replies)
  135. [SOLVED:] get server time (2 replies)
  136. how to create login id and password (3 replies)
  137. Solved: VBA Search (5 replies)
  138. Solved: columnstacked chart problem (4 replies)
  139. [SLEEPER:] Conditional Formats "Cell Colors" (4 replies)
  140. Solved: Macro adding cells together containing the same text (3 replies)
  141. Solved: Small Update For Solved Changing Ranges (2 replies)
  142. use VBA to create a custom marker for a plot or chart (0 replies)
  143. Help creating macro (3 replies)
  144. [SOLVED:] Automate Grouping (5 replies)
  145. Excel Database (3 replies)
  146. Use VBA to add text from a cell to an existing freeform shape (1 replies)
  147. Solved: "Attaching" and sorting arrays? (2 replies)
  148. Underline two besides laying cells in table (1 replies)
  149. append specific cell values from multiple identical sheet in a single excel file (2 replies)
  150. Compare Rows from 2 diff WSs and combine on 3rd sheet (2 replies)
  151. Solved: Write data from sheet into DBs, then into files (7 replies)
  152. Solved: Changing Ranges (2 replies)
  153. Solved: Conditional Concatenate? (3 replies)
  154. Solved: Help Needed in debugging (1 replies)
  155. [SOLVED:] String with String (7 replies)
  156. Solved: Adding two month to the current date. (3 replies)
  157. Solved: Copying data from another workbook which name is unknown (8 replies)
  158. Solved: Chart (5 replies)
  159. Strange Date Formatting! (2 replies)
  160. Macro to link more than one spreadsheet and automate (0 replies)
  161. Macro To Not Allow Saving As When Specific Fields Are Left Blank (5 replies)
  162. Solved: how can a textbox with date returns to the same textbox after error handler. (2 replies)
  163. Solved: VBA to post data to a servelet? (8 replies)
  164. match backwards (2 replies)
  165. Help with Sort macro based on Data Valiation value (5 replies)
  166. Solved: Disable the move or copy sheet (6 replies)
  167. How to create Login & Log out Spread sheet in Excel with automated Attendance sheet (2 replies)
  168. Pull info from Outlook to Excel (1 replies)
  169. Position ListBox scrollbar (1 replies)
  170. Solved: What are good effective ways to error handle and bug fix a macro in ms excel? (5 replies)
  171. Solved: move between cells on a filtered list (2 replies)
  172. Solved: Help with a formula please (6 replies)
  173. Solved: comboboxes on a worksheet (6 replies)
  174. Solved: Write out class data (11 replies)
  175. Solved: Type mismatch "rumtime error 13" (5 replies)
  176. VBA: Blank Cells Based on Value (3 replies)
  177. I need to use a list rather than hard coding criteria and duplicating the code (17 replies)
  178. Lock the column in sheet irrespective of sheet either in protection or unprotection (0 replies)
  179. Solved: 3 mulitilink comboboxes (2 replies)
  180. Solved: I'm new and need some help with some cell editing in vba (Excel) (2 replies)
  181. Solved: Refering Sheet without using Sheet name in VBA Code (2 replies)
  182. Use VBA for totals for Pivot Chart (0 replies)
  183. VBA Macro For Column Header & Deleting Column (1 replies)
  184. Combobox (1 replies)
  185. run time error 1004 (1 replies)
  186. Solved: Use text from a cell reference in vba code. (20 replies)
  187. [SOLVED:] Canceling a BeforeSave Event (6 replies)
  188. Select Row Based off remote cell value (2 replies)
  189. Wait for a cell to be selected... (6 replies)
  190. Solved: Compiler error: Object required. (2 replies)
  191. Setcurrentdirectory not using API? (5 replies)
  192. Solved: Password protection for Macro enabled sheet (6 replies)
  193. Please help a fellow out! Feeding workbook, macro not working cuz some obscure reason (1 replies)
  194. [SOLVED:] Dynamic Variable within formula? (3 replies)
  195. macro for selecting all rows with a specifice font colour in the cell and copy/paste (2 replies)
  196. [SLEEPER:] Please help with VBA project (3 replies)
  197. Solved: VBA Code for Protection of file (2 replies)
  198. Solved: How to e-mail 2 worksheets? (3 replies)
  199. Solved: Make a Sound When a Cell is Changed to a Certain Value (6 replies)
  200. Solved: Insert one blank row after sort 3 columns (17 replies)
  201. pivot table (1 replies)
  202. Events planner (5 replies)
  203. Solved: Copy button to second sheet causes error (3 replies)
  204. Insert picture in cell comments (2 replies)
  205. Excel 2007 - Can not set link update to Manual (0 replies)
  206. VBA for Formatting Worksheet (9 replies)
  207. Solved: VBA for # of Rows Limit (15 replies)
  208. Loop textbox to cell (5 replies)
  209. Help with variable cell range (3 replies)
  210. Loop Through Subfolders And Copy Sheet (4 replies)
  211. how to replace part of r1c1 formula with cell value? (5 replies)
  212. Solved: Unable to update data in db using ADODB connection (2 replies)
  213. concatenate text with .offset (0 replies)
  214. Creating a loop within a loop? (8 replies)
  215. Macro To Not Allow Printing When Specific Fields Are Left Blank (5 replies)
  216. Solved: logic help (2 replies)
  217. Text overlay (1 replies)
  218. Sleeper: Conditional Formatting (1 replies)
  219. [SOLVED:] How to change the color of the columns in the chart? (1 replies)
  220. Streaming via xmlHTTP to DOMDocument (0 replies)
  221. Solved: Duplicating a worksheet (3 replies)
  222. Solved: Populate Drop Down Box with SQL Query (3 replies)
  223. Solved: Clearing Option Buttons (1 replies)
  224. COUNTING (6 replies)
  225. write (3 replies)
  226. Solved: Limit to 4 decimals in textbox using VBA (13 replies)
  227. search text (0 replies)
  228. Ignore blank cells in a named range when using dependent data validation (3 replies)
  229. Dynamic Ranges for Charts (2 replies)
  230. delete entire rows (1 replies)
  231. Solved: Dynamic Capacity Analaysis (3 replies)
  232. [SLEEPER:] Dynamic Ribbon Button (1 replies)
  233. Solved: Syntax question (8 replies)
  234. Excel crashes when saving - emailing (1 replies)
  235. convert text numbers to real numbers, partial Cell deleting, deleting rows between se (12 replies)
  236. ExcelDiet() For Excel 2007 (1 replies)
  237. Solved: Subtotal header row (1 replies)
  238. Solved: help w/ ONTIME (3 replies)
  239. Solved: Duplicate Combobox Entries on Reset (2 replies)
  240. [SLEEPER:] Batch processing SQL query strings in VBA (1 replies)
  241. Sleeper: Login internet and import image (0 replies)
  242. Tired Of To Many Cut & Paste (2 replies)
  243. Import from text file and format data in excel (3 replies)
  244. insert (5 replies)
  245. [SOLVED:] Delete value for some column (1 replies)
  246. How can you read with a VBA Excel Sub a vector from the worksheet? (1 replies)
  247. Solved: Custom diagram dots in excel 2003 (4 replies)
  248. Solved: Merger and Unmerge cells (9 replies)
  249. Solved: repeating a vba code in excel (7 replies)
  250. How to wrap comment.text in vba (1 replies)