07-08-2005, 06:05 PM
|
|
|
|
Re: referencing ranges using R1C1 format
The only trouble I've had with that syntax is when I don't qualify the ranges.
I like:
dim rng as range
with activesheet 'worksheets("sheet1")
set rng = .range(.cells(1,1),.cells(2,2))
end with
And I could refer to a single cell using your example--but I wouldn't.
pwermuth wrote:
>
> Thank you, but the
>
> Range(Cells(1,1),Cells(2,2)) syntax never works for me. I always get
> runtime errors. Are there some limitations I need to be aware of? For
> example, can I not refer to a single cell (i.e. Range(Cells(2,2),
> Cells(2,2)) ) using this syntax?
>
> --
> pwermuth
> ------------------------------------------------------------------------
> pwermuth's Profile: http://www.excelforum.com/member.php...o&userid=24997
> View this thread: http://www.excelforum.com/showthread...hreadid=385424
--
Dave Peterson
|