| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
use xlup and offset in a range of cells
Every week i get a new spreadsheet with a new number of rows based on current data. I need to set some filters in that spreadsheet and then copy the remaining data in that column. i need to use the results of the very last row with data as a variable and then substitute it into a range.select statement so i don't have to change the range every time i run the macro, it would be set for me using xlup and offset. I'm sure this can be done i just can't seem to get the syntax right. Please Advise.. Thanks
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
use xlup and offset in a range of cells
Every week i get a new spreadsheet with a new number of rows based on
current data. I need to set some filters in that spreadsheet and then copy the remaining data in that column. i need to use the results of the very last row with data as a variable and then substitute it into a range.select statement so i don't have to change the range every time i run the macro, it would be set for me using xlup and offset. I'm sure this can be done i just can't seem to get the syntax right. Please Advise.. Thanks It would be easier to help you if you post your code... -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value | Excel Programming | |||
| Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value | Excel Programming | |||
| macro to select a range of cells following an offset? | Excel Programming | |||
| Acivecell.Formula Offset End(xlUp) | Excel Programming | |||
| Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming | |||
Linear Mode
