Is there a way to merge cells on another worksheet?

[USAMax]

I currently have my program selecting the other worksheet to merge the cells and I have Screen Updating turned off but I hope there is a better way.

     Application.ScreenUpdating = False      '                  Disable the screen updating
     ALWs.Select                                    '                  Select the Available worksheet
     Range(Cells(1, SCP), Cells(1, ALWc - 1)) _
                                .MergeCells = True '                  Merge the headers for the current position.
     RWs.Select                                     '                  Return to the main Resource worksheet
     Application.ScreenUpdating = True      '                  Re-enable the screen updating

Is there another way?

 

[healey21]

You could loop through each sheet to do the merge cells

 

[USAMax]

Thank you Healey, I know the exact worksheet, row and column that I I need to merge the cells but I would like to do something like this:

ws.Range(Cells(1, SCP), Cells(1, ALWc - 1)).MergeCells = True '                  Merge the headers for the current position.

The problem is that Excel does not allow this so I am looking for another way so I can speed up the program and reduce the risk of screen flicker. Does the page have to be active to merge cells?