I just need to cut cell contents leaving the source cell format unchanged, and paste matching destination cell formatting... I think not an uncommon ask?
I have searched but Google search filter bubble has got me - nada.
Paste special is not available for cuts? Paste options are greyed out.
I have tried recording a macro to copy with the clipboard sidebar open (the copied value appears there), then delete the source cell while I'm in it (leaving the format) then pasting in the destination cell by clicking on the clipboard item. That works when recording but the recorded macro returns an error "PasteSpecial methos of Worksheet class failed". While the item is in the sidebar, the actual clipboard has been emptied.
There seems to be some possible workarounds: 1: stop the clipboard being emptied by excel, (what genius came up with the idea of deleting clipboard? I suppose we're just lucky they were working on excel, not windows or office...) 2: somehow paste cut text as "value" or "formula" or "HTML". 3. an extraordinarily long code to set range, copy, paste, reselect range, delete, remove range name, reselect destination range!
Would be very grateful for help with this riddle.