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!
help---11-09-2012.xls
Kiwi-123Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Try changing

            row.Rows(1).EntireRow.Delete

to

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

Will re-post with new name
0
 
Kiwi-123Author Commented:
Many thanks for your help!
0
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.