Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

VBA-Excel : 3D-Ranges — Working with Multiple WorkSheets At The Simultaneously

You can update the mul­ti­ple work­sheets at the same time. If you want to do the sim­i­lar action on the same range on mul­ti­ple sheets, all you need to do is use Array Func­tion to spec­ify mul­ti­ple sheets name as array elements

Sub MultipleSheets()

    Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select

    Range("J8").Select

    Selection.Value = 7

    Selection.Interior.ColorIndex = 45

End Sub 

 


 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: