Re: Is there a way to address a range by row # and column #?
From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/13/04
- Next message: Tim Childs: "Re: sendkeys and paste-special"
- Previous message: Frank Kabel: "Re: How to combine two sheets in order to display the data on Pivot Chart?"
- In reply to: Khaki: "Is there a way to address a range by row # and column #?"
- Next in thread: Khaki: "Re: Is there a way to address a range by row # and column #?"
- Reply: Khaki: "Re: Is there a way to address a range by row # and column #?"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 13 Mar 2004 10:15:41 +0100
Hi
try
cells(5,2)
instead of
range("B5")
--
Regards
Frank Kabel
Frankfurt, Germany
> sorry for the newbie question, but is there a way to address a range
> by row # and column #?
>
> Eg instead of range("B5"), I would somehow address it by
> funcitionX(2,5) where 2 is B and 5 is column 5. I think I am asking
> about r1c1 notation?
>
> TIA
>
> K
>
>
> ---
> Message posted from http://www.ExcelForum.com/
- Next message: Tim Childs: "Re: sendkeys and paste-special"
- Previous message: Frank Kabel: "Re: How to combine two sheets in order to display the data on Pivot Chart?"
- In reply to: Khaki: "Is there a way to address a range by row # and column #?"
- Next in thread: Khaki: "Re: Is there a way to address a range by row # and column #?"
- Reply: Khaki: "Re: Is there a way to address a range by row # and column #?"
- Messages sorted by: [ date ] [ thread ]
