macor code

Question

Hello everyone,I need help creating a VBA code to run a Macro on all sheets in the active workbook of Ex cell?All advice is highly thanked.&nbsp;&nbsp;&nbsp;&nbsp;

ingeborghawighorst · Answer

Hello,&nbsp;here is something to get you started. This code loops through all worksheets in the current workbook and pops up a message with the worksheet name.&nbsp;&nbsp;Sub LoopWorksheets()
Dim ws As Worksheet

For Each ws In ThisWorkbook.Worksheets
' do something
    MsgBox ws.Name
Next ws
End Subdoes that help?&nbsp;

Forum Discussion

macor code

1 Reply

Resources