Hello Reader,

I am trying to write a VBA code, which copy/pastes the formatting (just the cell background) of the used range of one workbook to the another. It should just copy/paste the cell background and nothing else formats say, fonts, cell styles etc.

I have tried my best, but not yet reached the solution. If you have done something like this in the past, your help is much appreciated !

PS: Both the worksheets from where the cell background is copied and where it is been pasted has the same sheet names and the same sheet structure.

Thanks,
Sourav