Maybe this instead:

Code:
Range("a" & firstRow, "a" & lastRow)