I want to save the location of the active cell as a
variable R, so for example, if it was "B4" I want to save
R = ActiveCell.? = B4. I want to do this with two
variables say R=B4 and S=D12 then I want select the
Range(R:S).Select I know the syntax I have written here
is wrong so I am looking for some advice I how I can write
this in a way Visual Basic will understand. Any help is
appreciate. Thanks for your time.

Andy