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
Bookmarks