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
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.'Sub PasteFormat() ' ' PasteFormat Macro ' Macro recorded 20.02.2008 by vvorland ' ' Keyboard Shortcut: Ctrl+Shift+V ' Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False End Sub
Any thoughts?
Bookmarks