| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
| formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions | |||
Hybrid Mode
