Try:

PHP Code: 
lastrow = Range("C" & Rows.Count).End(xlUp).Row