Range selection-How do I use vb code to pick up

[Sagaron]

Hi
I am struggling with defining a range.
I want to specify the range in the normal excel worksheet and want the vba code to pick this up.
For eg , range i want to select is a1:a3 on sheet1 which I have typed in say cell b1 in the sheet as "a1:a3"
How do I use vb code to pick up on what I typed in b1 to select a1:a3.

Thx
Raj

[Toppers]

Range(range("b1")).select

b1 contains a1:a3 (NO quotes)

"Sagaron" wrote:

>
> Hi
> I am struggling with defining a range.
> I want to specify the range in the normal excel worksheet and want the
> vba code to pick this up.
> For eg , range i want to select is a1:a3 on sheet1 which I have typed
> in say cell b1 in the sheet as "a1:a3"
> How do I use vb code to pick up on what I typed in b1 to select a1:a3.
>
>
> Thx
> Raj
>
>
> --
> Sagaron
> ------------------------------------------------------------------------
> Sagaron's Profile: http://www.excelforum.com/member.php...o&userid=24643
> View this thread: http://www.excelforum.com/showthread...hreadid=387724
>
>

[jindon]

try

Please Login or Register  to view this content.