VBA range select using offset and xldown

[Timbo50]

I'm trying to use Vba to select a double column of data to create a range for a new chart. The data is added to daily, so I need to use xldown to capture the latest data but am having trouble selecting the range. I've been trying to incorporate offset to give the double column with xldown to go to last non-blank cell. Any help would be appreciated.

 

[Michael M]

Assuming columns A & B from cell A1 to the last cell

dim lr as long
lr = cells(rows.count, "A").end(xlup).row
range("A1:B" & lr).select

 

[Timbo50]

Hi Michael,

Many thanks, it works a treat. You made it look so simple after my complicated efforts. Thanks again.

Regards,
Tim.

 

[Michael M]

pleasure...

Keep in mind though, that you generally don't need to select a range to do something with it !!!

 

[Timbo50]

Good point. Will do.
Tim.