I love you all. I've learned a tremendous amount from this website, and appreciate it very much. I have an extensive excel VBA workbook, that is reliable and impressive due to what i've learned from you guys, so thanks.

I've come across something that has stumpted me, and I wasn't able to find an answer while searching. Though this seems trivial, and probably has been asked often, I couldn't find a search that would bring up an answer.


I have the individual cells already mapped using the following code:

Private Sub Worksheet_Change(ByVal target As Range)


If target.Address = "$E$11" Then Range("E12").Select
If target.Address = "$E$12" Then Range("H12").Select
If target.Address = "$H$12" Then Range("I12").Select
If target.Address = "$I$12" Then Range("E14").Select
If target.Address = "$I$12" Then Range("E14").Select
If target.Address = "$E$14" Then ActiveSheet.SalesNotes.Activate
If target.Address = "$E$16" Then ActiveSheet.SalesNotes.Activate
If target.Address = "$E$21" Then ActiveSheet.SalesNotes.Activate
If target.Address = "$I$23" Then ActiveSheet.SalesNotes.Activate
If target.Address = "$N$13" Then Range("P17").Select
If target.Address = "$P$22" Then Range("C43").Select
If target.Address = "$C$43" Then Range("C44").Select
If target.Address = "$O$543" Then Range("O542").Select

exit sub

However I have a Range of 500 rows, that need to perform the same tasks.

When data is entered in to cell C43, then when pressing enter, O43 needs to be selected, when entered, P43, then resolve to C44 when P43 is completed.

This should repeat for 500 rows.


Is there a way using intergers to define this action for a range of 500 rows?

thanks again