Select Range with Variable name as parameter

[MayFlowerNew]

Hi All,

I have two string variables StartOfRange and EndOfRange which has valid values (eg "A120" "B233")
I want to select range from StartOfRange to EndOfRange
How do I do this?

Thanks

 

[Zathras]

Very easy:
[tt]
Sub test()
Dim StartOfRange As String
Dim EndOfRange As String

StartOfRange = "A120"
EndOfRange = "B233"
Range(StartOfRange, EndOfRange).Select

End Sub
[/tt]

 

[MayFlowerNew]

Great, it worked.

Thanks