taylor.d
11-27-2006, 07:50 PM
I searched and searched and finally came across the code I need (posted by Ann Troy).... But I cannot get it to work for me... I can make it work if I use your code in a new workbook (see attached Test1.xls) but I cannot make it work where I need it (see attached Test2.xls).
I know it's supposed to be "easy", but I can't understand why it's not working for me.
I want the order of tabs to be L7, E11, E12, I10, I11, L11, I12, E16, E17, I16, L16, L40, L41, B36, B42.... I thought it might be the merged cells causing the problem, so I tried it with just the "unmerged" cells, but that wasn't the problem (I guess).
Can you figure it out? I would be very, VERY, grateful... Thanks!
Taylor Dye
using Excel 2003
I know it's supposed to be "easy", but I can't understand why it's not working for me.
I want the order of tabs to be L7, E11, E12, I10, I11, L11, I12, E16, E17, I16, L16, L40, L41, B36, B42.... I thought it might be the merged cells causing the problem, so I tried it with just the "unmerged" cells, but that wasn't the problem (I guess).
Can you figure it out? I would be very, VERY, grateful... Thanks!
Taylor Dye
using Excel 2003