Re: referencing ranges using R1C1 format

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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?action=getinfo&userid=24997
> View this thread: http://www.excelforum.com/showthread.php?threadid=385424

--

Dave Peterson
.

Quantcast