Once i choose paste special for the required blocks to only paste the formatting in the C14 and D14 block it pastes the complete thing including the values . The paste formats isnt working . Could help me with it ?

Hi, This sounds very strange. Did you see this screen and select 'Format'? Best, Ned

Follow this topic