How to format/modify data in clones of a sheet through vba?

[prabha_friend]

Assume I am having some clones of a sheet (copies of a sheet). How to work with those clones (format/modify data) at a single time? (through vba). What is the default way of doing it? and Is there a way to do it without working with the selection (suggested by the record macro). Thanks in advance. Please suggest me the perfect way (i.e the shortest possible way)

 

[eddvrs]

This will loop through all the sheets in the active workbook. You'll have to place your code within the loop, assuming you want to do exactly the same thing to every tab in the workbook.

Sub loop_through_sheets()

    For Each sh In ActiveWorkbook.Sheets
        sh.Activate
        ' Place your code here
    Next sh

End Sub

 

[prabha_friend]

This will loop through all the sheets in the active workbook. You'll have to place your code within the loop, assuming you want to do exactly the same thing to every tab in the workbook.

Sub loop_through_sheets()

    For Each sh In ActiveWorkbook.Sheets
        sh.Activate
        ' Place your code here
    Next sh

End Sub

Hi Edd,
Thanks to your reply. Let me rephrase the question: How to create/work with worksheet groups through vba? Thanks in advance.