Be the first user to complete this post

  • 0
 Add to List

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.
Function FnFillAcrossSheets()

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

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

End Function

This function will copy the A1 to B5 Range of data from sheet1 and fill the same data in "Sheet2", "Sheet3", "Sheet4"





    

    


        

            

              
                
                
            

          

        

    

    
         
Also Read:


  
    

    
     
          
  1. Getting Started with Excel Macro
    2. 
      
    
     
          
  2. Excel-VBA : Change Passwords for all the  WorkSheets in one shot
    3. 
      
    
     
          
  3. VBA-Excel : Strings Functions – Ucase
    4. 
      
    
     
          
  4. VBA Excel – Looping Through a Range of Cells
    5. 
      
    
     
          
  5. VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations
    6.