Thread: ScrollRow
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ordnance1[_2_] ordnance1[_2_] is offline
external usenet poster
 
Posts: 92
Default 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