Find last value in column and add +1 to the first empty cell in this column

[IKZOUHETNIETWETEN]

I want it to search for the last value in Column B, then I want it to copy this value to the first empty cell in this column B (so basically below the value that I just found) but add 1, so +1. So it found the value 1403 in B6 and I want it to become 1404 in B7 by a macro. Thanks!

Project.xlsx

[Trebor76]

Hi there,

Try this single line command:

Please Login or Register  to view this content.

Regards,

Robert

[Norie]

Try this.

Please Login or Register  to view this content.

[IKZOUHETNIETWETEN]

I get the value 1 in B3016 (end of my table) , I want to get the value 1404 in B7. Probably I get thsi cus this is a table, how do I override this? Thanks

Project2.xlsm

[IKZOUHETNIETWETEN]

Dont worry Ill just get rid of the table and it works, thanks!

[Trebor76]

Yes, the table range is throwing the macro out. That key piece of info would have been good to know from the start.

Try this:

Please Login or Register  to view this content.

Robert

[millz]

If you want to keep the table

Please Login or Register  to view this content.