Excel Tab Order: I attempted this solution but it did not work for me

I downloaded the spreadsheet and copied the code. Im stepping through the code and it looks as though it is firing properly but it is not tabbing in the order specified.
sullisnyc44Asked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
It will work on merged cells. Use the first cell in the merged area as the tab destination. Note this line in the code handles merged ranges:

   If Cell.Address = Cell.MergeArea(1, 1).Address Then

Yes, you can used named ranges.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
How do you understand the tabbing to work? Can you post the workbook?

Kevin
0
 
sullisnyc44Author Commented:
Sorry - I was just about to delete the question. I think I have it working now. My apologies.

I do have a question though - instead of explicit cell references, can I use named ranges? Also from what I can gather looking at the code, this will work on merged cells?
0
All Courses

From novice to tech pro — start learning today.