Issues with VBA Vlookup

[Godders199]

Hello I am struggling to get this vlookup vba to work,

The Submission tab is a table , not range downloaded from adatabase.
I am trying to pull data from column AT, which has the followingformula in it
=SUM(AQ2+AR2+AS2)
When I run this code it returns no results
Dim lastrowcolumnb As Long
lastrowcolumnb = Range("m" &Rows.Count).End(xlUp).Row
For b = 2 To lastrowcolumnA
Set myrange= Worksheets(“submission”).Range(“S:AT”)

Cells(b,29)=Application.worksheetfunction.Vlookup(cells(b,13),myrange,28,False)
Next b

When I type the formula in manually I do get a result
=VLOOKUP(M2,Submission!S:AT,28,FALSE)

Any help appreciated as cannot see a reason for it notworking.

 

[steve the fish]

You call your variable lastrowcolumnb then use lastrowcolumnA.

 

[Godders199]

thanks, good sppot, i have changed but still returns no values.

 

[steve the fish]

What does happen? You also have the wrong inverted commas. You have slanted ones around your worksheet name. They need to be straight ones. ""

 

[Godders199]

Thanks , not sure what where the speach marks came from, it does now however error, which it previously did not.
The error I get is "Unable to get the Vlookup property of the WorksheetFunction class"

 

[steve the fish]

That means whatever is in Cells(b,13) of the activesheet is not found in the column S of worksheet 'submission'. b of course changes value at each iteration of the loop.