4thorns
Structural
- Jan 22, 2009
- 152
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
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