Combine known column and row based on cell contents VBA

[4thorns]

Hi All.

This seems like it should be easy and I know I've done something similar in the past.

Sub ScrollToName()
Dim RN As Integer
RN = Range("P5").Value
ActiveWindow.ScrollRow = RN
[highlight #FCE94F]Range("E + RN").Select[/highlight]
End Sub

It scrolls to the top perfectly but I can't seem to get it to select the cell I want it to.
Obviously I'm missing something.

Thanks, Doug

 

[4thorns]

Figured it out 20 seconds later. "+" = addition.

Range("E" [highlight #8AE234]&[/highlight] RN).Select

Works perfect.

 

[SkipVought]

Sub ScrollToName()
   Cells(Cells(5, "P").Value, "E").Select
End Sub

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}