Format painter by macro

[besis]

Hi,

I found this nice code on the internet for formating cells, it works good.
But how can I make this code work like if I dont select cells to format then it would not bring the error: Run-time error '424' Object required
I would like also to not bring the error in the case if I click cancel the message box.

Please Login or Register  to view this content.

Thanks in advance.
B.

[WideBoyDixon]

Trap the error and exit the Sub:

Please Login or Register  to view this content.

WBD

[besis]

Hi,

Thank you for this. Is it possible to make this whithout asking me to select cell.
I mean just as in Excel I click the format painter and after that I just go and click the cell I desire to format?

Thanks for helping.
B.

[WideBoyDixon]

Remove your other code and paste this into the ThisWorkbook module:

Please Login or Register  to view this content.

That should hopefully do what you're after.

WBD

[besis]

Hi,

Thank u for this solution. This is nice one.

All the best.

T.B