Active cell is to jump from one cell to another when conditions are met
I have a register that when an entry is made in column B but there is
no entry in column C, the active cell will jump from B to C. Other
columns exist and will require their own sets of conditions. The
problem I have is in the need for a simple formula that will allow for
as many as 1,660 rows. The following shows what I've attempted
without success. Can you offer a solution? Thanks.
If Range("B10:B1660").Value 0 And Range("C10:C1660").Value = ""
Then
With Me
Application.GoTo Range("C10:C1660"), Scroll:=False
End With
End If
A separate issue would be when all the entries in a row have been
entered, the active cell will jump to the next row awaiting it's
initial entry, however, my first problem is far more pressing.
|