How can I return a variable for the quantity of sheets in my workbook in VBA?

[dan7055]

If I have, for example, five sheets in my workbook, how can I return a variable x = 5?

What VBA code would I need to write?

Also, is there a way I can loop through each sheet in my workbook?

Thanks

 

[footoo]

x= Worksheets.Count

Dim ws as worksheet
For each ws in Worksheets
ws.Activate
Next