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 Excel Question (22 replies)
  2. Solved: AutoPrint a worksheet (3 replies)
  3. Migrating Excel Table to SQL Server 2005 (5 replies)
  4. Solved: Find a cell with date<actual and delete row. (9 replies)
  5. Find and replace (3 replies)
  6. ControlProperty (2 replies)
  7. Solved: Copy & Paste data between 2 workbooks (14 replies)
  8. Get value of FillColour button (4 replies)
  9. code not working (5 replies)
  10. Solved: Tree Nodes as links (4 replies)
  11. Solved: Find a cell, copy, paste and delete (5 replies)
  12. sendkeys question (1 replies)
  13. Sleeper: Working with more than 65000 rows and Pivot Tables (1 replies)
  14. Values as per the combination (1 replies)
  15. Solved: Request simple test in Excel 2000 (3 replies)
  16. Solved: Preventing Workbook & Sheet Protect (3 replies)
  17. Solved: Opening form (2 replies)
  18. Solved: Forms in VBA (2 replies)
  19. make list by using countif (4 replies)
  20. Solved: Countblank Named Ranges (4 replies)
  21. Solved: Trigger a Validation based upon a cell value (5 replies)
  22. Solved: Cell Color change Vlookup (1 replies)
  23. Macro to copy value in another sheet in certain manner. (1 replies)
  24. macro triggered by row insertion (5 replies)
  25. Hide rows based on particular cell value (2 replies)
  26. Solved: time1 < time2 + 30? (6 replies)
  27. Solved: How to selct sheets starting with certain word (3 replies)
  28. Solved: Sumproduct Text Value (5 replies)
  29. Read Only file - Stop from asking for Save (3 replies)
  30. Solved: Error in sequence of data in treeview (6 replies)
  31. Loop to create number thru all sheet (5 replies)
  32. [SLEEPER:] sum with several matches (2 replies)
  33. Solved: how to search cells in a column for a text string (3 replies)
  34. Vlookup formula entry (5 replies)
  35. Find Record (25 replies)
  36. Help with Finance calculation please (3 replies)
  37. Solved: Copying a cells "formating" into text (2 replies)
  38. Solved: Changing rows to columns???? (21 replies)
  39. Solved: Date picker userform - the size is changed (10 replies)
  40. vba copy (4 replies)
  41. Solved: I need somebody to fill in the missing part in this code (6 replies)
  42. Solved: Rearrange elements within 2D array randomly (3 replies)
  43. Macro to show shape based on adjacent cell outcome (3 replies)
  44. Solved: Setting Variable Equal to Cell Value (3 replies)
  45. Solved: Cross-Reference Two Cells Using Userform with RefEdit and Hyperlink (2 replies)
  46. Solved: Count non-identical codenumbers in big file (8 replies)
  47. CONSOLIDATION Formula Challenge (9 replies)
  48. Copying using a loop (4 replies)
  49. Loop Help for Newbie (6 replies)
  50. Solved: Force shape to be inserted in middle of cell (2 replies)
  51. unhiding all rows in all worksheets (3 replies)
  52. Solved: How can I copy a UserForm (and Module)? (6 replies)
  53. Agents sheets (2 replies)
  54. Code Tweak - PivotTable, Find (0 replies)
  55. How To Program Excel VBA code using VB.Net??? (7 replies)
  56. List tabs (2 replies)
  57. Solved: VLOOKUP in VBA not working (12 replies)
  58. Correct workbook name (3 replies)
  59. Solved: Clear content of a merged cell (6 replies)
  60. [SOLVED:] Probably So Easy It's Embarassing! (7 replies)
  61. file created date (1 replies)
  62. Collection (13 replies)
  63. A toggle button to highlight/unhighlight cells with formulas (2 replies)
  64. Solved: simple Instr doesn't work properly (7 replies)
  65. In need of a test vba to insert a value based on a date (2 replies)
  66. Solved: Fonts to shapes? Possible? (4 replies)
  67. very simple but stumping me big time (44 replies)
  68. Solved: Count rows which are identical with a cell (2 replies)
  69. Workbook Path - minus one folder (2 replies)
  70. Solved: Need to insert formula using macro (5 replies)
  71. Solved: Check Box (7 replies)
  72. Solved: Need some help with coding (2 replies)
  73. Solved: New to VBA - Help me in making this code shorter and better (18 replies)
  74. Userform Opacity (2 replies)
  75. A question on User defined function (1 replies)
  76. Solved: Delete specific cells not entire row (1 replies)
  77. Solved: Copy data into next empty cell (8 replies)
  78. Solved: how to display a cell value in a userform (3 replies)
  79. Solved: Simple loop not working properly (4 replies)
  80. Select a range by using a input box as a number (14 replies)
  81. Use cells for network paremeters in formulas (1 replies)
  82. Delete if duplicate (4 replies)
  83. Solved: counting unique in vba (16 replies)
  84. Shrink VB Code (12 replies)
  85. Solved: Disabling Messages In Excel During Macro Runtime (3 replies)
  86. Solved: Vlookup , not working, returning wrong values (2 replies)
  87. For Next Loop problems (5 replies)
  88. Solved: Summing same row twice. (4 replies)
  89. Group by string value and perform operation (7 replies)
  90. Lost - asFormula2 = asFormula2 (9 replies)
  91. Stop Excel Showing (3 replies)
  92. Copy/transfer data from one sheet to another (5 replies)
  93. Solved: On Error Goto Failing (2 replies)
  94. Solved: Cell Reference (6 replies)
  95. Schedule Event on First Business Day of Month (1 replies)
  96. Solved: Copy Rows w/in a Range Only if Condition Met (7 replies)
  97. Cheap Code Writing Digi ID besides Verisign (4 replies)
  98. Making command buttons visible (1 replies)
  99. Solved: CommandButton on a worksheet (11 replies)
  100. Macro causing Excel 2003 to crash (code included) (1 replies)
  101. Solved: Listbox - Double Click to add data into userform field (10 replies)
  102. [SOLVED:] Copy Method of Worksheet Class Failed (5 replies)
  103. detect changed cell in a column (7 replies)
  104. Solved: Match across 2 columns (6 replies)
  105. Protected Worksheet - Excel bug? (11 replies)
  106. Code Error's (1 replies)
  107. erase #value! (1 replies)
  108. Solved: ListBox ,select wbkb, open in Sub (6 replies)
  109. Form Opens Multiple Times (2 replies)
  110. Solved: Changing Number Format of Variable Values (6 replies)
  111. Solved: Excel Division (4 replies)
  112. PDFCreator Problems with Excel (2 replies)
  113. Solved: Manage similar events with textboxes (27 replies)
  114. Find and Replace Loop (5 replies)
  115. Code crashes when closing workbook (6 replies)
  116. select/use active pivot, vba (0 replies)
  117. Solved: Looping through workbooks instead of worksheet (8 replies)
  118. Solved: Help using the RefEdit Control (2 replies)
  119. Exporting data to Outlook Calendar (0 replies)
  120. dictionary userform (1 replies)
  121. Tab Order (1 replies)
  122. Run code on workbook open (1 replies)
  123. Custom Pivot Table Drilldowns in Excel 2007 (0 replies)
  124. IE Automation form Javascript (3 replies)
  125. Help button to open pdf or chm (4 replies)
  126. Solved: Solved....Locking Cells? (5 replies)
  127. Pasting Special Cell into different sheet (3 replies)
  128. Solved: Macro to find code in many columns and copy findings (not easy) (7 replies)
  129. Solved: Data Validation: Drop-Down Text Size (3 replies)
  130. Solved: Cut a Long list in half and paste into a new Column (2 replies)
  131. Solved: How can I test a Form Label to see if it is contained in a given Form Frame? (4 replies)
  132. Solved: Macro won't loop to second worksheet (3 replies)
  133. Solved: end if without block if? (2 replies)
  134. Solved: Do loop problem is last row (65536) reached (4 replies)
  135. Solved: Update Recordset from VBA Not Working (3 replies)
  136. Highlighting filtered columns - automatically (1 replies)
  137. Summing all rows in a column in a specified worksheet (7 replies)
  138. Solved: Moving Copying and Deleting A Sheet (3 replies)
  139. Solved: password to modify (1 replies)
  140. Solved: Do I need SUMIF for this problem? (6 replies)
  141. how to get the language installation (3 replies)
  142. Building a hierarchy (3 replies)
  143. Solved: VBE to change Line Chart Height based on number of Rows (5 replies)
  144. generate matrix from table? (5 replies)
  145. [SLEEPER:] Getting Unique elements of Array (13 replies)
  146. Solved: Fastest way to divide all rows in column C by a fixed number, put results in column D (5 replies)
  147. Context specific help (WhatsThisHelp) (0 replies)
  148. Soooo Sloooow! (3 replies)
  149. Deleting rows, adding columns and Excel formulas (5 replies)
  150. Solved: Assistance With a ComboBox (6 replies)
  151. Install addin for everyone (2 replies)
  152. Creating a macro to copy formulas (2 replies)
  153. get particular data from outlook mail into excel using VBA (0 replies)
  154. Understanding Multi Column Listbox (2 replies)
  155. Solved: Pop up errors/boxes when running macro (2 replies)
  156. How to make this VBA better (18 replies)
  157. Solved: Code to check that a worksheet name from an inputbox is valid? (7 replies)
  158. Paste Named Range (4 replies)
  159. Solved: How the Code Works? (4 replies)
  160. Runtime error while using Advanced filter (2 replies)
  161. Wont let me select range (13 replies)
  162. Inserting default character(s) when submit button is pressed (1 replies)
  163. Data Range Issue (1 replies)
  164. Error handler not working (4 replies)
  165. Solved: Help please...input box issue... (8 replies)
  166. Solved: Excel data to Word bookmarks (2 replies)
  167. Solved: Date Format in UserForm (4 replies)
  168. Solved: Problem initializing Class after adding an ActiveX control (6 replies)
  169. Solved: chart sheet and work sheet (2 replies)
  170. Create an access database by a VBA in Excel (4 replies)
  171. Double Click (3 replies)
  172. Solved: Saving worksheets as separate workbooks (3 replies)
  173. Named Ranges (4 replies)
  174. Solved: Import HTML Query Named range issue (8 replies)
  175. Return text in cell based on match of multiple criteria (0 replies)
  176. Building a data base from Real-Time Data (5 replies)
  177. Solved: VBA to delete all "unused" formulas (5 replies)
  178. Close Workbook and Show Userform (3 replies)
  179. intra portfolio correlation formula in vba (9 replies)
  180. Solved: Computing Average Using Offset (1 replies)
  181. Range that increments column number (3 replies)
  182. Moving Charts in Excel Worksheet (4 replies)
  183. Solved: Excel Pasting doesn't align to Word Bookmark (4 replies)
  184. Solved: Excel in-formula macro help! (8 replies)
  185. Solved: Close workbook (2 replies)
  186. help with code for conditional summary sheet (1 replies)
  187. Sumproduct help (2 replies)
  188. Default Value in Combobox (3 replies)
  189. Solved: Error when referencing 3 ranges with a variable (5 replies)
  190. Solved: Download with UserForm (5 replies)
  191. usinig netdays in an "if then" code (3 replies)
  192. Get all cells in a column (4 replies)
  193. Solved: password recover? (5 replies)
  194. array sum (4 replies)
  195. Macro to Protect formula cells (24 replies)
  196. [SOLVED:] Paste on grouped sheets in VB for Excel (33 replies)
  197. Solved: Blanks and bad characters (3 replies)
  198. How do I change ?i? as an integer (ie 1,2,3,4?) to ?i? (1-10) with intervals of 0.1? (1 replies)
  199. Copy data from one workbook to another! (6 replies)
  200. Solved: Changing the printer designation for each user (6 replies)
  201. Solved: Creating a data tree in the worksheet (23 replies)
  202. Scripting dictionary (3 replies)
  203. Copy & Paste (7 replies)
  204. Vlookup help (7 replies)
  205. Provide option to disable macros (7 replies)
  206. Workbook_BeforeClose and Workbook_Deactivate (1 replies)
  207. Notepad to xls (3 replies)
  208. Solved: Workbook Event CODE (5 replies)
  209. Quick question about Application.GetOpenFilename() (0 replies)
  210. Solved: assigning values to variable using loops (3 replies)
  211. Trouble with vlookup (15 replies)
  212. Excel 2007 Removing a Custom Tab and Ribbon (3 replies)
  213. Update a cell with another cell (7 replies)
  214. Create Summary Sheet then export that to a Master Workbook (5 replies)
  215. Solved: Button Command Challenging (4 replies)
  216. Template and SaveAsUI (1 replies)
  217. Macro stops when criteria not met (3 replies)
  218. Solved: scrollbar.width property problem on other computers (1 replies)
  219. Solved: count rows excluding header row (7 replies)
  220. charts and data table (2 replies)
  221. Any workaround for assigning values to multiple cells by excel formula or function (6 replies)
  222. Solved: need help with command button (2 replies)
  223. Calculating Averages (22 replies)
  224. Excel Custom Properties (5 replies)
  225. Align a picture in the center of the screen using VBA (4 replies)
  226. [SLEEPER:] Need help with Button command (23 replies)
  227. Sharing a Variable (4 replies)
  228. Urgent - aligning text to the right (1 replies)
  229. Filter validation list (2 replies)
  230. Managing large numbers of buttons (23 replies)
  231. Macro not pasting to correct place (2 replies)
  232. align email body from excel (3 replies)
  233. Auto compress pictures (2 replies)
  234. Consolidating multiple series in worksheet by Date field (8 replies)
  235. Excel-Access Question (4 replies)
  236. Code to delete all modules (1 replies)
  237. Solved: Userform combobox macro to make autosort (7 replies)
  238. [SOLVED:] VBA function to return hyperlink (11 replies)
  239. Solved: Alter code to clear contents not delete row. (2 replies)
  240. Solved: referencing a sheet and cell (2 replies)
  241. Macro fills in blank cells with formula stops at endrow (4 replies)
  242. Solved: date and time score as text (2 replies)
  243. Passing variable to UserForm textbox effort (1 replies)
  244. Exit sub issues (4 replies)
  245. Dealing with worksheet insert error (5 replies)
  246. export excel to outlook (3 replies)
  247. Addin wants password when exiting Excel (0 replies)
  248. Transfer Listbox Rowsource to Worksheet Range (9 replies)
  249. VBA Web query newbie problem (3 replies)
  250. Solved: N Dimension Arrays (4 replies)