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

^ Can anyone explain this function?
I understand up to first open bracket, but the rest I'm new to.

Thank you