VBA-Excel : 3D-Ranges – FillAcrossSheets Method

 

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 moreVBA-Excel : 3D-Ranges – FillAcrossSheets Method