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. how to close a workbook on network when its open by another user. (7 replies)
  2. Solved: Hidding button on worksheet depending on password (4 replies)
  3. Multithreading Excel and Word (0 replies)
  4. Search and copy data (Macro) (0 replies)
  5. Solved: Activating sub from another workbook (12 replies)
  6. Update everyday at 2:30 (1 replies)
  7. Create a date entry for each day of the month (3 replies)
  8. Solved: Copy and past in next available row (3 replies)
  9. Getting a total copied set of rows in VBA and storing it in a variable (1 replies)
  10. Locking the name of a range (1 replies)
  11. Solved: Accessing The Reference Cell Contained In The Excel VLookUp() Function From VBA !! (2 replies)
  12. Sleeper: Copy and pasting selection of data (0 replies)
  13. Unable to set the XValues property of the Series class (1 replies)
  14. Solved: Moving rows from one sheet to another using vlookup (3 replies)
  15. Solved: Dealing with dates in macros (6 replies)
  16. Solved: Word to excel & 'clip' (2 replies)
  17. problem:filter pivotable with 2 text cells (9 replies)
  18. Create sheets from master but copy them to new book (7 replies)
  19. Solved: Counting account numbers (6 replies)
  20. Ask: Pull data from another sheet with macro (excel 2003) (0 replies)
  21. Solved: Placing text in a next empty Cell with VBA (3 replies)
  22. Solved: Range("e1").Row = 5 not e (4 replies)
  23. Solved: Can't manage to rename updated version (13 replies)
  24. Solved: Apply code to second to last line of spreadsheet (4 replies)
  25. SEPARATE ROWS WHEN CONDITIONS MET (2 replies)
  26. Simple Supply and Demand Model using Solver (15 replies)
  27. conversion of VBA to vb.net (4 replies)
  28. Manipulating recordset (1 replies)
  29. Copy data from first workbook to a different workbook based on cell value in first (1 replies)
  30. Copying data from one sheet to a specific range of cells in a different workbook (1 replies)
  31. Solved: Mark as XXXXX (18 replies)
  32. Solved: Apply formula to all cells in a column (2 replies)
  33. Solved: Bold last row of spreadsheet (5 replies)
  34. Limiting array size (1 replies)
  35. Solved: Cells with zero or no value - amend (1 replies)
  36. Solved: Moving row to another space (2 replies)
  37. Solved: Tweeking formula (2 replies)
  38. Hide CMD window that script shows. (1 replies)
  39. If there is no chart on activesheet, then go to NoChart. (1 replies)
  40. Tabs to different work books. (6 replies)
  41. Solved: Inserting cells in between entries (2 replies)
  42. Help Understanding Code Dealing with Creating New Spreadsheets (1 replies)
  43. When file is open Automatically run VBA (7 replies)
  44. Solved: Filling a formula (9 replies)
  45. Combo/List Box populated by user form entries (4 replies)
  46. Adding header data during data extraction (8 replies)
  47. Check port is up from VBA (Excel) (5 replies)
  48. VBA script doesn't run (11 replies)
  49. Solved: Paint next three columns (2 replies)
  50. Solved: Select End Row (2 replies)
  51. Solved: Onaction property (8 replies)
  52. Extracting Model Numbers (2 replies)
  53. Solved: Can these 2 VBA's be combined (6 replies)
  54. Solved: Drive Letter (3 replies)
  55. Solved: Footer Capation (4 replies)
  56. Best use of memory (5 replies)
  57. Solved: Colour Cells (6 replies)
  58. Solved: VLOOKUP (2 replies)
  59. Solved: Application display alert question (2 replies)
  60. Copying Multiple worksheets in Multiple workbooks to one single workbook (2 replies)
  61. Solved: Search Range of numbers and return missing (5 replies)
  62. Solved: commandbutton that "follows" cursor (7 replies)
  63. Selecting Sheet via Input Box or other way (2 replies)
  64. VLOOKUP error codes in VB (10 replies)
  65. Solved: vba help to automate report. (8 replies)
  66. VLOOKUP - works on 1 form but not on another (2 replies)
  67. Solved: Finding and highlighting duplicate names (2 replies)
  68. [SOLVED:] Copy data fom 1 workbook to another, where itneeds to go to 2 different worksheets (7 replies)
  69. Solved: Need help to change column to comma style (2 replies)
  70. Solved: Data Validation Macro Problem (18 replies)
  71. Solved: Select defined range (3 replies)
  72. Solved: Dates as X-Axis for multi-series line or xy chart (2 replies)
  73. Solved: If Or Statements with VLookup (2 replies)
  74. Solved: Can these 2 VBA codes be merged in to 1 (2 replies)
  75. VBA: Selecting and Copying Columns [more complex than it sounds] (8 replies)
  76. Solved: Filling a formula (4 replies)
  77. Moving rows from one spreadsheet to another (2 replies)
  78. Error in expression (4 replies)
  79. Problem with my search/replace macro (11 replies)
  80. Making a workbook visible again (1 replies)
  81. [SOLVED:] referencing information between userforms (1 replies)
  82. Problem with Interactive Graph with Rollover Hyperlinks and UDFs (1 replies)
  83. Cell references (1 replies)
  84. Drop down boxes and forms (3 replies)
  85. Select OLEobject checkbox PROGRAMMATICALLY??? (1 replies)
  86. Solved: removing part of string (9 replies)
  87. VBA: selecting data to be outputted to new sheet (7 replies)
  88. Solved: Vba debugging Run-time error '1044': (6 replies)
  89. Solved: Excel VBA comparison wierdness / challenge (4 replies)
  90. Help to generate week ending from days as per financial new (3 replies)
  91. How to add formula and value to cell VBA (1 replies)
  92. Runtime error 1004 (10 replies)
  93. macro to find and replace #ref errors with actual cell values, and stop at last sheet (1 replies)
  94. veiw variable/ array values during debug (1 replies)
  95. Solved: refer to value in a cell in a macro (1 replies)
  96. Solved: Deleting rows based on column content. (3 replies)
  97. Need help altering Planner VBA (1 replies)
  98. Applying formulas to certain cells (3 replies)
  99. Solved: loop in a loop (10 replies)
  100. locking cells without sheet protection (8 replies)
  101. Solved: ComboBox (SOLVED) (2 replies)
  102. Solved: Disable "save changes" pop up when closing (2 replies)
  103. Delete empty rows (1 replies)
  104. Duplicate values (0 replies)
  105. Solved: Select Cooresponding Cell Fron Listbox (2 replies)
  106. Password protected Workbook (2 replies)
  107. Solved: VBA to exclude Public Holidays (9 replies)
  108. Check if cells is empty (5 replies)
  109. Pivot Table Autoformat XL2003 (6 replies)
  110. VBA Excel 2007 (4 replies)
  111. Select the MIN value in a data range (6 replies)
  112. VBA CODE FOR PIVOT TABLE (6 replies)
  113. Active Directory Query with Macro (4 replies)
  114. Can't find project or library (2 replies)
  115. how to add my company logo as footer on every sheet vba. (6 replies)
  116. Hide Macro code (1 replies)
  117. check if a value is in a recordset (14 replies)
  118. multiple text file import in single excel sheet (6 replies)
  119. Solved: Errors with date functions (4 replies)
  120. Simple way to know Control Panel status (2 replies)
  121. call a sub from another sub (6 replies)
  122. Sleeper: Remove words (8 replies)
  123. Sheets (19 replies)
  124. Solved: How to fix a formula value without vba (2 replies)
  125. To identify the duplicate rows and copy the unique rows alone from sheet1 to sheet2 (2 replies)
  126. How can I speed up my RemoveAt procedure? (2 replies)
  127. Trying to get a False result from DTPicker (2 replies)
  128. Solved: Who opened my workbook? (6 replies)
  129. selcting then hiding (4 replies)
  130. File name in cell (6 replies)
  131. text display (8 replies)
  132. Filling cells with a formula (4 replies)
  133. Scrollbar for list of Labels (7 replies)
  134. Solved: Application.Visible = False (7 replies)
  135. Solved: Activate the Add-In Screen with VBA (6 replies)
  136. Solved: Add Caption problem (2 replies)
  137. Solved: on open show combobox with 10 choices (8 replies)
  138. Excel VBA/Macro - Search against Multiple Criteria (6 replies)
  139. Elimination of things in a cell (1 replies)
  140. Searching for items in another excel sheet (1 replies)
  141. a named range with more than seperated range (4 replies)
  142. Solved: Selection code is not accepted (7 replies)
  143. If two geographical data match in two sheets, then add/copy/replicate unique id/code (1 replies)
  144. Duplicating macros across worksheets (19 replies)
  145. Linking Sheets (8 replies)
  146. Creating Links (14 replies)
  147. VBA reading multiline textbox line by line (1 replies)
  148. Open another workbook and search for cusips (2 replies)
  149. Using conditional FormatConditions Method (3 replies)
  150. Distinguish between two similar values (3 replies)
  151. Unprotect then protect after Workbook is opened (6 replies)
  152. UserForm_QueryClose vs Unload Me (1 replies)
  153. [SOLVED:] Autocomplete in a cell (5 replies)
  154. Problem finding ranges without using Selection (2 replies)
  155. Solved: returning cursor to incomplete textbox within userform (2 replies)
  156. Compiling data (0 replies)
  157. Exporting worksheet and overwriting (5 replies)
  158. Solved: help on workbook connection vba (4 replies)
  159. Need Excel VBA Help (7 replies)
  160. Shape Fill by Clipboard (1 replies)
  161. Solved: Can this code be shorten vba (4 replies)
  162. Importing .html file into Sheet in Excel in VBA (1 replies)
  163. [SOLVED:] Select the first two similar values (11 replies)
  164. Solved: Dynamic Pivot Table contents (2 replies)
  165. Similar change, multiple worksheets (2 replies)
  166. Search UserForm (0 replies)
  167. Changing cell references to activecell reference (12 replies)
  168. Solved: Syntax error: please help (2 replies)
  169. Accessing records in Recorset (2 replies)
  170. SendInput() in Excel 64Bit (4 replies)
  171. Solved: Worksheet Problem (1 replies)
  172. Solved: Formatting a Multi-Conditional If,Then Statement (1 replies)
  173. Solved: Selecting an Empty Row and range naming the selected cells (1 replies)
  174. [SOLVED:] Concatenate VBA that Keeps Applied Formatting (6 replies)
  175. Solved: countif function (6 replies)
  176. Solved: Loop through two worksheets (2 replies)
  177. Help to update data repeatedly by VBA (5 replies)
  178. Solved: Return a value into a textbox when selecting a worksheet name from a combobox (2 replies)
  179. Edit cells from listbox with userform (5 replies)
  180. Function to count values but not formulae (4 replies)
  181. Solved: delete from nth character (4 replies)
  182. Pivot - Removing Calculated Field (0 replies)
  183. Missing Sequential Number In Station Column (3 replies)
  184. Retain Contents of Clipboard (7 replies)
  185. problem with running event-based macro (1 replies)
  186. Security Level change (9 replies)
  187. Solved: Keep the only Sheet (3 replies)
  188. Solved: Before Close (9 replies)
  189. Copy Images within Selected Cells (2 replies)
  190. Find column (in Excel address) of matching value in array (1 replies)
  191. Macros in Excel (2 replies)
  192. Solved: UserForm event 2 (5 replies)
  193. Solved: Save as date (18 replies)
  194. Excel manual subtotals (2 replies)
  195. Multiple Selections for Data Validation - without Macro (5 replies)
  196. Cut&Paste to another Worksheet Based on Cell Value (1 replies)
  197. Solved: VBA Index/Match Help (4 replies)
  198. Reference workbook cell to another workbook (1 replies)
  199. Macros in Excel (5 replies)
  200. Solved: User Form Control issue (5 replies)
  201. Solved: Print Data into Form (5 replies)
  202. Solved: Userform Event (SOLVED) (2 replies)
  203. Importing Data (4 replies)
  204. Excel VBA works inconsistently..Help me please! (1 replies)
  205. Solved: Username not updating (3 replies)
  206. shapes in Excel VBA (0 replies)
  207. Solved: Problems with code when not in compatability mode (3 replies)
  208. Shift up data according to group ID (3 replies)
  209. PivotTable Annoyance (1 replies)
  210. Check for new highs in dynamic updating cells (7 replies)
  211. SAP to Excel (9 replies)
  212. Solved: Retrieve a value from the last cell and post it in a textbox (4 replies)
  213. Solved: Call Function by name contined in String Variable and Return Value (5 replies)
  214. Sleeper: UserForm ComboBox using data (10 replies)
  215. [SOLVED:] Cell C3 changes Textbox (2 replies)
  216. Solved: User Must Fill Certain Cells before Closing (5 replies)
  217. [SOLVED:] Change font size.. etc from excel to word (6 replies)
  218. Empty Array gives Run Time Error 13 Type Mismatch (3 replies)
  219. Solved: validate data (4 replies)
  220. Enabling "undo" on "time stamp vba code" (4 replies)
  221. Pivot chart help (1 replies)
  222. getting data from SQL Server to Excel and vice versa (2 replies)
  223. Adding multiple series to a graph (1 replies)
  224. Solved: Userform (2 replies)
  225. Maximum Comment Line (2 replies)
  226. [SOLVED:] Draw precedent arrows for formulas in a range (5 replies)
  227. Solved: Controlling Data Entry (2 replies)
  228. Need Hlep with VB Excel Macro Please (8 replies)
  229. Help With a Simple Code Please! (9 replies)
  230. Code to operate within the code window? (8 replies)
  231. Solved: Insert text selected from a combobox into cell (4 replies)
  232. Excel 2010 chart's error (14 replies)
  233. HELP! what is wrong with my code :( (7 replies)
  234. [SOLVED:] Delete shapes before replacing (7 replies)
  235. Problem with sheet protection (7 replies)
  236. Solved: Copy selected filtered sheets to a new workbook (8 replies)
  237. Solved: How to reset Drop-Down (combo box) (2 replies)
  238. Solved: scrollbar zoom (2 replies)
  239. VBA code for Excel forums (1 replies)
  240. k = 5 + 6 + 7 + ... + 14 + 15 (7 replies)
  241. Loop through multiple columns and rows at once. (6 replies)
  242. help with search code on Search and Report All Occurrences of a Word (1 replies)
  243. Solved: shorten this code (8 replies)
  244. Solved: Problem Using If Function in VBA (7 replies)
  245. Solved: "Cancel" selection causes a break in flow (5 replies)
  246. Filtering many pivot tables based on one pivot table (0 replies)
  247. Create Own User form (5 replies)
  248. Solved: VBA and Macro Tutorial (1 replies)
  249. Help with "Protect cell or cells on sheet and protecting sheet (1 replies)
  250. ComboBox (2 replies)