"Neil" <neil.haywood@alpertonltd.com> wrote in message
news:d1utbu$dd$1@hercules.btinternet.com...
> Hello All,
>
> If I have the following code:
>
> -------------------
> Dim MyRange As Range
>
> Set MyRange = "B19:I26"

It will fail as you cannot set a range objcet to a string.

You should use

Set MyRange = Range("B19:I26")

> -------------------
>
> How can i get the Active worksheet (or any other worksheet) to select that
> same range.

Then you just use

Activesheet.MyRange.Select

> ActiveSheet.Range(MyRange).Select
>
> wont work because Range expects 2 arguments.

Where do you get that idea from? You have two syntaxes for Range
Syntax 1

expression.Range(Cell1)

Syntax 2

expression.Range(Cell1, Cell2)