From Terry Pinnell@21:1/5 to All on Sat Jul 24 15:05:15 2021
I use the Format Painter a lot and often it would be a bit faster
to activate it with the keyboard instead of clicking the tool
icon. I don't believe there is one built into Excel 365 so I tried
the trivial macro below. However, that and various other versions
I tried all fail.
How do I simply get it to simply click the Format Painter and copy
the active cell please, ready for pasting that format elsewhere?
'
Sub ClickFormatPainter()
'
' Select cell to copy then activate Format Painter, ready to paste
elsewhere.
' Keyboard Shortcut: Ctrl+Shift+F
'
ActiveCell.Address.Select
Selection.Copy
End Sub