Be the first user to complete this post
|
Add to List |
VBA-Excel : 3D-Ranges - Working with Multiple WorkSheets At The Simultaneously
You can update the multiple worksheets at the same time. If you want to do the similar action on the same range on multiple sheets, all you need to do is use Array Function to specify multiple 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
Also Read:
- VBA-Excel: Arrays – Multi Dimensional Array
- VBA-Excel: Date-Time Functions – TimeSerial() and TimeValue()
- VBA-Excel: String Functions – Replace()
- VBA-Excel: Date-Time Functions – Date(), Now() and Time()
- VBA-Excel: Arrays – One Dimension, Dynamic Array