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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unlocking range of cells/worksheet?	=?Utf-8?B?REpvbmU=?=	Microsoft Excel Misc	1	18th Apr 2007 06:50 PM
cells name or range name in a worksheet	Jean-Pierre Bidon	Microsoft Excel Programming	1	1st Feb 2006 11:23 AM
subtotal a range of cells on a different worksheet	=?Utf-8?B?Y2hlcnls?=	Microsoft Excel Worksheet Functions	0	2nd Nov 2005 08:37 PM
is there a way to protect a range of cells on a worksheet?	=?Utf-8?B?dmV2YW5z?=	Microsoft Excel Misc	1	17th Feb 2005 05:30 PM
Cells worksheet commands used for a range?	Jethro[AGHL]	Microsoft Excel Worksheet Functions	2	9th Sep 2003 02:47 PM