Variable undefined easy prob missing something simple

[KORKIS2]

Somethings wrong here cant figure out what can anyone help

Dim AA As Long
Dim AB As Long


AA = Worksheets("Dipole Scratchpad 1").Cells(1, "L").Value


AB = Worksheets("Dipole Scratchpad 1").Cells(1, "M").Value
MsgBox (AA)
MsgBox (AB)


Range(AA.AB - 1).Sort Key1:=Range("B7"), Order1:=xlAscending, Header:=xlGuess

 

[Joe4]

So, what exactly is in cells L1 and M1?

And what exactly are you trying to do with "AA.AB - 1"?
That definitely does not look like a valid range reference (there shouldn't be any periods in range references).

 

[KORKIS2]

Just numbers like 9 and 20 they are the row values after a search for specific row in a column to find the range that needs to be alphabetically arranged. in the column I had it as (AA & AB-1) and that worked once and then it said that needed to declare a global variable

 

[RoryA]

If they are row numbers you'd need Range(AA & ":" & AB - 1) to get a valid reference.

 

[Jonmo1]

So if AA = 9 and AB = 20 (AB-1 = 19)

And your intention is to do this with those variables
Range("9:19").Sort Key1:=Range("B7"), Order1:=xlAscending, Header:=xlGuess

That syntax would be
Range(AA & ":" & AB - 1).Sort Key1:=Range("B7"), Order1:=xlAscending, Header:=xlGuess

 

[KORKIS2]

thanks guys that worked

 

[Jonmo1]

You're welcome.