You can test visible sheets for the .Visible property = xlSheetVisible.

Is this enough to get you going or do you need more?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"maimai" wrote in message
om...
Hi there!

Can anybody help me design a macro that would sum across VISIBLE
worksheets, that starts from, say 3rd worksheet up to the last visible
one?

thanks!