View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil[_27_] Neil[_27_] is offline
external usenet poster
 
Posts: 1
Default Range problems...

Hello All,

If I have the following code:

-------------------
Dim MyRange As Range

Set MyRange = "B19:I26"
-------------------

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

ActiveSheet.Range(MyRange).Select

wont work because Range expects 2 arguments.

TIA,

Neil.