Visual Basic Range variable

  • Thread starter Thread starter Andrew Johnson
  • Start date Start date
A

Andrew Johnson

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
 
Andrew,

Try something like

Dim R As Range
Dim S As Range
Set R = ActiveCell
Set S = Range("D12")
Range(R,S).Select
 
Hi Andrew,

Sub jskal()
'MsgBox ThisWorkbook.FullName
Dim S As String
Dim R As String

R = ActiveCell.Address
S = "$" & Chr(Asc(Mid(R, 2, 1)) + 1) & Mid(R, 3, Len(R) - 1)

Range(R, S).Select
MsgBox R & ":" & S

End Sub


losmac
 
Back
Top