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 – FillAcrossSheets Method

 

By using Fil­lAcrossSheets you can copy the Range of one work­sheet to other mul­ti­ple worksheets.

Steps:

  • Cre­ate an array and assign mul­ti­ple work­sheets names ( in which the data to be copied), as an array elements.
  • Copy the range of main work­sheet and paste it to the other sheets using Fil­lAcrossSheets.

Function FnFillAcrossSheets()

         arrCombinedArray = Array("Sheet2", "Sheet3", "Sheet4")

         Sheets(arrCombinedArray).FillAcrossSheets.Worksheets("Sheet1").Range("A1:B5")

End Function 

This func­tion will copy the A1 to B5 Range of data from sheet1 and fill the same data in “Sheet2”, “Sheet3”, “Sheet4”

 

 


 

You may also like...

Leave a Reply

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

%d bloggers like this: