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: VBA to delete all "unused" formulas (5 replies)
  2. Close Workbook and Show Userform (3 replies)
  3. intra portfolio correlation formula in vba (9 replies)
  4. Solved: Computing Average Using Offset (1 replies)
  5. Range that increments column number (3 replies)
  6. Moving Charts in Excel Worksheet (4 replies)
  7. Solved: Excel Pasting doesn't align to Word Bookmark (4 replies)
  8. Solved: Excel in-formula macro help! (8 replies)
  9. Solved: Close workbook (2 replies)
  10. help with code for conditional summary sheet (1 replies)
  11. Sumproduct help (2 replies)
  12. Default Value in Combobox (3 replies)
  13. Solved: Error when referencing 3 ranges with a variable (5 replies)
  14. Solved: Download with UserForm (5 replies)
  15. usinig netdays in an "if then" code (3 replies)
  16. Get all cells in a column (4 replies)
  17. Solved: password recover? (5 replies)
  18. array sum (4 replies)
  19. Macro to Protect formula cells (24 replies)
  20. Solved: Paste on grouped sheets in VB for Excel (33 replies)
  21. Solved: Blanks and bad characters (3 replies)
  22. How do I change ?i? as an integer (ie 1,2,3,4?) to ?i? (1-10) with intervals of 0.1? (1 replies)
  23. Copy data from one workbook to another! (6 replies)
  24. Solved: Changing the printer designation for each user (6 replies)
  25. Solved: Creating a data tree in the worksheet (23 replies)
  26. Scripting dictionary (3 replies)
  27. Copy & Paste (7 replies)
  28. Vlookup help (7 replies)
  29. Provide option to disable macros (7 replies)
  30. Workbook_BeforeClose and Workbook_Deactivate (1 replies)
  31. Notepad to xls (3 replies)
  32. Solved: Workbook Event CODE (5 replies)
  33. Quick question about Application.GetOpenFilename() (0 replies)
  34. Solved: assigning values to variable using loops (3 replies)
  35. Trouble with vlookup (15 replies)
  36. Excel 2007 Removing a Custom Tab and Ribbon (3 replies)
  37. Update a cell with another cell (7 replies)
  38. Create Summary Sheet then export that to a Master Workbook (5 replies)
  39. Solved: Button Command Challenging (4 replies)
  40. Template and SaveAsUI (1 replies)
  41. Macro stops when criteria not met (3 replies)
  42. Solved: scrollbar.width property problem on other computers (1 replies)
  43. Solved: count rows excluding header row (7 replies)
  44. charts and data table (2 replies)
  45. Any workaround for assigning values to multiple cells by excel formula or function (6 replies)
  46. Solved: need help with command button (2 replies)
  47. Calculating Averages (22 replies)
  48. Excel Custom Properties (5 replies)
  49. Align a picture in the center of the screen using VBA (4 replies)
  50. Need help with Button command (23 replies)
  51. Sharing a Variable (4 replies)
  52. Urgent - aligning text to the right (1 replies)
  53. Filter validation list (2 replies)
  54. Managing large numbers of buttons (23 replies)
  55. Macro not pasting to correct place (2 replies)
  56. align email body from excel (3 replies)
  57. Auto compress pictures (2 replies)
  58. Consolidating multiple series in worksheet by Date field (8 replies)
  59. Excel-Access Question (4 replies)
  60. Code to delete all modules (1 replies)
  61. Solved: Userform combobox macro to make autosort (7 replies)
  62. [SOLVED:] VBA function to return hyperlink (11 replies)
  63. Solved: Alter code to clear contents not delete row. (2 replies)
  64. Solved: referencing a sheet and cell (2 replies)
  65. Macro fills in blank cells with formula stops at endrow (4 replies)
  66. Solved: date and time score as text (2 replies)
  67. Passing variable to UserForm textbox effort (1 replies)
  68. Exit sub issues (4 replies)
  69. Dealing with worksheet insert error (5 replies)
  70. export excel to outlook (3 replies)
  71. Addin wants password when exiting Excel (0 replies)
  72. Transfer Listbox Rowsource to Worksheet Range (9 replies)
  73. VBA Web query newbie problem (3 replies)
  74. Solved: N Dimension Arrays (4 replies)
  75. Please help with the simple loop (4 replies)
  76. Solved: Error With Code (Compile Error) ~Excel 97~ (2 replies)
  77. Solved: Passing a variable (1 replies)
  78. Macro to open workbook read only (5 replies)
  79. add multiple array to combobx (8 replies)
  80. Solved: Turning an m*n matrices into m*n rows (10 replies)
  81. Solved: Extracting Data Based on Date Range (11 replies)
  82. Solved: Adding only certain values within a cell (6 replies)
  83. VBA: Insert cells without affecting formulas (1 replies)
  84. Solved: VBA for Concatenate (7 replies)
  85. Prevent Save, enable SaveAs with default file name (1 replies)
  86. Dragging Listbox Items within same listbox up/down (7 replies)
  87. Moving an Entire Line using ActiveCell.Row (7 replies)
  88. Solved: Combining macros to open and run on multiple protected worksheets (24 replies)
  89. Solved: Quit Application if filename is renamed (2 replies)
  90. VBA Set PivotItem to Not Visible (2 replies)
  91. Import data (5 replies)
  92. VBA - Changing SeriesCollection.Values for Line Chart (8 replies)
  93. Problems running macro from another workbook (2 replies)
  94. Userform/sheet selection again (5 replies)
  95. [SOLVED:] Change Data for Chart via dropdown (2 replies)
  96. Solved: Use Command button to e-mail from userform (9 replies)
  97. Between --- in excel? (8 replies)
  98. Solved: Save dates for weekly figures (7 replies)
  99. Solved: for loop (3 replies)
  100. pasting range .offset (1 replies)
  101. limited period (4 replies)
  102. UserForm (4 replies)
  103. Working With Multiple Workbooks (12 replies)
  104. Solved: adding a Month (7 replies)
  105. [SOLVED:] Wildcards for not contain (4 replies)
  106. Solved: vba code for adding same row next column if condition met (5 replies)
  107. Solved: Alter code to only copy values without formulas (4 replies)
  108. How to identify workbook?s name? (9 replies)
  109. Solved: Code to find match & remove data from 5 sheets (3 replies)
  110. [SOLVED:] Use of File Array in Excel VBA (4 replies)
  111. Need help deciphering code (5 replies)
  112. Solved: Userform/sheet selection (4 replies)
  113. Cell Contains Word (5 replies)
  114. Finding VBA and Function code (3 replies)
  115. Right mouse click on user form (2 replies)
  116. Remove Tool Bar in Chart Sheet (1 replies)
  117. Solved: Writing UserForm data to a Specific cell (3 replies)
  118. XLS size restriction? (2 replies)
  119. Solved: How to resolve out of subscript range error? (4 replies)
  120. Sleeper: Date format and filtering (0 replies)
  121. How many characters can countif handle? (5 replies)
  122. scheduling a macro a once a week (1 replies)
  123. Solved: No warning when overwriting file (3 replies)
  124. Sleeper: Copy a file (0 replies)
  125. Shopping Basket Analysis (0 replies)
  126. Solved: using outlook dialog boxes in excel (5 replies)
  127. Alternative To ActiveCell.Row (7 replies)
  128. VBA Coding for function that has multiple Integer Value (1 replies)
  129. Solved: Applying a countif formula to each section of data in excel worksheet (8 replies)
  130. Retreiving tab name (4 replies)
  131. ok (0 replies)
  132. Solved: Call a Userform when "Esc" key is press (2 replies)
  133. VBA coding to run macro on multiple files (6 replies)
  134. DisableAutoMacros when opening Word in Excel VBA (3 replies)
  135. Solved: save combobox selection to worksheet (7 replies)
  136. File Save User Form (1 replies)
  137. Solved: Sorting Cells with Empty Strings (2 replies)
  138. Solved: printing worksheet (4 replies)
  139. Solved: Trying to compare two columns (5 replies)
  140. Create a single .csv from multiple worksheets (9 replies)
  141. vba excel code to find current dll running (5 replies)
  142. [SOLVED:] Find row number and pass it to a variable (7 replies)
  143. Converting XLS file into CSV file (1 replies)
  144. pivot tables (3 replies)
  145. Adding Continuous Check Boxes (13 replies)
  146. Solved: User name (3 replies)
  147. Solved: CAPS LOCK Balloon Message (8 replies)
  148. Solved: How do I activate an Outlook dialog box, make selection, then return to Excel? (2 replies)
  149. Compare and delele cells with equal value (2 replies)
  150. Solved: Formula for Conditional Formatting (1 replies)
  151. Solved: Protecting Custom Properties (5 replies)
  152. Solved: Move rows to new work book based on a cell value. (1 replies)
  153. Select and copy every second row (1 replies)
  154. Solved: Passing a module as a parameter (7 replies)
  155. Paste into a comment box directly from clipboard? (2 replies)
  156. Solved: Find text & Mark findings (5 replies)
  157. How to group all sheets by default (2 replies)
  158. Solved: Copy worksheer to all workbooks in specified folder (2 replies)
  159. why i am having run time error with this code (3 replies)
  160. Solved: Hello all, a little help needed if possible... (3 replies)
  161. Solved: SUMIF "CELL IS NOT NULL" (2 replies)
  162. Solved: How to capture cell changes (2 replies)
  163. Solved: Sumproduct problem in table (2 replies)
  164. Solved: Vlookup Question (2 replies)
  165. Solved: Adding to values together within a cell programatically (4 replies)
  166. manipulating userform objects from a code module (4 replies)
  167. Solved: Chart. Very different value. SpinButton (6 replies)
  168. Solved: Generating Unique Number ID's (12 replies)
  169. VBA Excel Project (2 replies)
  170. match variable with list (2 replies)
  171. Hide 2 of 3 Pivot Chart Buttons? (0 replies)
  172. how to eliminate Ist column (0 replies)
  173. Calender Control (1 replies)
  174. Solved: Shape colour (6 replies)
  175. Solved: worksheet buttons (6 replies)
  176. Solved: Default file (8 replies)
  177. Solved: fso.GetFile not working! (3 replies)
  178. Solved: SumProduct (6 replies)
  179. Solved: Retrieve Outlook Contact Data (6 replies)
  180. [SOLVED:] Coding alternating blank lines w emails (6 replies)
  181. Solved: Copy cell range, paste into Outlook Contact Notes (8 replies)
  182. Solved: Pivot table (XLD) (2 replies)
  183. Quick Subtotal Question (1 replies)
  184. Web Toolbar (0 replies)
  185. need help with coding (6 replies)
  186. Solved: Macro to close all windows but one (5 replies)
  187. Solved: erase blanks (5 replies)
  188. Recommend Books for VBA, Excel, and Access. (7 replies)
  189. Solved: Copying worksheet formula results to a new workbook. (4 replies)
  190. How to Format a TextBox bound to a ControlSource? (4 replies)
  191. Solved: Questions about calling procedures to shorten code (5 replies)
  192. read only (4 replies)
  193. Solved: pivot tables (2 replies)
  194. Need Help sorting Ratings with or without VBA (9 replies)
  195. Solved: Union Range Error for Pop Up Calendar (4 replies)
  196. Use a dynamic range in a formula (1 replies)
  197. Copy Rows from External Data Query (1 replies)
  198. Cell Format (5 replies)
  199. Solved: Delete all code after save (3 replies)
  200. Problem with multiple users accessing same workbook. (3 replies)
  201. Solved: worksheets function (2 replies)
  202. Chart (1 replies)
  203. Solved: copy data from one userform to another (16 replies)
  204. Running SQL Stored Proc through VBA (1 replies)
  205. Solved: Edit VBA Code using VBA? (11 replies)
  206. Solved: Disable Space Bar & Delete button (4 replies)
  207. Solved: Password Message Box (2 replies)
  208. Solved: Country Name to stay fixed always in a cell (3 replies)
  209. Count non empty cells on sheet with hidden cols (3 replies)
  210. Solved: How do you remove all text after the last \ in a string (2 replies)
  211. Solved: Application.GetSaveAsFilename question (5 replies)
  212. process array of excel files not working (1 replies)
  213. Solved: Sorting Multiple Rows Horizontally (6 replies)
  214. Solved: None of my buttons work anymore (8 replies)
  215. Solved: Open Directory Macro (6 replies)
  216. Issue with deleting adding (2 replies)
  217. Solved: add to combobox if not already present (8 replies)
  218. Cell value dependency (2 replies)
  219. Test if more than one instance of excel is open (8 replies)
  220. Solved: Criteria needing to match several items (10 replies)
  221. Replace Cell values (vba) (6 replies)
  222. Solved: Tricky situation:-Delete readonly folder in vba (4 replies)
  223. Extra Workbook called Sheet2 has appeared (4 replies)
  224. color cell depending on input (28 replies)
  225. Solved: Help for Turning Off Alerts for Missing Addin (8 replies)
  226. Importing data from visio to excel (0 replies)
  227. Update Question (5 replies)
  228. VBA cannot open excel sheet if another excel is open!! (3 replies)
  229. VLookup macro and variables (7 replies)
  230. macros can't find macros in personal.xls (8 replies)
  231. Solved: Update Excel Query Programatically (5 replies)
  232. Active Cell = Bolding (2 replies)
  233. Solved: Excel query from foxpro with variables (5 replies)
  234. Solved: countif (3 replies)
  235. Solved: Transferring data from one workbook to another (5 replies)
  236. delete all charts in workbook (2 replies)
  237. Solved: Removing text from a field (4 replies)
  238. Solved: changeing background colour of a certain cell (2 replies)
  239. Solved: IF statements in excel (3 replies)
  240. Solved: Form Control vs. Control Box control (5 replies)
  241. Stats in a variable location (16 replies)
  242. Solved: Number format issue in multicolumn listbox (2 replies)
  243. Solved: Inserting Picture in charts thru VBA (2 replies)
  244. Solved: Check box prompt (8 replies)
  245. copy specific columns from one excel file to already opened excel file (3 replies)
  246. Outputting runtime macro to footer of Excel (8 replies)
  247. select all range (6 replies)
  248. Project locked Error (1 replies)
  249. Inserting Rows + ScrollArea + Protection (4 replies)
  250. [SOLVED:] Global 'Excel.Range' alternative? (8 replies)