Good day,

I want to select a different range based on an if statement,

Im having issues with the Range as variable, its not taking a value,

Dim RAC as range
dim x as integer
dim y as integer

x = 5
y = 4

    If Worksheets("Test").Range("C8") = "1" Then
        RAC = Range("A2:B" & x)
    ElseIf Worksheets("test").Range("C8") = "2" Then
        RAC = Range("A" & x + 1 & ":B" & x + y+ 1)
    End If