Hi all,

I am sure that someone will be able to give me a very quick and simple answer on this one but I have hit a brick wall with it.

My spreadsheet is a large export from a database and I am using sort within macros to manipulate the data. So that I am able to return it to it's original sort I have inserted a column (A) and I want the numbers 1, 2, 3 etc to run down the column until the last row active in the spreadsheet.

So, my spreadsheet contains the following:
A1 = 1
A2 = 2
A3 = 3

What I want to do is autofill A1:A3 to lastrow.

how do I do this?

Thanks in advance,

Pedros.