Shortcut - macro

[vvorland]

Hi, I'd like to add a keybord shortcut for the 'Format Painter' tool. I've tried to make a macro with the shortcut ctrl+shift+v

Please Login or Register  to view this content.

It works if I've copied a cell before I press ctrl+shift+v, but if no cell is copied I get a run-time error '1004' - 'Paste special method of range class failed.'

Any thoughts?

[BigBas]

The format painter copies the format from one cell and applies it to a destination cell. If no cell is copied, then it cannot apply a format, hence the error.

If not copying a cell's format, what exactly are you trying to do? Perhaps we can find a workaround.

[vvorland]

Thanks for the reply.

If I accidentaly press 'ctrl+shift+v' without having previously copied a cell I don't want anything to happen, but if I have copied a cell, I'd like to be able to copy the format to several cells (equivalent to the dobbleclick on the format painter)

Sorry that I didn't explain it thoroughly.

[BigBas]

I see. I misunderstood you the first time. Try this code. It will exit the sub if there is an error, but should paste the format if a cell is selected:

Please Login or Register  to view this content.

[vvorland]

Thanks Problem solved