Hi all,
I'm struggling to see the wood for the trees at the moment. I'm trying to loop through all the worksheets in a workbook with one exception. Here the's code i currently have;
I want to run 'Update' on each sheet in the workbook with the exception of "Summary".
What am i doing wrong?
Thanks in advance
I'm struggling to see the wood for the trees at the moment. I'm trying to loop through all the worksheets in a workbook with one exception. Here the's code i currently have;
Code:
Sub UpdateAllSheets()
Dim ws As Worksheet
For Each ws In Worksheets
If Not LCase(ws.Name) Like "Summary" Then Update
Next ws
End Sub
I want to run 'Update' on each sheet in the workbook with the exception of "Summary".
What am i doing wrong?
Thanks in advance