Is there a way to use the format painter in VBA? I mean, basically copying all the formatting properties of one cell into another cell?

Thank you in advance!