Do determine what it currently is

Dim sh as Object
for each sh in Activeworkbook.Sheets
msgbox sh.name & " index: " & sh.Index
Next

--
Regards,
Tom Ogilvy


"Frans" wrote:

How can I determine the taborder in an excel sheet ? It needs to go from
a3 to b3 tot a4 to b4 to a5 to b5 etc.