VBA Code to paste on next available line not working?

Good day all,

Once again in desperate need of an excel guru, I have a spreadsheet that allows the user to populate their own "Safe Work Method Statements" by way of check boxes, however there will be a number of Safe Work Procedures required & the problem I am having is every time a check box is ticked it replaces the original procedure but i require it to populate below the last on the same specified sheet ("Page4+)

Please Login or Register  to view this content.

Any advise would be immensely appreciated, thank you all & have a great day, Marco

hi,

See if this code helps.

Please Login or Register  to view this content.

Hi matrixpom,

See if change this line of code...

Please Login or Register  to view this content.

...to this helps:

Please Login or Register  to view this content.

Regards,

Robert

Hi,

The code I supplied worked for me.

I had a response from another site

Without providing a link to that thread you're braking the forum rule of cross-posting!!

I think the code Charles provided will offset the column by one, not the row.

You're using merging cells in your data which plays havoc when trying to set row and/or column variables with VBA, though my code seemed to work fine for me.

For reference this is also posted here

Hi,

The problem you are having is you are trying to get the last empty row using a defined range.
When you do the first copy past the defined range remains the same. You need to redefine the name range.
The following code looks at column M for the last empty row.
It makes the assumption it will alway have data.

Please Login or Register  to view this content.