"Neil" wrote in message
...
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)