Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with macro to copy, paste, and clear cell values
I have a work sheet (protected but no password) that contains some
cells with formulas (locked)and some cells in which I will enter numerical values (unlocked). This is the information about the worksheet: range is from A20:K26, cells that require me to enter data are C20 and E22:G26, all other cells contain formulas or values that remain constant (names, header rows, etc.). When I leave G26, I would like to unprotect the sheet, copy entire range from A20:K26 to A27:K33, clear the values in cells C27 and E29:G33, and re-protect sheet. I recorded this macro in Excel 2007 and it worked...the first time but not when I tried to run it again. I did have relative references turned on as this was highlighted on the Developer Tab. Can someone please help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy paste values macro | Excel Discussion (Misc queries) | |||
copy paste cell with value using macro | Excel Discussion (Misc queries) | |||
Macro for copy and paste values | Excel Discussion (Misc queries) | |||
Copy range in macro using paste special values | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions |