Presumably you want to do something with each sheet. Try
something like the following:


Dim SH As Worksheet
For Each SH In ThisWorkbook.Worksheets
SH.Activate
' do something with SH
Next SH


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com






"asante_za" wrote in message
...
Could someone write a vb code or macros to auto activate sheets
(tabs) one
after the other sequentially.
--
JA