views:

21

answers:

1

I have a column as follows :

Column A---------------Column B
100 ----------------- 500
200 ----------------- 600
AA ----------------- ABCD
BB ----------------- DEFG
CC ----------------- FF
DD ----------------- GG
EE -----------------II
300 ----------------- 700
400 ----------------- 800

I want the Cursor to be present at cell location of "AA" at all times when worksheet is opened and when it reaches "DD", it should go to "ABCD" instead of going to cell 300.

This is a simplified version of a larger problem. I have several columns. I need a dynamic Visual Basic Code rather than hardcoing the same.