Autofill cell from cell above via vba

[adam.hewitt5]

What i am trying to do is.

When a button is pressed i want information to be populated into a sheet which is fine. I would also like the sheet to autofill the cell below. In cell A2 is a customer code MANC0001. When the button is pressed i want the cell below it to show MANC0002 and so on every time the button is pressed.

What i have so far is:

Please Login or Register  to view this content.

But with this i get error 1004

Any help on this would be fantastic.

Thanks

Adam

[arlu1201]

Try this

Please Login or Register  to view this content.

[JosephP]

you could simplify to

Please Login or Register  to view this content.

[adam.hewitt5]

Thats great joseph, works like a charm.

However, when i try and populate the sheet with the other information that is put into the first blank column, the information is going into row 4 instead of row 2. I have attached a screen shot of what i am talking about.

The code i have is

Please Login or Register  to view this content.

Screen Shot 2012-07-24 at 14.43.02.png

[JosephP]

it looks like you have cells that aren't really blank in the first tow rows of columns B onward. maybe try

Please Login or Register  to view this content.

[adam.hewitt5]

legend.

Thanks