How do you get a row number is a Cell?
don't know what your value of j is, but i set it to 2 and it scrolls to a7
Sub rr()
Dim j As Integer
j = 2
ActiveWindow.ScrollRow = Range("A" & j + 5).Row
End Sub
--
Gary
"CRayF" wrote in message
...
I'm searching the active Worksheet for a value and when found I want to
scroll to the row the value was found on as the ActiveWindow.ScrollRow.
Assuming the value was found in Range("A" & j + 5) how would I scroll to
it?
This did not work...
ActiveWindow.ScrollRow = ActiveWindow.Range("A" & j + 5).Row
|