vba, identifying a range
 

I write a macro to find a named range, say A15. Then I go up one row and
select several columns. My macro would read Range("A14:D14").Select

When I add more columns and sort, then do the same command (finding the
named range), the named range would be anywhere (no longer A15) so when I go
up one cell and select several columns the cells WOULD not be
Range("A14:D14").select

How do I identify the Range(s) in my macro?

Thanks.

Range("A15").Offset(-1, 0).Resize(, 4).Select

Regards

Trevor


"Danny" wrote in message
...
I write a macro to find a named range, say A15. Then I go up one row and
select several columns. My macro would read Range("A14:D14").Select

When I add more columns and sort, then do the same command (finding the
named range), the named range would be anywhere (no longer A15) so when I
go
up one cell and select several columns the cells WOULD not be
Range("A14:D14").select

How do I identify the Range(s) in my macro?

Thanks.