Using variables for range select

Hello powers023,

Welcome to the Forum!

I am not clear on what you want to do here. If you want to define a range in A1 notation then the variable should be a string type. The example below selects the cell "AA25" on the ActiveSheet. As long as the string is a valid range, the code won't error.

  Dim Addx As String

    Addx = "AA25"
    Range(Addx).Select