select defined cell

[briankimberly]

after I have defined a range = Dim c As range

how do i select it. tried range(c).Select but that doesnt work?

 

[hiker95]

briankimberly,

The following works.

Option Explicit
Sub Test()
Dim c As Range
Set c = Range("A5")
c.Select
End Sub

 

[briankimberly]

thx!! i knew it was something easy!!

 

[hiker95]

briankimberly,

You are very welcome. Glad I could help.

And, come back anytime.