lastrow is a variable for the last row, rows are designated by number, best declared as Long
you need to calculate lastrow as it will continually change, see this for how to.

You may also be interested in a list of VBA sites compiled by hiker95 over at MrExcel and posted in this thread