Hello again,
OK, what's wrong with this code? I just want to select a range that = E3 to the value thats in A1.
Sub GetAU()
Dim a As Variant
a = Sheets("Data").Range("A1").Value
Sheets("Data").Range("E3").Select
Range(Selection, Selection.Offset(0, a)).Select
End Sub
OK, what's wrong with this code? I just want to select a range that = E3 to the value thats in A1.
Sub GetAU()
Dim a As Variant
a = Sheets("Data").Range("A1").Value
Sheets("Data").Range("E3").Select
Range(Selection, Selection.Offset(0, a)).Select
End Sub