If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Code for marking formulae as a check they have been copied correctly

Thread starter Dermot
Start date Jul 25, 2020

Overview Discussion

Dermot

Board Regular

Jul 25, 2020

Dermot submitted a new Excel article:

Code for marking formulae as a check they have been copied correctly - Code for marking formulae as a check they have been copied correctly

This code will make a copy of the active sheet and then mark up the formulae, using shading to show which ones have been copied, and from where.
Solid colour = this cell has NOT been copied from left or above
Horizontal hatch = this cell has been copied from the left
Vertical hatch = this cell has been copied from above
Cross hatch = this cell has been copied from the left+above

The idea is to make it much easier to check a complex sheet, because you only have to check the solid coloured...