| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Active cell jumps when conditions are met on a single row but I needan expanded macro that will do the same on multiple rows | Excel Programming | |||
| Jump to Yahoo Mail with Active Cell Contents, and then perform asearch in the Search Mail Box | Excel Programming | |||
| Jump to cell based on cell results created by calendar control too | Excel Discussion (Misc queries) | |||
| jump to active cell in other sheet . | Excel Discussion (Misc queries) | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
Threaded Mode
