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. disable print screen (5 replies)
  2. [SOLVED:] Compile error (4 replies)
  3. amend formula (2 replies)
  4. [SOLVED:] Sort Multidimensional Array (13 replies)
  5. Solved: need to add a macro on save (2 replies)
  6. Read and Write Binary Registry Keys (3 replies)
  7. Solved: Using arrow keys to navigate through userform fields (9 replies)
  8. Solved: Do Loop until rowHeight is between two numbers (2 replies)
  9. Solved: Copy Paste from workbook to workbook (4 replies)
  10. Solved: add differenet worksheet names to current macro (3 replies)
  11. Solved: Workbook_Before Close problem (2 replies)
  12. OWC Spreadsheet Scrolling (1 replies)
  13. chart update problem help!! (31 replies)
  14. How do I "install" custom functions (7 replies)
  15. automatically scale pivot chart from highest to smallest (0 replies)
  16. Listboxes - automatically unselecting themselves?! (4 replies)
  17. Solved: Writing data to a table in word from excel vba (2 replies)
  18. Help With MsgBox if duplicate range (10 replies)
  19. Function for of sum of square of mean deviation (7 replies)
  20. [SOLVED:] Delete a specific record from an Excel VBA array? (6 replies)
  21. Solved: OnExit (4 replies)
  22. Solved: Set cell value from one workshee equal to found cell in another workbook (3 replies)
  23. Solved: How to Concatenate Text (4 replies)
  24. Sleeper: Implied do loop in excel write # statement (3 replies)
  25. Solved: Filling comboboxes with filtered data (2 replies)
  26. Solved: Workbooks(NewFN).Close SaveChanges:=False Index Issue (3 replies)
  27. Solved: Share a workbook without a prompt (1 replies)
  28. Solved: Unable to connect to Oracle (1 replies)
  29. CSV Files & Userform Problem (0 replies)
  30. Solved: HELP with TRIM !! (4 replies)
  31. Solved: running macro runs the wrong macro (2 replies)
  32. Solved: Select Checkboxes in Internet Explorer (9 replies)
  33. Solved: Calculation not working (3 replies)
  34. VBA Code to pull selected data from a huge database (2 replies)
  35. Solved: How do I delete code from a sheet module under program control? (6 replies)
  36. Solved: How to write VBA code to copy data from Word to Excel? (14 replies)
  37. TextBox to Cell Freeze (2 replies)
  38. Solved: Is Insert > Name > Create evil? (7 replies)
  39. Delete Rows Based on Current Date (7 replies)
  40. Can I edit a source cell from the linked cell? (3 replies)
  41. CombineFiles - Move instead of Copy (8 replies)
  42. A 'floating' rounded rectangle (12 replies)
  43. Solved: VLOOKUP on multiple criteria (3 replies)
  44. Copy cell from multiple sheets, into one row in one sheet (5 replies)
  45. Using a worksheet as a database (2 replies)
  46. Importing tables from multiple HTML files, into one spreadsheet. Please Help (8 replies)
  47. count shapes (8 replies)
  48. select multiple areas in a textbox (0 replies)
  49. Solved: Filling empty cells across workbooks with zero (3 replies)
  50. Solved: Calculating Height of a range (12 replies)
  51. Spreadsheet vlookup help. (15 replies)
  52. Solved: passing data from a list box to a spreadsheet (11 replies)
  53. Solved: Whats the value of y given X (6 replies)
  54. If 3 times greater than delete row (3 replies)
  55. Solved: Referencing using a number for column (5 replies)
  56. elimanate zero while taking minimum value (11 replies)
  57. populating a cell with value from another (2 replies)
  58. Solved: Urgent: Application File Search (11 replies)
  59. Solved: Iterate through columns (1 replies)
  60. Solved: Re-start the value if reached a value (2 replies)
  61. ReDim Question (4 replies)
  62. ctrl c and ctrl v breaks a merge cell (1 replies)
  63. Copy Worksheet (3 replies)
  64. Solved: Open file path (7 replies)
  65. Solved: IF AND PROBLEM (8 replies)
  66. Self defined date format [$-130000] (3 replies)
  67. Solved: Variable Data with Date (11 replies)
  68. Solved: Month and Day swap places when OK cmd button is pressed (10 replies)
  69. Solved: Close all but Activesheet (3 replies)
  70. Solved: Compare date before event execution? (11 replies)
  71. Solved: An N-by-1 variant array throws runtime error when N gets down to 1 (3 replies)
  72. Solved: Sort adds an extra line (3 replies)
  73. Maddening, non-repeatable bug (3 replies)
  74. Solved: Exporting data to another Workbook (4 replies)
  75. Copy Files in a folder into a single Master file. (3 replies)
  76. Error Importing XLS sheet into Access via VBA (1 replies)
  77. Suppressing display of CUM line chart for future periods (3 replies)
  78. Internet Explorer controls error (4 replies)
  79. Find Names and copy to a new sheet (3 replies)
  80. Solved: Inputbox method to pick a range in another workbook (2 replies)
  81. Solved: VBA Speech References Library (2 replies)
  82. Solved: Showing IP Address (5 replies)
  83. Solved: simplifying formulae (10 replies)
  84. Solved: HELP Worksheet.CodeName is not consistent when copying a worksheet into a workbook (3 replies)
  85. Solved: Find, Copy Text from Word and paste in excel (5 replies)
  86. auto print (5 replies)
  87. HELP macro to Delete Row based on two cells (5 replies)
  88. Decimal value of characters in cell (14 replies)
  89. Solved: edit macro cancel step (5 replies)
  90. Drill Down (1 replies)
  91. VBA Macro Code to Enter Intranet's Login/Pass? (1 replies)
  92. Processing Time (3 replies)
  93. Solved: reduce size of macro (6 replies)
  94. Stop skipping rows!! (3 replies)
  95. Solved: User Defined Function not giving fresh results (8 replies)
  96. Changing the time zone (1 replies)
  97. printarea with rectangles (6 replies)
  98. Excel VBA website content copy (0 replies)
  99. Hyperlinks as result in Random Sample (1 replies)
  100. Solved: how to swap firstname lastname in cell? (3 replies)
  101. required fields based on IF statement (2 replies)
  102. form fields in excel (2 replies)
  103. Store ordered list in string. (15 replies)
  104. Solved: Error in Workbook Code (13 replies)
  105. Modify a macros (1 replies)
  106. Solved: Sort specific workbook (2 replies)
  107. Solved: Trim formula needed in condiational formatting (10 replies)
  108. Dynamic Scatterplot (2 replies)
  109. Concatenate From within formula (4 replies)
  110. Parse .txt file (5 replies)
  111. Solved: Trim the fat (4 replies)
  112. Solved: Msg box - if password is wrong (3 replies)
  113. help with a message box on error (2 replies)
  114. [SLEEPER:] How to make a range reaonly or locked or non editable??? (2 replies)
  115. Assign Macro Shortcut (1 replies)
  116. Copy range in new sheet by criteria (2 replies)
  117. Solved: Help on how VBA could attach file to Lotus Notes Email template and save to drafts (3 replies)
  118. Sub or Function not defined - switch off (20 replies)
  119. Tricky worksheet Problem.... (9 replies)
  120. Solved: Check if cell begins with number (5 replies)
  121. Help with Find program (2 replies)
  122. Formatting issues: copy/paste & Ctr-F (8 replies)
  123. [SOLVED:] VBA script to copy workbook contents (3 replies)
  124. Solved: Dates Screwing up! (16 replies)
  125. Solved: Sort by two criteria (7 replies)
  126. Simple Question, Hopefully (10 replies)
  127. Solved: Function to Return Offsetted Values (2 replies)
  128. Solved: Filtering issue (3 replies)
  129. Solved: How to detect multiple cell selection (4 replies)
  130. VBA script to download data from a url (2 replies)
  131. Help With - For Next Loop & Possible Inclusion of If Statement (2 replies)
  132. VBA Script to open macro dialog box (7 replies)
  133. Useing a variable to control a combobox (2 replies)
  134. Solved: Matching Multiple Cells (8 replies)
  135. Solved: Double Click, Insert Character (10 replies)
  136. Compile Error (4 replies)
  137. Solved: Two arrays and one set of code (4 replies)
  138. Help - Range Values Selection (3 replies)
  139. Check for a particular value and formatting the cell in another sheet (6 replies)
  140. Solved: Consolodating totals for duplicate rows (5 replies)
  141. Color column A if another column equals 2 (1 replies)
  142. Solved: clear data in data based upon a condition (4 replies)
  143. Solved: Stop user accessing worksheet "Administartor" (7 replies)
  144. Cut Paste macro (2 replies)
  145. Page Header: Always 1st Row of ColB of that particular page should appear (2 replies)
  146. Solved: Easiest way to check/uncheck all checkboxes? (5 replies)
  147. easy vb help (6 replies)
  148. Change line color for new series programatically (9 replies)
  149. Look up and sum across sheets? (6 replies)
  150. WorkBook Log-in Access (2 replies)
  151. Solved: Insert a new row after finding text "total" in a cell (17 replies)
  152. Polynomal trend line (1 replies)
  153. Solved: Trouble with Inserting Rows (22 replies)
  154. User function to solve Polynomal equation (0 replies)
  155. Solved: Combobox - Dynamic Named Range (10 replies)
  156. Help with wierd way of doing things (4 replies)
  157. Iterating through an array, and omitting results (4 replies)
  158. Solved: get the name of the selected file. (7 replies)
  159. speed macro using array (4 replies)
  160. Solved: How do I get excel to change the colour of cells dependant on values in other cells? (6 replies)
  161. auto fill (1 replies)
  162. How do I keep a Custom Menu attached to a sheet? (2 replies)
  163. Problems with FileCopy and Wb(name).close (11 replies)
  164. Solved: insert code to show progress (3 replies)
  165. add extra step to macro (4 replies)
  166. Appends the contents to the respective columns (6 replies)
  167. auto print (2 replies)
  168. Dynamic Range over extending issue (10 replies)
  169. How to write a VBA-Excel code to find geometric mean? (4 replies)
  170. Solved: I want to go to "File Save As" as soon as openned (7 replies)
  171. Solved: Days Difference between text box (6 replies)
  172. Row & Column Indicators (4 replies)
  173. Solved: sort ascending leaves blanks at the top (5 replies)
  174. Extracting information after B/C (1 replies)
  175. Multi Tracker Entry Help (13 replies)
  176. Checkboxes and Sheet Protection (4 replies)
  177. [SOLVED:] What is escape character for quotation marks? (4 replies)
  178. Solved: Extracting only part which is within brackats (4 replies)
  179. Solved: PLEASE: Chart Help (2 replies)
  180. Solved: Sub to Open workbooks, and update named ranges (5 replies)
  181. Solved: VBA hide columns or rows based on certain criteria (13 replies)
  182. Solved: UDF to convert long date to "mmmyy" String (7 replies)
  183. Solved: Creating A Shortcut Key (3 replies)
  184. Number of Objects Limitation in Sheet (2 replies)
  185. [SLEEPER:] UserForm: Initialize a ListBox (3 replies)
  186. Excel VBA:ZeroPadding Mixed Number, Text, Number Content in Cell (4 replies)
  187. Shared Workbook Woes (5 replies)
  188. A reminder please, copying range from one ws to another (2 replies)
  189. Solved: sumif feature needed for multiple criteria using wildcards (4 replies)
  190. Running a User Defined Function in VBA (8 replies)
  191. Solved: Copy and Paste - File to File (All files are Password Protected) (7 replies)
  192. Solved: Check cells in an AutoFiltered Range (2 replies)
  193. Solved: Insert blank row, NOT "insert copied cells" (2 replies)
  194. Conditional Formatting with command button (5 replies)
  195. Solved: 2D Arrays (10 replies)
  196. Fix data position (1 replies)
  197. Solved: Writing to a word file from within excel (10 replies)
  198. Help! Excel User prompt for data input (8 replies)
  199. [SOLVED:] Subtotal count (10 replies)
  200. Solved: copy contents of one workbook into another (7 replies)
  201. Date format (3 replies)
  202. Dynamic Form CheckBoxes Controlls (3 replies)
  203. Solved: Returning data based on multiple criteria (8 replies)
  204. Convert to PDF on Legal Size Paper (2 replies)
  205. Adding multiple entries to Time Sheet (4 replies)
  206. Excel 2007 template - issue with vba macros (emailing) (0 replies)
  207. Use text from embedded object (0 replies)
  208. Solved: Run-time error '53': File Not Found (3 replies)
  209. Solved: Combine H and V lookup or better idea? (2 replies)
  210. Copying values (5 replies)
  211. getting a Macro not to call another macro ?? (1 replies)
  212. Excel File Sharing Communication Tool (4 replies)
  213. Solved: Returning an array from a function (6 replies)
  214. Using VBA to copy and paste the content of multiple worksheets to a new files (14 replies)
  215. Solved: vlookup non-contiguous ranges (7 replies)
  216. Solved: Preventing N/A# in Vlookup? (2 replies)
  217. Linked Picture; Add to Comment (14 replies)
  218. vlookup in Vba + preventing tabulations in a form field (2 replies)
  219. Enable paste (6 replies)
  220. [SOLVED:] Help Alter Code (1 replies)
  221. Solved: Excel Charts again (1 replies)
  222. Solved: pb: if condition = true then go to next iteration (2 replies)
  223. problem with combobox (4 replies)
  224. ERROr while running a macro (5 replies)
  225. vba if statement (14 replies)
  226. Solved: swicthing between formulas (5 replies)
  227. Putting variable values in a second sheet (3 replies)
  228. [SLEEPER:] How to automatically trigger a VBA code to respond to expected msgbox (9 replies)
  229. Solved: Worksheet freezes up (3 replies)
  230. Solved: Multiple 'On Error' commands in function doesn't work? (2 replies)
  231. Alpha Testers Wanted (5 replies)
  232. Why is this chunk of code freezing (5 replies)
  233. Copy Paste toggle not working (1 replies)
  234. Solved: Image to Excel (1 replies)
  235. auto filter (4 replies)
  236. BO reports (rep files) need to be refreshed from Excel Module (3 replies)
  237. Excel Chart Lists (0 replies)
  238. Solved: sort without worksheet? (2 replies)
  239. Solved: Using IsInPlace (1 replies)
  240. Why my program gets slow down after running for a while (6 replies)
  241. Why does .address put $ in value (1 replies)
  242. Charting an array as a series (3 replies)
  243. Autofill not working (3 replies)
  244. VBA Code for mail merger & Printing (3 replies)
  245. Copy row from workbook if... (2 replies)
  246. How to write a formula with a bunch of 'IF' statements (7 replies)
  247. Macros Paste Special to another Workbook (2 replies)
  248. Print ranges on worksheet (2 replies)
  249. User Forms behaving strangely (7 replies)
  250. Need help to get rid of unwanted " in text output file from an excel macro (2 replies)