Y
YoureNotAtHomeNow
Excel 2000
Hello
I've set up some code (crudely - I'm a VBA beginner) to make a row
unhide itself when a cell above that row has something typed into it
thus:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Stops showing every step on screen
Application.ScreenUpdating = False
If [L19].Value > 0 Then
Range("A20:N20").EntireRow.Hidden = False
End If
If [L20].Value > 0 Then
Range("A21:N21").EntireRow.Hidden = False
End If
If [L21].Value > 0 Then
Range("A22:N22").EntireRow.Hidden = False
End If
etc down to row 69.
Trouble is, on activation, the row unhides itself ok but the cursor
ends up below the row that's just been unhidden, amongst the hidden
rows, and I want it IN the row that's just been unhidden, ie if I've
just typed something into L21 and Entered, I want the cursor to be in
L22 - ready for the next entry.
Hello
I've set up some code (crudely - I'm a VBA beginner) to make a row
unhide itself when a cell above that row has something typed into it
thus:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Stops showing every step on screen
Application.ScreenUpdating = False
If [L19].Value > 0 Then
Range("A20:N20").EntireRow.Hidden = False
End If
If [L20].Value > 0 Then
Range("A21:N21").EntireRow.Hidden = False
End If
If [L21].Value > 0 Then
Range("A22:N22").EntireRow.Hidden = False
End If
etc down to row 69.
Trouble is, on activation, the row unhides itself ok but the cursor
ends up below the row that's just been unhidden, amongst the hidden
rows, and I want it IN the row that's just been unhidden, ie if I've
just typed something into L21 and Entered, I want the cursor to be in
L22 - ready for the next entry.