For Each Worksheet in...do this

[Carl B]

Is there a way to have Excel, for example, total Ranges A2:B67 on each worksheet in a workbook when number of worksheets will vary from day to day?

 

[Qroozn]

dim ws as worksheet
for each ws in workbook
range (a2:b67) .select

 

[Carl B]

Thank you Qroozn, that seems easy enough :^)