Compile error end of statement to read to end of data set instead of a set number of rows

[fvisions]

Compile error: Expected: end of statement
I am changed my code to read column V to endo or the full worksheet, it was v2:v1000 but sometimes there are more than 1000 rows and I am receiving the compile error. I am not sure who to correct this.
Dim LastRow As Long
LastRow = Cells(Rows.Count, 2).End(xlUp).Row

ActiveWorkbook.Worksheets("Installation wkg").Sort.SortFields.Add2 Key:=range _
        ("V2:V" & LastRow).SortOn:= xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal

 

[Joe4]

Do you realize that you are checking column B (and not column V) to locate the last row?
What is your value of "LastRow"?
You can get it like this:

Dim LastRow As Long
LastRow = Cells(Rows.Count, 2).End(xlUp).Row
MsgBox LastRow

Also, are you on the "Installation wkg" sheet when this part of the code is running?
If not, you will need to change your code above to include the sheet reference.

 

[fvisions]

Do you realize that you are checking column B (and not column V) to locate the last row?
What is your value of "LastRow"?
You can get it like this:

Dim LastRow As Long
LastRow = Cells(Rows.Count, 2).End(xlUp).Row
MsgBox LastRow

Also, are you on the "Installation wkg" sheet when this part of the code is running?
If not, you will need to change your code above to include the sheet reference.

Yes this is only part of the code. The other codes for looking at the last row is with column b for a vlookup of various other columns. This section of code is to sort the full spreadsheet columns A:AD by 3 criteria. the debug is highlighting on the colon/equals at the .sorton:= in the code does this help?

 

[fvisions]

Do you realize that you are checking column B (and not column V) to locate the last row?
What is your value of "LastRow"?
You can get it like this:

Dim LastRow As Long
LastRow = Cells(Rows.Count, 2).End(xlUp).Row
MsgBox LastRow

Also, are you on the "Installation wkg" sheet when this part of the code is running?
If not, you will need to change your code above to include the sheet reference.

 LastRow = Cells(Rows.Count, 2).End(xlUp).Row

 

[Joe4]

The word "range" in " "Key:=range _" should be capitalized.
The fact that it is not seems to imply that you may have a variable, procedure, or function named "range".
That is a big no-no. You should never use reserved words (names of existing functions, objects, or properties) as the names of your variables or procedures.
That can cause unpredictable behavior and errors.

 

[Fluff]

You have a full stop before SortOn it should be a comma.

 

[fvisions]

Ok updated the Cap and received a syntax error. Sorry I am not good at compile errors.

  ActiveWorkbook.Worksheets("Installation wkg").Sort.SortFields.Add2 Key:=Range _
        ("v2:v" & LastRow).SortOn:= xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal

 

[Joe4]

You have a full stop before SortOn it should be a comma.

Good eyes, Fluff. I didn't pick that up without my reading glasses!

 

[fvisions]

You have a full stop before SortOn it should be a comma.

PERFECT thank you Joe & Fluff - you are the best!!

 

[Fluff]

Good eyes, Fluff. I didn't pick that up without my reading glasses!

I almost missed even with my glasses on time for an eye test.

PERFECT thank you Joe & Fluff - you are the best!!

Glad we could help & thanks for the feedback.