FINDING LAST ROW IN COLUMN NOT WORKING

[Rob342]

Hi Dean
Try this

Lr1 = .Range("C" & Rows.Count).End(xlUp).Row