Try to execute macros. Or if you can use Write Cell so that particular range would be overwrite will no value
These are some examples
Hope this helps
Thanks, Prankur