Be the first user to complete this post

  • 0
 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:


  
    

    
     
          
  1. VBA Excel - Cells, Ranges and Offset: Refer to Cells by Using Shortcut Notation
    2. 
      
    
     
          
  2. VBA-Excel: String Functions – Trim()
    3. 
      
    
     
          
  3. VBA-Excel: Arrays – Two Dimension, Dynamic Array
    4. 
      
    
     
          
  4. VBA-Excel: Date-Time Functions - Timer()
    5. 
      
    
     
          
  5. VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)
    6.