Is there a way to add a row of data to a worksheet using a macro? I need to
determine the last row of data already there and then append on the next row
some static data. The rows of data will change each time I use this workbook.

Example:
On a cloumn with 1224 rows of data, I need to add on the 1225 row the number
1000 automatically. The rows of data will change each time I use this
workbook.

Thank you

Ric