question about for" do.....loop "for multiple worksheets task

Hello, dear People

I am a beginner for VBA and meet the following problem.

I have format about 300 worksheets in a workbook. They are with the names 1,2,3,4,......300.

the data fields are with different length. ( The columns stay the same, but rows vary)

I have recorded the macros for the formatation. Let us call this macro macro1

Now how can I with a do loop command to to this for all the worksheets.

can this be done through such a VBA command

do while worksheet.name <301
macro1
loop

How to write the command correctly?

Thanks for your kindly advise.

Anaking

Something like this perhaps

Please Login or Register  to view this content.