Thread: How do you get a row number is a Cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CRayF CRayF is offline
external usenet poster
  
Posts: 115
Default 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



Reply With QuoteReply With Quote