(0.01 seconds) Articles (6508) /326 Next>> Last >| Trouble with dynamic named range 2 1941 (6/7/2010 5:34:35 PM) Utf In an Excel 2010 workbook I created a dynamic named range from the Formula tab using the Define Name utility. The formula I entered is: =OFFSET(Price Groups!$AP$2,0,0,COUNTA(Price Groups!$AP:$AP)-1,1) ... Deleting Duplicate Rows 06-07-10 11 3076 (6/7/2010 8:06:22 PM) Utf Hi, I checked out the archives for close to an hour, but I couldn't figure out how to change the codes given there to suit my needs. I have a large set of data, from about A1 to X441. In column X, there ar... How to do this with macro? 2 3100 (6/7/2010 4:59:05 PM) Arto I have several cells in one column, what include numbers (example B2-B4). After few empty cells, I have a cell (example B7), what include formula B4-A1. A1 B1 1 2 3 4 5 6 xx ... Need largest number 6 2150 (6/7/2010 5:03:28 PM) Utf I have a file in Excel 2003. In 1 column I have a numeric field. In the next column I have a 2 digit apha field. In the third column I have another numeric field. For each row I need a formula in the 4t... Re: How to do this with macro? 0 1785 (6/7/2010 9:25:50 PM) Don oops. to find the last number in b and subtract a1 =INDEX(B:B,MATCH(9999999,B:B))-A1 -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "Don Guillett" wr... Sort Routine Macro for Excel Worksheet 1 1985 (6/7/2010 5:31:30 PM) JCO I have an excel that requires a sort routine. I tried using the start/stop recording. The code is shown below, however, I need this routine to work when you don't know how many rows are in the data. My m... Change event does not fire 3 3117 (6/7/2010 6:06:11 PM) Utf Hello! I have a worksheet with checkboxes. Each checkbox is linked to a cell. When checkboxes are checked/unchecked the cell changes, but the Change event for the sheet does NOT fire! Is that how it is sup... Save data before printing 1 2056 (6/7/2010 6:43:44 PM) Saga Hello all, An acquiantence is programming in Excel 2003 and has a sheet where theuser enters receipt data. When he is done, he clicks a boton to copythe data from the sheet to another in tabular form with...