Last row from another sheet

[wmtsub]

Thought this would give me the last row in another worksheet of my work book,It does not.
Please - why not?

LR = Sheet("Pob").Cells(sht.Rows.Count, "D").End(xlUp).Row

 

[Joe4]

I don't think that "sht" reference should be in there.
Try:

LR = Sheet("Pob").Cells(Rows.Count, "D").End(xlUp).Row[/COLOR]

Note that this is giving your the last row with data in column D on the "Pob" sheet.
Make sure column D is the right column to use for this determination.

 

[wmtsub]

I get an error still Sub or funtion not defined.
Would being a table make a differance?

 

[My Aswer Is This]

I get an error still Sub or funtion not defined.
Would being a table make a differance?

Change Sheet to Sheets

Like this:

LR = Sheets("Pob").Cells(Rows.Count, "D").End(xlUp).Row

 

[Joe4]

Change Sheet to Sheets

Good catch...

 

[Norie]

It should be Sheets("Pob").

 

[wmtsub]

Awesome.....thanks.