Identify last used cell in column with blanks in between

[sharky12345]

Can anyone show me how to identify the last used cell in a column that has a combination of data and blank cells?

The rows this applies to is 8:214 so I just need the last cell within that range, (column L), that has a value.

 

[footoo]

Dim lastCell As Range
Set lastCell = [L8:L214].Find(What:="*", after:=[L8], searchdirection:=xlPrevious)

 

[sharky12345]

Thanks!!