View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_4_] Gary Keramidas[_4_] is offline
external usenet poster
 
Posts: 226
Default 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