Find Last row in sheet linked to sharepoint

[kingleviathan]

Hi Guys

I have a spreadsheet that has a range that is linked to sharepoint database.

i want to create a macro that does finds the last row in this linked range.

How do I do this?

Conventional last row search doesnt seem to work.

 LastRow = .Cells(Rows.Count, "A").End(xlUp).Row 'find last row
    Sheets("1").Range("W2").AutoFill Destination:=.Range("W2:W" & LastRow3056LCSLinked) _   
    , Type:=xlFillDefault   'Autofil column W2 which is outside the linked range to the length of the linked range

Any ideas

 

[kingleviathan]

Sorry that should read

Dim LastRow as Long
 
LastRow = .Cells(Rows.Count, "A").End(xlUp).Row 'find last row
    Sheets("1").Range("W2").AutoFill Destination:=.Range("W2:W" & LastRow) _   
    , Type:=xlFillDefault   'Autofill column W2 which is outside the linked range to the length of the linked range