Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ScrollRow
What can I add to the code below to set the ScrollRow to 1 and the curser on
cell A3? With Worksheets("March") If .Range("C184").Value = "" Then .Rows("184:228").Hidden = True End If If .Range("C184").Value < "" Then .Rows("184:228").Hidden = False End If If .Range("C229").Value = "" Then .Rows("229:273").Hidden = True End If If .Range("C229").Value < "" Then .Rows("229:273").Hidden = False End If End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ScrollRow
Well, you can add this to the end of the code you posted...
ActiveWindow.ScrollRow = 1 Range("A3").Select This will put the cursor on A3 of whatever worksheet is currently active. -- Rick (MVP - Excel) "ordnance1" wrote in message ... What can I add to the code below to set the ScrollRow to 1 and the curser on cell A3? With Worksheets("March") If .Range("C184").Value = "" Then .Rows("184:228").Hidden = True End If If .Range("C184").Value < "" Then .Rows("184:228").Hidden = False End If If .Range("C229").Value = "" Then .Rows("229:273").Hidden = True End If If .Range("C229").Value < "" Then .Rows("229:273").Hidden = False End If End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveWindow.ScrollRow and ScrollColumn | Excel Programming | |||
Help with ScrollRow | Excel Programming | |||
ScrollRow | Excel Programming |