Kiwi-123
asked on
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
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
Martin Liss
It would make helping you easier if you didn't almost always use the same "VB Help" Title.
ASKER
Okay MartinLiss, will bare that in mind.
ASKER
I've requested that this question be deleted for the following reason:
Will re-post with new name
Will re-post with new name
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Many thanks for your help!