07-08-2005, 06:05 PM
|
|
|
|
Re: referencing ranges using R1C1 format
Dave Peterson wrote:
> The only trouble I've had with that syntax is when I don't qualify the ranges.
One can avoid the qualification problem with
Set baseRng = ActiveSheet.Range("A1")
Set rng=Range(baseRng(1,1),baseRng(2,2))
You can refer to a single cell with, e.g., baseRng(2,2)
Alan Beban
>
> 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
>
>
|