How do you get a row number is a Cell?
 

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

How do you get a row number is a Cell?
 

ActiveWindow.ScrollRow = j+5

"CRayF" wrote:

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

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

How do you get a row number is a Cell?
 

thanks

"JMB" wrote:

ActiveWindow.ScrollRow = j+5

"CRayF" wrote:

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