I decided to delete all the content from every page of the document so the I had a blank work book, no VBA script, no Content (just column and row sizes) then tried to do manipulate the sheets This action wont work on multiple selections. You can deal with it as following steps: 1.