Can variables hold methods?

[excelnoob001]

I am new to VBA.

I am trying to make a variable contain a method, so my code would become more abstract.

Dim wbS As Workbook 

Dim Source_File As String
Source_File = ActiveWorkbook.Name
Set wbS = Workbooks(Source_File)

Set wsS1 = wbS.Sheets("A")
Set wsS2 = wbS.Sheets("B")
Set wsS3 = wbS.Sheets("C")
Set wsS4 = wbS.Sheets("D")
Set wsS5 = wbS.Sheets("E")
Set wsS6 = wbS.Sheets("F")
Set wsS7 = wbS.Sheets("G")
Set wsS8 = wbS.Sheets("H")

'the above is the context to my problem

Dim rep As String
    
                If passedA = True Then
                    Set rep = wsS1
                    
                ElseIf passedB = True Then
                    Set rep = wsS2
                
                ElseIf passedC = True Then
                    Set rep = wsS3
                    
                ElseIf passedD = True Then
                    Set rep = wsS4
                
                ElseIf passedE = True Then
                    Set rep = wsS5
                    
                ElseIf passedF = True Then
                    Set rep = wsS6
                    
                ElseIf passedG = True Then
                    Set rep = wsS7
                    
                ElseIf passedH = True Then
                    Set rep = wsS8
                    
                ElseIf passedI = True Then
                    Set rep = wsS9
                
                End If
            
                Set USS = rep.Range("A7", Range("B7").End(xlDown)) 
                            USS.Copy
                            ActiveSheet.Paste Destination:=wsMT.Range("A3") 'the destination of the paste
                            Application.CutCopyMode = False


                 Set X = rep.Range(...)
Set Y = rep.Range(…)

Set XY = rep.Range(...)

​
Set YY = rep.Range(…)

Set... blah blah blah
<strike></strike>​

I am trying to make it so that rep can change and make the formulas more dynamic, instead of having a specific formula for each condition.

Thank you for your help. :D

 

[Fluff]

You would need to Dim rep as Worksheet not string

 

[excelnoob001]

Thank you!

 

[Fluff]

You're welcome