Kiwi-123
asked on
Change delete row macro to delete cell range
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help. Thanks for the grade.
One thing though, if you were to convert your range to a table, the formulas would come automatically when you add a line, which could save you from having to keep them in all the time.
Thomas
One thing though, if you were to convert your range to a table, the formulas would come automatically when you add a line, which could save you from having to keep them in all the time.
Thomas
ASKER
Many thanks for your help!