Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
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.
results in a type mismatch error.
lrw_lst is decalred as long.
mcol = 17
Code:
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