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: Merge Workbooks (23 replies)
  2. Solved: Sort by color (6 replies)
  3. Solved: Shortcut to macro within macro (8 replies)
  4. Solved: Picture Code (5 replies)
  5. Solved: Delete rows based on condition (3 replies)
  6. Solved: Sumif (3 replies)
  7. Adjusting my code:to fill only empty rows (0 replies)
  8. Reinstate User Toolbars Problem (1 replies)
  9. Stupid Button Question (1 replies)
  10. [SOLVED:] More efficient way to use WorksheetFunction in loop? (3 replies)
  11. Most efficient way to copy and paste (1 replies)
  12. Solved: if thisworkbook.visible=true (11 replies)
  13. Importing External Data (2 replies)
  14. find all cells with same ref and subtract accordingly (2 replies)
  15. Solved: Previous Cell (6 replies)
  16. Solved: securing Vb from users (4 replies)
  17. Solved: Insert formula error. (2 replies)
  18. screen updating (1 replies)
  19. Clearing a ListBox (3 replies)
  20. Solved: Sum of certain data for every unique client (7 replies)
  21. Does anyone use MS Excel Macro 4 sheets (5 replies)
  22. Solved: textbox-linecount and individual lines? (3 replies)
  23. Solved: Match one worksheet with another worksheet (18 replies)
  24. Solved: Convert Formula to Return a Row (11 replies)
  25. last 10 procedures entered (4 replies)
  26. Impossible Task Maybe ??!! (9 replies)
  27. hide/unhide columns (2 replies)
  28. networkdays-function (28 replies)
  29. Open Lotus Notes mail with password and send the actice sheet (0 replies)
  30. Sleeper: Excel access Internet throgh Proxyserver (0 replies)
  31. Copy VBA code (2 replies)
  32. Solved: Protect worksheet / Worksheet event (5 replies)
  33. Solved: VBA code to insert a formula (27 replies)
  34. Solved: Reading data from .txt file to excel in the format as in attachment (7 replies)
  35. Retrieving different ranges of data from different workbooks (6 replies)
  36. Solved: Highlight entire row when item is found. (2 replies)
  37. Are youlimited to the number of macro's in Workbook (10 replies)
  38. Solved: get Location count and get next Location (9 replies)
  39. CELL (1 replies)
  40. Solved: VB Components (2 replies)
  41. Extract data from a table. (4 replies)
  42. Solved: Counting Multiple Cell Values (2 replies)
  43. Solved: Put data in Text Box via a Variable (12 replies)
  44. Array Constant (3 replies)
  45. Macro for multiple charting of multiple datasets (8 replies)
  46. An If formula? (2 replies)
  47. [SOLVED:] Find last " " (space) in String (8 replies)
  48. copying data (1 replies)
  49. avoide an error (1 replies)
  50. Guidence: Provide Functional Update To an Existing WrkBk (5 replies)
  51. Solved: New instance of excel (14 replies)
  52. Solved: Problem with INDEX , MATCH (2 replies)
  53. [SLEEPER:] Column Sort as per Template (1 replies)
  54. Solved: Map Network drive and save (6 replies)
  55. Solved: Problem with comparing (2 replies)
  56. replace function (9 replies)
  57. determine the last save (5 replies)
  58. [SOLVED:] Use one procedure to end another (3 replies)
  59. Trigger New Task in Outlook (2 replies)
  60. Solved: Practical limit to size of array? (2 replies)
  61. Aged Analysis Of Stock (14 replies)
  62. Referring to Trendline by name (1 replies)
  63. Solved: how to hide drop-down list of pivot tables (9 replies)
  64. Clearer example (5 replies)
  65. Sleeper: Progressor in status bar (4 replies)
  66. Solved: check if a cell has a bottom border (4 replies)
  67. Place formulas by criteria VBA (6 replies)
  68. Listview and hh:mm format (4 replies)
  69. finding last row (5 replies)
  70. Solved: Parse XML Attributes with Excel VBA (35 replies)
  71. Solved: Automatic Sort After Data Change (9 replies)
  72. string name same as sub name - dynamic (1 replies)
  73. Solved: Help with lookup and reference (7 replies)
  74. Solved: set password on command button for macro (12 replies)
  75. Solved: Detect if a workbook is open (1 replies)
  76. Solved: Format certain cells in a worksheet (4 replies)
  77. Autofilter based on value in particular cell (1 replies)
  78. Amount in word (2 replies)
  79. Getting rid of extra spaces at the end (9 replies)
  80. [SOLVED:] Send an email from Excel without notifying the user (8 replies)
  81. Solved: Leading zero's for a SSN # (5 replies)
  82. Solved: Run Time 1004 error (10 replies)
  83. reset filter mode (2 replies)
  84. Solved: Comparing 2 sheets + copying data from 1 sheet to the other sheet (6 replies)
  85. Solved: Weekday from date (2 replies)
  86. Field validation / conditional format (2 replies)
  87. Read from txt file in utf-8 (1 replies)
  88. Detect an unprotected worksheet automatically (2 replies)
  89. Solved: Text Box Data to be Copied: (13 replies)
  90. clock in statusbar (1 replies)
  91. Solved: Text Boxes to be Initialized: (3 replies)
  92. shifting focus to excel (1 replies)
  93. Add new name to dynamic range problem (4 replies)
  94. Excel Track Changes (0 replies)
  95. Transfer Data from a Database (8 replies)
  96. error number (4 replies)
  97. Solved: Copy and Paste from several workbooks to master workbook (20 replies)
  98. Help with macro code alteration if possible? (25 replies)
  99. Solved: Update biweekly date period (6 replies)
  100. Solved: Identify array element (4 replies)
  101. [SOLVED:] Double click to bring up userform (3 replies)
  102. Solved: VLOOKUP?s 3rd Arg ? Why Needed?? (5 replies)
  103. Solved: Sorting rows between rows (12 replies)
  104. list of vb projects (7 replies)
  105. Solved: Edit Textbox after Format (6 replies)
  106. How can I speed this up? (3 replies)
  107. [SOLVED:] VBA Projects Remain Open (1 replies)
  108. How Can I tap into Excel's "Insert Hyperlink" Dialog box (4 replies)
  109. toolbar do not show (5 replies)
  110. error message (2 replies)
  111. Solved: Like DSUM function (5 replies)
  112. Solved: How to colour tags? (5 replies)
  113. open specific module (2 replies)
  114. Solved: Stop Excel process (3 replies)
  115. Solved: Changing NumberFormat (3 replies)
  116. Solved: What Does VLOOKUP Compare to?? (7 replies)
  117. Solved: Macros and Formulas (2 replies)
  118. Solved: Excel VBA to format Word doc (2 replies)
  119. Solved: Update Values (1 replies)
  120. Newbie question re:Userform/ComboBox (4 replies)
  121. determine if a sheet exist (5 replies)
  122. Solved: ListBox Question (4 replies)
  123. RefreshAll web query problem (1 replies)
  124. Solved: The Agony of Defined Name Overrides (6 replies)
  125. Solved: The .FIND Method ... Arrrrrgh! (12 replies)
  126. Solved: Fill contents of blank cell based on cell value above (6 replies)
  127. [SOLVED:] Code wanted! (5 replies)
  128. Inbedded Objects with links (0 replies)
  129. Open new excel and keep existing data (10 replies)
  130. Get VBA to check if cells empty before autofill? (8 replies)
  131. Date Problem (4 replies)
  132. Solved: find the FIRST used row and column (4 replies)
  133. Adding characters to hyperlinks. (5 replies)
  134. Solved: reset Excel sheet count? (13 replies)
  135. Solved: "Dynamic" Range (for lack of a better term) not 'registering' (2 replies)
  136. Solved: Help! Next empty cell question (6 replies)
  137. Solved: Making room for a date (6 replies)
  138. No records found (8 replies)
  139. Early?late Binding? (2 replies)
  140. Solved: VLOOKUP or some other way (12 replies)
  141. Picture in Worbook or in Userform (3 replies)
  142. Solved: Adding and Deleting Comments (7 replies)
  143. Auto Filter Again (3 replies)
  144. Solved: Is possible to have the same (3 replies)
  145. Solved: Contents of a dropdown Box (10 replies)
  146. Solved: Check Cell Contents In A Column (2 replies)
  147. Solved: This one may be WAY TOO DIFFICULT (12 replies)
  148. find a module (0 replies)
  149. Solved: Characteristics of an AutoShape Connector (2 replies)
  150. Using an Automatic Max Scale on Charts (5 replies)
  151. Error Report (3 replies)
  152. Solved: Auto filter (2 replies)
  153. date comparison on two ranges (2 replies)
  154. How to make 2 worksheet events work together (7 replies)
  155. Solved: Chart on a UserForm (8 replies)
  156. Solved: CopyFile If (6 replies)
  157. Solved: Check if List box has anything selected in it (10 replies)
  158. clear non integers (6 replies)
  159. Diifficult Range & Sum (3 replies)
  160. Linking two procedures (1 replies)
  161. Solved: Fill an array an easier way (12 replies)
  162. [SOLVED:] Insert blank row for each full row (23 replies)
  163. Solved: Kill all combo boxes w/ one shot (2 replies)
  164. check a cell to see if it has a currency code (7 replies)
  165. tab to certain cells (2 replies)
  166. speed up macro VBA (11 replies)
  167. Solved: Extract Data from a Alphnumeric String (21 replies)
  168. [SOLVED:] cut & paste assistance needed (6 replies)
  169. txt files import into excel (2 replies)
  170. Copy and paste help required (26 replies)
  171. export a range (16 replies)
  172. Solved: VBA Macro to Print (10 replies)
  173. Solved: Sum only Positive or Negative number (8 replies)
  174. Solved: user form control problem - using names in loop (3 replies)
  175. Spreadsheet errors (10 replies)
  176. matching 2 column and return value (1 replies)
  177. Calculating interest earned on accounts (5 replies)
  178. Solved: How does one create a calendar (12 replies)
  179. How to delete a worksheet from running code (3 replies)
  180. Solved: Using VLOOKUP (16 replies)
  181. Solved: How to Detect Formula Is Present (7 replies)
  182. Solved: left upto space (5 replies)
  183. Solved: taking a portraite page to less landscape (3 replies)
  184. Solved: else and else if with part text (3 replies)
  185. To "credit" or not? (12 replies)
  186. '1004 Error' Message (2 replies)
  187. Solved: Update links prompt (2 replies)
  188. Solved: Quick question on Filter (8 replies)
  189. find text format (1 replies)
  190. export styles (1 replies)
  191. Solved: Dynamic named range (2 replies)
  192. Advanced filter question (2 replies)
  193. Solved: Search for word and delete text (1 replies)
  194. Copy and paste from IE to book (1 replies)
  195. Browse Function (4 replies)
  196. Solved: Copy rows based on user selection (3 replies)
  197. Solved: How to run update query on Access table from Excel VBA (7 replies)
  198. Solved: Userform displays ? for cell text that uses "Alt+Enter" (4 replies)
  199. Solved: Scripting.Dictionary question (9 replies)
  200. Finishing touches (6 replies)
  201. Solved: Command button to add items on Userform (2 replies)
  202. Query for data from a Web page (0 replies)
  203. tick boxes (1 replies)
  204. Searching all workbooks in a folder (9 replies)
  205. Progress Bar (2 replies)
  206. Dialogs... (4 replies)
  207. Solved: API Call not working (7 replies)
  208. Solved: Merge ranges based on condition (1 replies)
  209. line of code (4 replies)
  210. Conditional Formatting for data groups (4 replies)
  211. Solved: Macro to insert new worksheet (8 replies)
  212. List Box (8 replies)
  213. Solved: Input Box (8 replies)
  214. Pivot (3 replies)
  215. [SOLVED:] Add a day to a date (4 replies)
  216. Highlight range used in formula (2 replies)
  217. Solved: Copy sheets into 1 workbook (2 replies)
  218. Solved: Kangaroo Problem (4 replies)
  219. Issues with arrays/collections/etc (7 replies)
  220. Solved: How do I say "begin with" (16 replies)
  221. Solved: vlookup and the value #N/A (4 replies)
  222. detect if Outlook is open (11 replies)
  223. Solved: Code From excel-97 To Excel 2003... (2 replies)
  224. Solved: I have to tell you this (3 replies)
  225. Solved: Color Names (4 replies)
  226. Solved: Problems Working with Protection (12 replies)
  227. Query Access from Excel (8 replies)
  228. Solved: concatenating & shifting cells (7 replies)
  229. Solved: Disable Workbook_Open macro when opening another workbook (2 replies)
  230. Delete row if cell is empty (25 replies)
  231. copy all modules (25 replies)
  232. Solved: TMP (9 replies)
  233. replace all (4 replies)
  234. reverse columns (2 replies)
  235. Help with user forms add and subtract (14 replies)
  236. Hyperlink issue with LOCAL range names - sheet name change kills hyperlink address (4 replies)
  237. Solved: Faster than Vlookup (3 replies)
  238. Solved: Function Won't Execute On Spreadsheet (7 replies)
  239. Solved: Heat Index Formula (9 replies)
  240. Complex numbers in VBA (5 replies)
  241. repeate an action (3 replies)
  242. Solved: Remove blank rows (3 replies)
  243. Solved: work rates (4 replies)
  244. How do I change the type of recipient of an automated email (1 replies)
  245. Multiple range copy and paste (8 replies)
  246. Not close thead when I close excel (0 replies)
  247. Solved: Progress Bar Help (7 replies)
  248. Solved: Defining font colors in range (7 replies)
  249. Solved: Need To Know How To: Reference a column Range in VB (1 replies)
  250. Solved: Error handling (4 replies)