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. Redundancy search and paste (1 replies)
  2. Unhide specifc row based on cell (1 replies)
  3. Activating a column based in the other column value (7 replies)
  4. How to randomise looping of variables (1 replies)
  5. Solved: Table of Contents (3 replies)
  6. Copy and Paste Macro (16 replies)
  7. Solved: Sum or Sumproduct help (5 replies)
  8. Solved: Delete all the tabsheets with their names (2 replies)
  9. Excel only runs my sub procedure once? (5 replies)
  10. Name a Range (2 replies)
  11. Formula R1C1 (4 replies)
  12. Code to loop through cells and find component of Formula (13 replies)
  13. Solved: Dynamic Custom Header/Footer (8 replies)
  14. How use same code in other excel workbooks (1 replies)
  15. Solved: A variable within a variable (within a variable?) (13 replies)
  16. Conditional formating based on Value = Range (4 replies)
  17. Open email template files based upon combo box values (1 replies)
  18. Solved: Count words equal between 2 cells (3 replies)
  19. Solved: Autofilter and Copy Data to new workbook (2 replies)
  20. Solved: Paste Range Of Cell Values From Formulas ?? (2 replies)
  21. Blank Userform? (17 replies)
  22. Finding multiple words up to 10 different columns (5 replies)
  23. VBA code to create list of conditional formatted ranges (9 replies)
  24. [SOLVED:] Help to create a back up workbook vba (4 replies)
  25. highlight all text in textbox - only fix (13 replies)
  26. Searching and autofiltering the result on the same worksheet. (2 replies)
  27. [SOLVED:] Long hyperlink bypass (7 replies)
  28. Solved: Cells highlighted during selection. (2 replies)
  29. Insert rows using a macro button. (2 replies)
  30. Formula problem (7 replies)
  31. Formula problem (5 replies)
  32. Problems making VBA code to create start, pause & resume command (5 replies)
  33. Break for next loop (2 replies)
  34. Solved: Excel Crashing Problems HELP (23 replies)
  35. Solved: Help on environ validation before opening file (2 replies)
  36. Solved: Process Summary Report from Array of Data (6 replies)
  37. Synchornize Excel sheets (2 replies)
  38. Make dictionary (5 replies)
  39. fill cells with vba (2 replies)
  40. combine cells with VBA (30 replies)
  41. populate cbo box (7 replies)
  42. Graphing help in excel vb (2 replies)
  43. Solved: read text file question (4 replies)
  44. Solved: Filter problem (7 replies)
  45. Solved: Display currency value in red (3 replies)
  46. Solved: Convert to function (8 replies)
  47. how to copy data (some of them) and copy in an other sheet) (5 replies)
  48. vba (18 replies)
  49. Last visible row or column in a worksheet (12 replies)
  50. VBA code to convert Excel file(including hiddenfiles) (1 replies)
  51. Solved: Multiple force entry (2 replies)
  52. Modify sheet2 (2 replies)
  53. Class problems (8 replies)
  54. Solved: changing textboxes' properties programmatically in a userform (13 replies)
  55. Solved: Multiple output function (2 replies)
  56. [SLEEPER:] Help to decrease processiong time vba (5 replies)
  57. Clean and Proper difficulties (8 replies)
  58. AutoFit Columns (4 replies)
  59. Solved: perfect weight (6 replies)
  60. Solved: is there a limit on expressions in IF Conditions in Excel VBA (2 replies)
  61. cdate type mismatch (2 replies)
  62. Excel Date formatting problem (12 replies)
  63. Solved: Replace function (6 replies)
  64. Check for Empty Controls in Userform (2 replies)
  65. Moving sheets in a workbook (3 replies)
  66. User Form Question (3 replies)
  67. Workbook being deleted (1 replies)
  68. Better way to copy text files to a daily report? (0 replies)
  69. Solved: Lookup and use left characters (4 replies)
  70. Solved: blink cell (2 replies)
  71. Passing user defined range into function? (6 replies)
  72. Solved: Msgbox if Something is Entered Different from Values in Combobox (2 replies)
  73. Solved: Delete freeform positioned over chartobject (2 replies)
  74. Solved: Get selected Date (1 replies)
  75. View Calendar (17 replies)
  76. Skipping Cells on a Loop (24 replies)
  77. Batch File Renamer (5 replies)
  78. Module to Delete rows by multiple column criteria (2 replies)
  79. Simple input and data problem (3 replies)
  80. problem with if, then, else (8 replies)
  81. Delete freeform from spreadsheet (0 replies)
  82. Worksheet Calculate Question (2 replies)
  83. Solved: Combine Few Sheets to one summary sheet (1 replies)
  84. retrieve data from web (0 replies)
  85. how to combine GetItems() - syntax (2 replies)
  86. Excel Template mode (6 replies)
  87. Solved: Sort and search on a table (2 replies)
  88. Indicating calendar (1 replies)
  89. Object Required (4 replies)
  90. Multiple criteria, one value (0 replies)
  91. function variables show on sheet (5 replies)
  92. Solved: Copying a file when the source file is open. (4 replies)
  93. Solved: Date format problem (3 replies)
  94. Forms vba excel 2007 (2 replies)
  95. webquery macro for website with drop down menus (3 replies)
  96. Transpose help. (2 replies)
  97. Solved: fixing code - automaticaly handling with many of combobox, labels... (5 replies)
  98. Generate Unique Reference Numbers on a userform (4 replies)
  99. Solved: Need Macro to Replace ## with the Column Heading Name (2 replies)
  100. Using if then else in excel 2007 (0 replies)
  101. Solved: Filtered report issues. (1 replies)
  102. Help exporting values to text file (1 replies)
  103. macro for pivot (1 replies)
  104. [SLEEPER:] Deleting a row that has certain characteristics (1 replies)
  105. Solved: Class Member (6 replies)
  106. Sum if function (4 replies)
  107. Event macro does not run until I leave and return to a cell (1 replies)
  108. Solved: Copy and pasting ONLY selected cells (2 replies)
  109. Solved: Renaming cells (2 replies)
  110. Run-time error 457 (1 replies)
  111. KB Article: Creating multiple word tables from excel data (1 replies)
  112. Add an HTML file as body of email (0 replies)
  113. Solved: button that follows by click unables copying (8 replies)
  114. Internet Form Submission (0 replies)
  115. compare values and paste in another woksheet (1 replies)
  116. Solved: Dynamic Sum Macro (5 replies)
  117. Solved: Extracting required information (8 replies)
  118. Post excel cell data to Ms Publisher (0 replies)
  119. How to open speadsheet on server populate with data then save and close it (0 replies)
  120. Solved: Can anyone confirm the destructive effect of Exceldiet in the following case? (9 replies)
  121. Solved: Write function in forms (1 replies)
  122. vba form check against text file (1 replies)
  123. Solved: Combining Dynamic Ranges (6 replies)
  124. Solved: Find unique values (2 replies)
  125. Solved: Delete Menu if exists (8 replies)
  126. Data Portal Design Requires Advanced Coding (4 replies)
  127. Solved: Delete empty rows (2 replies)
  128. Prevent various functions in document (6 replies)
  129. Solved: Write in Col J just Before close (5 replies)
  130. Simple way to reduce the size of the Excel file (0 replies)
  131. Exceldiet deletes entire worksheet (0 replies)
  132. Solved: VBA: Values on Sheet (9 replies)
  133. Combobox linked to Listbox (4 replies)
  134. Solved: Help needed (2 replies)
  135. DELETE ROWS BASED ON DATE RANGE (12 replies)
  136. Solved: Problem with macro (20 replies)
  137. auto run a macro upon text entry into cell (4 replies)
  138. Help to calculate end date for each Dept VBA (1 replies)
  139. Solved: Search box on an user form (2 replies)
  140. How to display updated process on userform for user (1 replies)
  141. pivot table filters problem (0 replies)
  142. [SOLVED:] Multiple Regular expressions on one cell to extract to new cells (3 replies)
  143. Solved: Multiple files (5 replies)
  144. Solved: Multiple values using SUMPRODUCT (10 replies)
  145. List all files in a folder or import filenames into a merged document (1 replies)
  146. [SLEEPER:] Event macro for auto-fit row height of merged cells (4 replies)
  147. Excel sending emails from a worksheet (1 replies)
  148. Searching an array using two criterias (5 replies)
  149. how to close a workbook on network when its open by another user. (7 replies)
  150. Solved: Hidding button on worksheet depending on password (4 replies)
  151. Multithreading Excel and Word (0 replies)
  152. Search and copy data (Macro) (0 replies)
  153. Solved: Activating sub from another workbook (12 replies)
  154. Update everyday at 2:30 (1 replies)
  155. Create a date entry for each day of the month (3 replies)
  156. Solved: Copy and past in next available row (3 replies)
  157. Getting a total copied set of rows in VBA and storing it in a variable (1 replies)
  158. Locking the name of a range (1 replies)
  159. Solved: Accessing The Reference Cell Contained In The Excel VLookUp() Function From VBA !! (2 replies)
  160. Sleeper: Copy and pasting selection of data (0 replies)
  161. Unable to set the XValues property of the Series class (1 replies)
  162. Solved: Moving rows from one sheet to another using vlookup (3 replies)
  163. Solved: Dealing with dates in macros (6 replies)
  164. Solved: Word to excel & 'clip' (2 replies)
  165. problem:filter pivotable with 2 text cells (9 replies)
  166. Create sheets from master but copy them to new book (7 replies)
  167. Solved: Counting account numbers (6 replies)
  168. Ask: Pull data from another sheet with macro (excel 2003) (0 replies)
  169. Solved: Placing text in a next empty Cell with VBA (3 replies)
  170. Solved: Range("e1").Row = 5 not e (4 replies)
  171. Solved: Can't manage to rename updated version (13 replies)
  172. Solved: Apply code to second to last line of spreadsheet (4 replies)
  173. SEPARATE ROWS WHEN CONDITIONS MET (2 replies)
  174. Simple Supply and Demand Model using Solver (15 replies)
  175. conversion of VBA to vb.net (4 replies)
  176. Manipulating recordset (1 replies)
  177. Copy data from first workbook to a different workbook based on cell value in first (1 replies)
  178. Copying data from one sheet to a specific range of cells in a different workbook (1 replies)
  179. Solved: Mark as XXXXX (18 replies)
  180. Solved: Apply formula to all cells in a column (2 replies)
  181. Solved: Bold last row of spreadsheet (5 replies)
  182. Limiting array size (1 replies)
  183. Solved: Cells with zero or no value - amend (1 replies)
  184. Solved: Moving row to another space (2 replies)
  185. Solved: Tweeking formula (2 replies)
  186. Hide CMD window that script shows. (1 replies)
  187. If there is no chart on activesheet, then go to NoChart. (1 replies)
  188. Tabs to different work books. (6 replies)
  189. Solved: Inserting cells in between entries (2 replies)
  190. Help Understanding Code Dealing with Creating New Spreadsheets (1 replies)
  191. When file is open Automatically run VBA (7 replies)
  192. Solved: Filling a formula (9 replies)
  193. Combo/List Box populated by user form entries (4 replies)
  194. Adding header data during data extraction (8 replies)
  195. [SLEEPER:] Check port is up from VBA (Excel) (5 replies)
  196. [SOLVED:] VBA script doesn't run (11 replies)
  197. Solved: Paint next three columns (2 replies)
  198. Solved: Select End Row (2 replies)
  199. Solved: Onaction property (8 replies)
  200. Extracting Model Numbers (2 replies)
  201. Solved: Can these 2 VBA's be combined (6 replies)
  202. Solved: Drive Letter (3 replies)
  203. Solved: Footer Capation (4 replies)
  204. Best use of memory (5 replies)
  205. Solved: Colour Cells (6 replies)
  206. Solved: VLOOKUP (2 replies)
  207. Solved: Application display alert question (2 replies)
  208. Copying Multiple worksheets in Multiple workbooks to one single workbook (2 replies)
  209. Solved: Search Range of numbers and return missing (5 replies)
  210. Solved: commandbutton that "follows" cursor (7 replies)
  211. Selecting Sheet via Input Box or other way (2 replies)
  212. VLOOKUP error codes in VB (10 replies)
  213. Solved: vba help to automate report. (8 replies)
  214. VLOOKUP - works on 1 form but not on another (2 replies)
  215. Solved: Finding and highlighting duplicate names (2 replies)
  216. [SOLVED:] Copy data fom 1 workbook to another, where itneeds to go to 2 different worksheets (7 replies)
  217. Solved: Need help to change column to comma style (2 replies)
  218. Solved: Data Validation Macro Problem (18 replies)
  219. Solved: Select defined range (3 replies)
  220. Solved: Dates as X-Axis for multi-series line or xy chart (2 replies)
  221. Solved: If Or Statements with VLookup (2 replies)
  222. Solved: Can these 2 VBA codes be merged in to 1 (2 replies)
  223. VBA: Selecting and Copying Columns [more complex than it sounds] (8 replies)
  224. Solved: Filling a formula (4 replies)
  225. Moving rows from one spreadsheet to another (2 replies)
  226. Error in expression (4 replies)
  227. Problem with my search/replace macro (11 replies)
  228. Making a workbook visible again (1 replies)
  229. [SOLVED:] referencing information between userforms (1 replies)
  230. Problem with Interactive Graph with Rollover Hyperlinks and UDFs (1 replies)
  231. Cell references (1 replies)
  232. Drop down boxes and forms (3 replies)
  233. Select OLEobject checkbox PROGRAMMATICALLY??? (1 replies)
  234. Solved: removing part of string (9 replies)
  235. VBA: selecting data to be outputted to new sheet (7 replies)
  236. Solved: Vba debugging Run-time error '1044': (6 replies)
  237. Solved: Excel VBA comparison wierdness / challenge (4 replies)
  238. Help to generate week ending from days as per financial new (3 replies)
  239. How to add formula and value to cell VBA (1 replies)
  240. Runtime error 1004 (10 replies)
  241. macro to find and replace #ref errors with actual cell values, and stop at last sheet (1 replies)
  242. veiw variable/ array values during debug (1 replies)
  243. Solved: refer to value in a cell in a macro (1 replies)
  244. Solved: Deleting rows based on column content. (3 replies)
  245. Need help altering Planner VBA (1 replies)
  246. Applying formulas to certain cells (3 replies)
  247. Solved: loop in a loop (10 replies)
  248. locking cells without sheet protection (8 replies)
  249. Solved: ComboBox (SOLVED) (2 replies)
  250. Solved: Disable "save changes" pop up when closing (2 replies)