3D-Ranges

VBA-Excel : 3D-Ranges – FillAcrossSheets Method

by

 

By using FillAcrossSheets you can copy the Range of one worksheet to other multiple worksheets.

Steps:

  • Create an array and assign multiple worksheets names ( in which the data to be copied), as an array elements.
  • Copy the range of main worksheet and paste it to the other sheets using FillAcrossSheets.

Read more

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

by

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

Read more