• Macro to select the Format Painter?

    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
    ' Keyboard Shortcut: Ctrl+Shift+F
    End Sub


    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)