Best Substitute for Range(cells(),cells()) in worksheet
 

I'd like to know what the best substitute for the Range(cells(),cells())
method is. Specifically, I have a named range pointer cell that I would like
to use to make another named range like this:

RefersTo:=Range(range("ptrCell"),cells(row(range(" ptrCell")),256))

I thought of using
1. Cell("address",...) twice, concatenate, and use INDIRECT
2. OFFSET(FirstCell,0,0,1,COL(SecondCell)-COL(FirstCell))

Without using a UDF, has anyone a better suggestion? Thanks,

Matthew Pfluger

Best Substitute for Range(cells(),cells()) in worksheet
 

Of course, COL should have been COLUMN.

"Matthew Pfluger" wrote:

I'd like to know what the best substitute for the Range(cells(),cells())
method is. Specifically, I have a named range pointer cell that I would like
to use to make another named range like this:

RefersTo:=Range(range("ptrCell"),cells(row(range(" ptrCell")),256))

I thought of using
1. Cell("address",...) twice, concatenate, and use INDIRECT
2. OFFSET(FirstCell,0,0,1,COL(SecondCell)-COL(FirstCell))

Without using a UDF, has anyone a better suggestion? Thanks,

Matthew Pfluger