Error With Finding Last Row holding data in a Column

[Ark68]

I have this line of code in which I am trying to find the last row in which data exists within a column. Pretty simple concept, but my method is leaving me with an error. I think it may be just a matter of failing to adapt a line of borrowed code to my particular needs.

lrw_lst = ws_lists.Cells(ws_lists.Rows.Count, ws_lists.Columns(mcol)).End(xlUp).Row

results in a type mismatch error.

lrw_lst is decalred as long.
mcol = 17

 

[Fluff]

Maybe

lrw_lst = ws_lists.Cells(ws_lists.Rows.Count, mcol).End(xlUp).Row

 

[Ark68]

Yeah!!! Thanks Fluff, that was indeed the fix.

 

[Fluff]

You're welcome & thanks for the feedback.