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: Excel insert rows based on value of previous row (2 replies)
  2. Solved: How to format columns on 'Workbook Open' (4 replies)
  3. Cant Shift date problem! (1 replies)
  4. Solved: Colouring ranges based on data being entered by User (7 replies)
  5. Replacement of IF function (1 replies)
  6. Solved: VBA , min of 2 nox , >0 (2 replies)
  7. Solved: how to sum rows in columns with Sun (21 replies)
  8. Solved: Drop-down for each cell under a column (5 replies)
  9. Time Stamp VBA - Need help please! (1 replies)
  10. Sleeper: Identifying the optimal solution in an array (0 replies)
  11. Solved: Worksheet_Change and .PasteSpecial (7 replies)
  12. Solved: Select Date Range (11 replies)
  13. [SOLVED:] Referencing User Selected Workbooks (6 replies)
  14. macros language help ? (3 replies)
  15. Solved: VBA- Smallest non-negative number in a range (12 replies)
  16. Solved: Controlling Dialog Boxes (7 replies)
  17. Solved: Which column is the calling button (mostly) in? (6 replies)
  18. Matching variable formats (0 replies)
  19. Solved: how to detect when the mouse leaves a control on a userform (22 replies)
  20. Solved: Adapt code by Tom Ogilvy (0 replies)
  21. Color Backgrounds for Independant Cells (4 replies)
  22. Solved: Capturing Error Message (4 replies)
  23. Implements Keyword in VBA (2 replies)
  24. Implied Volatility (3 replies)
  25. Solved: Store values meeting certain criteria and paste them into other area (12 replies)
  26. Voltage Ramp (6 replies)
  27. Using Find to Search for a Date (1 replies)
  28. macro deleting important data in column F:EC (2 replies)
  29. How to protect Excel Program more seriously? (1 replies)
  30. Auto shut down of spreadsheet if inactive. (2 replies)
  31. [SOLVED:] Separate every 3 entries into 2 arrays? (or other solution) (9 replies)
  32. Solved: runtime error '1004' unable to set the formula property of the series class. (18 replies)
  33. run time erro 424 (3 replies)
  34. Solved: Compare two workbooks and count matches (0 replies)
  35. Populating sheets with data from another sheet (0 replies)
  36. Solved: formula not changing the row values accorrdingly (2 replies)
  37. Import data file (3 replies)
  38. Solved: Excel to Word: A few issues on the Excel part of things (2 replies)
  39. How to combine 6 different file(but same format) become one (13 replies)
  40. Solved: Copy Paste Cell Value To Word as Text Only (3 replies)
  41. Search as You Type ~~ Narrow down List (18 replies)
  42. Setting checkboxes with Boolean effect (7 replies)
  43. Disable Copy Paste (7 replies)
  44. Solved: search for multiple characters in a cell (2 replies)
  45. For/IF problem (5 replies)
  46. vb help (7 replies)
  47. check my code pls (5 replies)
  48. Need help on loop (4 replies)
  49. Userforms and Other Excel Application (5 replies)
  50. Robin Hammond's Progress Bar? (2 replies)
  51. Solved: Check if 2 Values Exist in 2 Columns (4 replies)
  52. Sleeper: Do copy macro (5 replies)
  53. Solved: Ask for values and save as (6 replies)
  54. Ask for values and delete row (4 replies)
  55. Solved: Confused about Workbooks object (6 replies)
  56. Solved: (12 replies)
  57. Solved: dynamic named ranges (2 replies)
  58. Copy non blank rows from each workbook in a folder to current workbook under eachotha (1 replies)
  59. CheckIn, CheckOut API's - general question (3 replies)
  60. how to run a sumif after formula (5 replies)
  61. [SOLVED:] Moving rows up and down a table with VBA (9 replies)
  62. Worksheet Formulas and VBA (2 replies)
  63. Solved: Scheduling suggestions (13 replies)
  64. Solved: vba copy function (6 replies)
  65. Solved: Multipage and combo box (3 replies)
  66. Solved: Ignore error without converting to number (8 replies)
  67. Copy 2 sheets to Network and rename (5 replies)
  68. Solved: Clean up of Custom Menu items (2 replies)
  69. Solved: OnClick event (2 replies)
  70. Solved: Merge Data between worksheet (3 replies)
  71. Solved: Can text be copied out of a cell to another cell? (6 replies)
  72. [SOLVED:] Help with Case statement (16 replies)
  73. Solved: Enter today's date based on another cell (4 replies)
  74. Lock cell after entry (10 replies)
  75. [SLEEPER:] sum to the last column with data (11 replies)
  76. Solved: Need help easy formula (5 replies)
  77. Solved: Looping through a shapes listbox (2 replies)
  78. Unmerge cells & copy line from above (13 replies)
  79. Set default save path (6 replies)
  80. Solved: Find Multiple Entries Then Delete Row (3 replies)
  81. Solved: duplicate file & strip code from workbook (4 replies)
  82. Solved: Save and encrypt sheets (1 replies)
  83. Solved: sort will not sort - why? (7 replies)
  84. disable print screen (5 replies)
  85. compile error (4 replies)
  86. amend formula (2 replies)
  87. [SOLVED:] Sort Multidimensional Array (13 replies)
  88. Solved: need to add a macro on save (2 replies)
  89. Read and Write Binary Registry Keys (3 replies)
  90. Solved: Using arrow keys to navigate through userform fields (9 replies)
  91. Solved: Do Loop until rowHeight is between two numbers (2 replies)
  92. Solved: Copy Paste from workbook to workbook (4 replies)
  93. Solved: add differenet worksheet names to current macro (3 replies)
  94. Solved: Workbook_Before Close problem (2 replies)
  95. OWC Spreadsheet Scrolling (1 replies)
  96. chart update problem help!! (31 replies)
  97. How do I "install" custom functions (7 replies)
  98. automatically scale pivot chart from highest to smallest (0 replies)
  99. Listboxes - automatically unselecting themselves?! (4 replies)
  100. Solved: Writing data to a table in word from excel vba (2 replies)
  101. Help With MsgBox if duplicate range (10 replies)
  102. Function for of sum of square of mean deviation (7 replies)
  103. Solved: Delete a specific record from an Excel VBA array? (6 replies)
  104. Solved: OnExit (4 replies)
  105. Solved: Set cell value from one workshee equal to found cell in another workbook (3 replies)
  106. Solved: How to Concatenate Text (4 replies)
  107. Sleeper: Implied do loop in excel write # statement (3 replies)
  108. Solved: Filling comboboxes with filtered data (2 replies)
  109. Solved: Workbooks(NewFN).Close SaveChanges:=False Index Issue (3 replies)
  110. Solved: Share a workbook without a prompt (1 replies)
  111. Solved: Unable to connect to Oracle (1 replies)
  112. CSV Files & Userform Problem (0 replies)
  113. Solved: HELP with TRIM !! (4 replies)
  114. Solved: running macro runs the wrong macro (2 replies)
  115. Solved: Select Checkboxes in Internet Explorer (9 replies)
  116. Solved: Calculation not working (3 replies)
  117. VBA Code to pull selected data from a huge database (2 replies)
  118. Solved: How do I delete code from a sheet module under program control? (6 replies)
  119. Solved: How to write VBA code to copy data from Word to Excel? (14 replies)
  120. TextBox to Cell Freeze (2 replies)
  121. Solved: Is Insert > Name > Create evil? (7 replies)
  122. Delete Rows Based on Current Date (7 replies)
  123. Can I edit a source cell from the linked cell? (3 replies)
  124. CombineFiles - Move instead of Copy (8 replies)
  125. A 'floating' rounded rectangle (12 replies)
  126. Solved: VLOOKUP on multiple criteria (3 replies)
  127. Copy cell from multiple sheets, into one row in one sheet (5 replies)
  128. Using a worksheet as a database (2 replies)
  129. Importing tables from multiple HTML files, into one spreadsheet. Please Help (8 replies)
  130. count shapes (8 replies)
  131. select multiple areas in a textbox (0 replies)
  132. Solved: Filling empty cells across workbooks with zero (3 replies)
  133. Solved: Calculating Height of a range (12 replies)
  134. Spreadsheet vlookup help. (15 replies)
  135. Solved: passing data from a list box to a spreadsheet (11 replies)
  136. Solved: Whats the value of y given X (6 replies)
  137. If 3 times greater than delete row (3 replies)
  138. Solved: Referencing using a number for column (5 replies)
  139. elimanate zero while taking minimum value (11 replies)
  140. populating a cell with value from another (2 replies)
  141. Solved: Urgent: Application File Search (11 replies)
  142. Solved: Iterate through columns (1 replies)
  143. Solved: Re-start the value if reached a value (2 replies)
  144. ReDim Question (4 replies)
  145. ctrl c and ctrl v breaks a merge cell (1 replies)
  146. Copy Worksheet (3 replies)
  147. Solved: Open file path (7 replies)
  148. Solved: IF AND PROBLEM (8 replies)
  149. Self defined date format [$-130000] (3 replies)
  150. Solved: Variable Data with Date (11 replies)
  151. Solved: Month and Day swap places when OK cmd button is pressed (10 replies)
  152. Solved: Close all but Activesheet (3 replies)
  153. Solved: Compare date before event execution? (11 replies)
  154. Solved: An N-by-1 variant array throws runtime error when N gets down to 1 (3 replies)
  155. Solved: Sort adds an extra line (3 replies)
  156. Maddening, non-repeatable bug (3 replies)
  157. Solved: Exporting data to another Workbook (4 replies)
  158. Copy Files in a folder into a single Master file. (3 replies)
  159. Error Importing XLS sheet into Access via VBA (1 replies)
  160. Suppressing display of CUM line chart for future periods (3 replies)
  161. Internet Explorer controls error (4 replies)
  162. Find Names and copy to a new sheet (3 replies)
  163. Solved: Inputbox method to pick a range in another workbook (2 replies)
  164. Solved: VBA Speech References Library (2 replies)
  165. Solved: Showing IP Address (5 replies)
  166. Solved: simplifying formulae (10 replies)
  167. Solved: HELP Worksheet.CodeName is not consistent when copying a worksheet into a workbook (3 replies)
  168. Solved: Find, Copy Text from Word and paste in excel (5 replies)
  169. auto print (5 replies)
  170. HELP macro to Delete Row based on two cells (5 replies)
  171. Decimal value of characters in cell (14 replies)
  172. Solved: edit macro cancel step (5 replies)
  173. Drill Down (1 replies)
  174. VBA Macro Code to Enter Intranet's Login/Pass? (1 replies)
  175. Processing Time (3 replies)
  176. Solved: reduce size of macro (6 replies)
  177. Stop skipping rows!! (3 replies)
  178. Solved: User Defined Function not giving fresh results (8 replies)
  179. Changing the time zone (1 replies)
  180. printarea with rectangles (6 replies)
  181. Excel VBA website content copy (0 replies)
  182. Hyperlinks as result in Random Sample (1 replies)
  183. Solved: how to swap firstname lastname in cell? (3 replies)
  184. required fields based on IF statement (2 replies)
  185. form fields in excel (2 replies)
  186. Store ordered list in string. (15 replies)
  187. Solved: Error in Workbook Code (13 replies)
  188. Modify a macros (1 replies)
  189. Solved: Sort specific workbook (2 replies)
  190. Solved: Trim formula needed in condiational formatting (10 replies)
  191. Dynamic Scatterplot (2 replies)
  192. Concatenate From within formula (4 replies)
  193. Parse .txt file (5 replies)
  194. Solved: Trim the fat (4 replies)
  195. Solved: Msg box - if password is wrong (3 replies)
  196. help with a message box on error (2 replies)
  197. How to make a range reaonly or locked or non editable??? (2 replies)
  198. Assign Macro Shortcut (1 replies)
  199. Copy range in new sheet by criteria (2 replies)
  200. Solved: Help on how VBA could attach file to Lotus Notes Email template and save to drafts (3 replies)
  201. Sub or Function not defined - switch off (20 replies)
  202. Tricky worksheet Problem.... (9 replies)
  203. Solved: Check if cell begins with number (5 replies)
  204. Help with Find program (2 replies)
  205. Formatting issues: copy/paste & Ctr-F (8 replies)
  206. VBA script to copy workbook contents (3 replies)
  207. Solved: Dates Screwing up! (16 replies)
  208. Solved: Sort by two criteria (7 replies)
  209. Simple Question, Hopefully (10 replies)
  210. Solved: Function to Return Offsetted Values (2 replies)
  211. Solved: Filtering issue (3 replies)
  212. Solved: How to detect multiple cell selection (4 replies)
  213. VBA script to download data from a url (2 replies)
  214. Help With - For Next Loop & Possible Inclusion of If Statement (2 replies)
  215. VBA Script to open macro dialog box (7 replies)
  216. Useing a variable to control a combobox (2 replies)
  217. Solved: Matching Multiple Cells (8 replies)
  218. Solved: Double Click, Insert Character (10 replies)
  219. Compile Error (4 replies)
  220. Solved: Two arrays and one set of code (4 replies)
  221. Help - Range Values Selection (3 replies)
  222. Check for a particular value and formatting the cell in another sheet (6 replies)
  223. Solved: Consolodating totals for duplicate rows (5 replies)
  224. Color column A if another column equals 2 (1 replies)
  225. Solved: clear data in data based upon a condition (4 replies)
  226. Solved: Stop user accessing worksheet "Administartor" (7 replies)
  227. Cut Paste macro (2 replies)
  228. Page Header: Always 1st Row of ColB of that particular page should appear (2 replies)
  229. Solved: Easiest way to check/uncheck all checkboxes? (5 replies)
  230. easy vb help (6 replies)
  231. Change line color for new series programatically (9 replies)
  232. Look up and sum across sheets? (6 replies)
  233. WorkBook Log-in Access (2 replies)
  234. Solved: Insert a new row after finding text "total" in a cell (17 replies)
  235. Polynomal trend line (1 replies)
  236. Solved: Trouble with Inserting Rows (22 replies)
  237. User function to solve Polynomal equation (0 replies)
  238. Solved: Combobox - Dynamic Named Range (10 replies)
  239. Help with wierd way of doing things (4 replies)
  240. Iterating through an array, and omitting results (4 replies)
  241. Solved: get the name of the selected file. (7 replies)
  242. speed macro using array (4 replies)
  243. Solved: How do I get excel to change the colour of cells dependant on values in other cells? (6 replies)
  244. auto fill (1 replies)
  245. How do I keep a Custom Menu attached to a sheet? (2 replies)
  246. Problems with FileCopy and Wb(name).close (11 replies)
  247. Solved: insert code to show progress (3 replies)
  248. add extra step to macro (4 replies)
  249. Appends the contents to the respective columns (6 replies)
  250. auto print (2 replies)