I have a worksheet as attached which needs someone helping me how to make my VB code works.
The problems are as follows:
i. A " Run-time error '1004' pops up after I click the run "button" when the sheet Protected .
ii. If it is "unprotected" the items at columns "BA:BE" will automatically moved to " column AY".
Your help is very much appreciated. Thank you.