Hi Nathan

You can create your own macro with this code line

Application.CommandBars("Standard").FindControl(ID :=108).Execute

Assign the shortcut you want to it


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Nathan Larson" wrote in message ...
I wish there were a built-in keyboard shortcut for the format painter in Excel. There is one in Word - just highlight some text,
use Ctrl-Shift-C to copy the format, highlight the text whose format you want to change, and then use Ctrl-Shift-V to paste it. I
tried it in Excel but it didn't work.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com