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. Solved: How to discover repeat text names in Range array? (3 replies)
  2. Combining Macros (3 replies)
  3. Solved: issue with using DATEValue in VBA, with VLookup (2 replies)
  4. CAll a macro on entering data to a cell under a column (3 replies)
  5. Solved: If Without Block If (2 replies)
  6. Contingent row copy (make duplicates) (18 replies)
  7. Solved: Zipping files in a folder using VBA (10 replies)
  8. Solved: How to create listing in Combo box of User Form (10 replies)
  9. SUM VISIBLE COLUMNS ONLY (16 replies)
  10. Solved: Disable Web site auto linkage to Excel (3 replies)
  11. Solved: Hiding & Unhiding Columns base on a Data Validation or Cell value (1 replies)
  12. placing a floating combobox on top of a cell in OWC11 spreadsheet using VBA (0 replies)
  13. Solved: Using Start and End Date via a form? (1 replies)
  14. Solved: Using two commands in Excel 2007 (4 replies)
  15. Solved: Problems Distribute Excel Add-Ins in a high demand environment (3 replies)
  16. Copying multiple column data in multiple sheets to one column in Master sheet (13 replies)
  17. Solved: Copy sheet to new workbook without copying the code? (4 replies)
  18. [SOLVED:] 2007 compatibility (41 replies)
  19. Solved: Moving to London: Is anyone interested in hosting my duplicate master webpage? (21 replies)
  20. Solved: Compile error in hidden module (3 replies)
  21. Solved: Adding days when checkbox checked (2 replies)
  22. delete row if column f is blank (2 replies)
  23. Exporting to c:\test.txt problems (3 replies)
  24. Login Secure site (6 replies)
  25. Solved: Search row for text and delete column if equal to a value (5 replies)
  26. Solved: Copy bookmarks to Excel (1 replies)
  27. Solved: Data Validation -- Combo box VBA (29 replies)
  28. Changing cells' format (8 replies)
  29. Solved: creating Chart using Dynamic ranges.. (2 replies)
  30. Vlookup for user form (16 replies)
  31. Solved: reformatting spreadsheet (3 replies)
  32. Solved: Auto update data fm one Worksheet to another Worksheet (7 replies)
  33. How 2 ntermittently pause recalculation process & read the dispalyed statusbar text? (4 replies)
  34. Why is my alignment vba code not working. (10 replies)
  35. Chart axes setting problem (6 replies)
  36. Funny: Excel 12 Help file! (1 replies)
  37. Countdown timer (9 replies)
  38. Get Last Accessed Date/time (8 replies)
  39. Unexplained Error with code (2 replies)
  40. 'CurrentRow' Expression & Skipping through records (12 replies)
  41. Solved: Conditional Deleting of Rows (1 replies)
  42. Solved: Named Range Across Sheets (7 replies)
  43. Solved: excels analysis tools (1 replies)
  44. Solved: find max in multi dimensional array (6 replies)
  45. Solved: Worksheet Copy creates new Workbook (5 replies)
  46. Problem with my vba code (3 replies)
  47. Workbook_Open executes after a pop-up box (2 replies)
  48. Trying to Split a long string in same cell (6 replies)
  49. Help me creating files index (2 replies)
  50. print and name PDF file (2 replies)
  51. Solved: PasteSpecial and Selection Areas (4 replies)
  52. Importing data from another workbook causes error 9 message (15 replies)
  53. Solved: Splash Screen (2 replies)
  54. Excel sheet focus problem (12 replies)
  55. Assigning cell values (2 replies)
  56. Match headers when importing text files (3 replies)
  57. [SLEEPER:] Loop through cells values on each button click (2 replies)
  58. Solved: Writing a formula in another sheet. Should work but I get #NAME? (5 replies)
  59. Problem with codes on different machines (16 replies)
  60. Copy preferred row to same named Sheet (16 replies)
  61. Solved: Displaying cell data in inputbox text (2 replies)
  62. Solved: CREATE 2X1 MATRIX IN EXCEL AND PULL FROM THIS (13 replies)
  63. [SOLVED:] Changing chart titles using VBA (2 replies)
  64. changing ctart titles using VBA (2 replies)
  65. dynamic formula help (6 replies)
  66. Solved: Simple Encryption (7 replies)
  67. Password protect the macro coding (3 replies)
  68. Copy data from Pivot Table (2 replies)
  69. Find a word and extract data to another sheet (14 replies)
  70. Solved: Treeview & Imagelist relationship (11 replies)
  71. [SOLVED:] Trig help (9 replies)
  72. Solved: Incrementing a cell that has a forumla in it (1 replies)
  73. Solved: If Cell Value is Worksheet Name Copy Row (17 replies)
  74. How to find row from address (7 replies)
  75. VBA Excel Helper Subprocedures;Homework (4 replies)
  76. get Column Letter (6 replies)
  77. file size (3 replies)
  78. "Create a unique list and count of items from an unsorted list" Help (6 replies)
  79. Solved: Any tutorials about adding items by typing into a Combobox? (12 replies)
  80. Solved: Autofilter problem (10 replies)
  81. [SOLVED:] Inserting columns late - hours of regression testing (3 replies)
  82. Trying to import data from one excel sheet to another (7 replies)
  83. Poor efficiency: Code runs too long (3 replies)
  84. Solved: links (13 replies)
  85. Dynamically look between Paranenthesis (1 replies)
  86. next iteration in loop (5 replies)
  87. Copy data from Excel to Word with gif image (1 replies)
  88. Copy and Offset?? (1 replies)
  89. Adding radio buttons and counter on excel test sheet? (3 replies)
  90. Solved: Adding form data to two sheets (3 replies)
  91. Solved: cell is not emtpy even if no visible value (2 replies)
  92. [SOLVED:] Deleting rows based on criteria (3 replies)
  93. [SOLVED:] Log on to a password protected website to view info (2 replies)
  94. Creating Arrays within Pivottables (0 replies)
  95. [SLEEPER:] Which function uses Minimum Resource, Minimum Calculation Time? (6 replies)
  96. Input mask (3 replies)
  97. Solved: Export/Import data to multiple workbooks? (4 replies)
  98. Solved: using countif in code (1 replies)
  99. Clearing extra characters from imported data? (2 replies)
  100. Solved: Clear cells where using a certain font (19 replies)
  101. User Input (1 replies)
  102. Solved: Workbook Directory path (8 replies)
  103. Solved: compare value of two cells to value of two columns in dynamic array (2 replies)
  104. Solved: delete sheet based on cell value (6 replies)
  105. VBA as One User Defined Function: Homework (4 replies)
  106. Manipulating Chart objects (1 replies)
  107. Solved: Using office assistant to display custom messages (1 replies)
  108. Solved: Leading Zeros Truncated (2 replies)
  109. macro to save a Worksheet (2 replies)
  110. Solved: Copy Specific Cell in Rows and Columns to Another Worksheet (34 replies)
  111. Variable column in code (10 replies)
  112. Macro to hide blank rows in Workbook (12 replies)
  113. VBA Case Statement verification; Homework (2 replies)
  114. Solved: Help transfer excel table to access db (18 replies)
  115. Select Case Statements; Homework (1 replies)
  116. Concatenated Message Box: Homework (9 replies)
  117. VBA Help: Homework (3 replies)
  118. Solved: Help with For....Next, and some useful code for everyone (23 replies)
  119. Dir function returns fileNames not as expected (6 replies)
  120. Advice and Tips for instr & for Findnext (5 replies)
  121. VBA Sub Procedures; Homework (12 replies)
  122. Modify Macro to go from Ascending to Descending Order (7 replies)
  123. Help with code cleanup. (5 replies)
  124. Dynamically change number formatting within a column (3 replies)
  125. Append to master list? (2 replies)
  126. runtime error 1004 (8 replies)
  127. GoTo versus Resume within an error-handling routine (2 replies)
  128. Using VB with variables to access data from web sites (5 replies)
  129. find duplicates entries (4 replies)
  130. Still need help with this vba code (2 replies)
  131. Solved: Concatenate into a Single Cell (5 replies)
  132. Solved: Do ... loop (4 replies)
  133. UserForm Initialize or Activate Conundrum (2 replies)
  134. Solved: Newbie once again, importing a module (7 replies)
  135. Vlookup for all the row? (13 replies)
  136. Solved: Last Row Array help (2 replies)
  137. Frequency filter by date and sorted elements (5 replies)
  138. Solved: formula simplificiation (2 replies)
  139. Solved: Column search returning wrong results (35 replies)
  140. Exporting Spreadsheets (5 replies)
  141. Make file read/write (1 replies)
  142. Solved: Create quarterly summary report from details (8 replies)
  143. % movement tracker macro (2 replies)
  144. [SOLVED:] Reverse Lookup Last Record Ignoring Location 300 (6 replies)
  145. VBA Code Error (23 replies)
  146. Solved: Message box ( Open Event) (2 replies)
  147. Set bottom of variable range (11 replies)
  148. dynamic Validation criteria (4 replies)
  149. Solved: Compare the values between two columns (12 replies)
  150. Solved: vlookup from another worksheet (5 replies)
  151. Multipe Goal Seek across workbooks (1 replies)
  152. Fastest method to read data from sheet (2 replies)
  153. Solved: copying cell value only when calculated from formula (2 replies)
  154. Solved: Names I define in a macro ignored by workbook? (24 replies)
  155. Disable cut & paste in active workbook (1 replies)
  156. Solved: Vlookuping a separate sheet (4 replies)
  157. Incremental number for saved files (32 replies)
  158. Solved: VBA Message Box (11 replies)
  159. Check no selection in a listbox.. (3 replies)
  160. Copy Data (2 replies)
  161. Solved: Double Click a cell to show form with data (2 replies)
  162. Code to Export as xml file (0 replies)
  163. Solved: Specify 63 Days From a Date (2 replies)
  164. problem with date format when I use userform (4 replies)
  165. Linking Excel to Access Forms (0 replies)
  166. Validating column Heads (2 replies)
  167. Value change with date (3 replies)
  168. sending mail from excel via smtp-relay (1 replies)
  169. Excel to Power Point (4 replies)
  170. Solved: fill in every other row (1 replies)
  171. adding a message box icon (6 replies)
  172. Import and split large tab deliminated text files (3 replies)
  173. Locking blank cells only via VBA (2 replies)
  174. Mail merge where person and file name are the same. (2 replies)
  175. [SLEEPER:] VLookup like ? (2 replies)
  176. Show messagebox if user selects locked cells (1 replies)
  177. Solved: Create new folder within VB (5 replies)
  178. Locking cells in different range (1 replies)
  179. Solved: UPDATE FORMULA (5 replies)
  180. Solved: Accessing Cells With Activecell.offset (8 replies)
  181. Solved: help with saving a program (3 replies)
  182. Go To Dialog Box Width F5 (1 replies)
  183. Solved: Sumif with concatenate and wildcard (2 replies)
  184. Solved: Making more checkboxes visible when a checkbox is checked (6 replies)
  185. Solved: Define range and combine two codes (6 replies)
  186. Solved: how to condense results from multiple sheets (3 replies)
  187. Track changes if array or multiple cells are changed (1 replies)
  188. Solved: Sum Dynamic row in VBA (3 replies)
  189. Solved: Open File on shared network drive and copy information to sheet (4 replies)
  190. repeated action (1 replies)
  191. Sleeper: Copying new data from one sheet to another (1 replies)
  192. Save columns A:D to C:\ (9 replies)
  193. Find for a specific word and extract details based on the found value (40 replies)
  194. Solved: Locking down a spreadsheet (4 replies)
  195. Have predetermined data appear in one cell, when specific data entered in another. (1 replies)
  196. Solved: Check cell for text (7 replies)
  197. Solved: Lookup & transpose variable range from 1 To 3 columns (12 replies)
  198. Solved: formula to extract number (6 replies)
  199. Solved: Userform Calendar Control modification (9 replies)
  200. Include Row Number in XLFilterCopy (4 replies)
  201. vlookup match columns (5 replies)
  202. Rename file excle (5 replies)
  203. VBA Web Query Generating Error 1004 (0 replies)
  204. Solved: CELLS W/ NO VALUE NOT EQUAL TO BLANK (9 replies)
  205. Solved: One sheet dependent on input on another? (2 replies)
  206. UserForm - List Box Error Message (3 replies)
  207. Solved: Checkbox issue (5 replies)
  208. Saving data in .dat format-help needed (9 replies)
  209. macro to run a series of tasks (2 replies)
  210. Mail to macro (1 replies)
  211. Copy Data From WebPage To Excel (1 replies)
  212. Copy Duplication (9 replies)
  213. Solved: web forms/log ins + VBA? (5 replies)
  214. Access Report (3 replies)
  215. changing cell contents on basis off another cell (9 replies)
  216. parse text (4 replies)
  217. mirror fill color from reference cell (1 replies)
  218. Solved: ANNIVERSARY YEARS (12 replies)
  219. Solved: Close workbook based upon cell value, but don't save workbook (17 replies)
  220. Show Date And Time Of Latest Import From Yahoo! Finance (0 replies)
  221. Sleeper: Change Col diff into Col letter (4 replies)
  222. Solved: test selection for first and last row (2 replies)
  223. Solved: Sendkeys using wait. (8 replies)
  224. Solved: Array Formulas Using CTRL SHIFT ENTER (8 replies)
  225. Solved: if (RC[1]) = 1 then "=TEXT(RC[-1],""MMM/YY"")" (3 replies)
  226. Formula for summing vertically based on horisontal condition (5 replies)
  227. Right Click menu changed due to macro - how to modify? (12 replies)
  228. Code for changing an entry to uppercase (3 replies)
  229. Solved: hi code tweeking (11 replies)
  230. Solved: Prevent users from editing every 'nth' row - eg every 3rd or 4th row. (5 replies)
  231. Ini. Files problem (5 replies)
  232. Solved: again problem with counting date in week (6 replies)
  233. [SLEEPER:] Date format testing fails (7 replies)
  234. Solved: Is there an ISnumeric or Formula code (1 replies)
  235. Solved: Autofill Cells When Another Cell Has Value (15 replies)
  236. Date Format issues (11 replies)
  237. Group with sum. (15 replies)
  238. Solved: smilies in excell 2003 (5 replies)
  239. need help (2 replies)
  240. Solved: count dates in a week (continue) (2 replies)
  241. Need Help testing if a cells contents match that of a cell in another column (2 replies)
  242. Solved: Linking sub's and selecting cells for a sub (3 replies)
  243. Need help with vba code for deleting trailing spaces before or after an entry in a co (6 replies)
  244. Fine tuning an If formula. Cells matching based on Condition (3 replies)
  245. Real Random number (7 replies)
  246. XML in VBA (2 replies)
  247. Multi Criteria Macro (11 replies)
  248. Solved: Count Dates in a Week (7 replies)
  249. trying to add the new name of a file in a cell (7 replies)
  250. Solved: Update Formulas to include added rows (2 replies)