Macro help -- clear rows instead of deleting them

Please can you help with the attached?

Basically the command button "Archive" moves the values occupied in column B:S onto the next worksheet "Archive"

The problem I have is that I don't want to delete the rows transferred, I would just like to clear the values in column B:N & R

The reason is that the formulas need to stay in situ and will reset once the values have been cleared.

If possible I would like to cap the limit on the "Archive" from line 9 to line 60

One other thing is that unless a date has been added in column N, the line will stay upon the current worksheet.

If you press the command button it should demostrate

Many thanks for your help!
Who is Participating?
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Try changing



Martin LissOlder than dirtCommented:
It would make helping you easier if you didn't almost always use the same "VB Help" Title.
Kiwi-123Author Commented:
Okay MartinLiss, will bare that in mind.
Kiwi-123Author Commented:
I've requested that this question be deleted for the following reason:

Will re-post with new name
Kiwi-123Author Commented:
Many thanks for your help!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.