Active cell jumps when conditions are met on a single row but I needan expanded macro that will do t

M

Michael Lanier

I have a spreadsheet layout that requires the active cell to jump
locations after the required information is entered. Also, the values
of the cells will frequently change as needed, so a solution must
allow for changes in entries. A sample of my macro for a single row
follows. The worksheet is Sheet1.

If Range("A1").Value > 0 And Range ("B1").Value = "" Then
With Me
Application.GoTo Range("B1"), Scroll:=False
End With
End If

This works fine for a single row, however, if I have 500 rows, I need
a macro that will allow for the same condition on all 500 rows. A
solution would be greatly appreciated. Thanks in advance.

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active cell is to jump from one cell to another when conditions are met 2
Take active cell value in for loop and offset based on another cellvalue for columns to offset 0
Find the correct sheet then find a value on that sheet 8
AutoFit Macro to Reduce row height? 0
Advice on multiple macros, same code just a different column 9
Macro to delete row if cells greater than certain value 1
Macro to Combine Data from Multiple Sheets with Cell References 4
combining row values into one cell while filter is active 6

Top