M
Matthew Pfluger
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
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