Format Painter in Customizing Keyboard Commands
Alex
command in
"Tools" "Customize" "Keyboard"
There are other formating commands, but not that one.
Does anyone have a sugggestion on what Format command,
Format Painter is?
Thanks for your help. By the way, this is for a Windows PC.
Andy Brown
BTW, this is an XL newsgroup.
> In Microsoft Word 2000, format painter is not listed as a
> command in "Tools" "Customize" "Keyboard"
Paste Format is (Edit category). CTRL+SHIFT+C and CTRL+SHIFT+V should copy
and paste formats.
Rgds,
Andy
David McRitchie
CTRL+SHIFT+V is a user defined function (UDF), and you did
not include UDF coding that you are using. Various coding
has been posted to use that shortcut for a macro, in fact I used that
particular shortcut to Paste Special Values kind of the opposite
of pasting formats,
*******
I think Ctrl+SHIFT+P as in Painter might make a decent choice
for a Format Painter shortcut to avoid confusion between
using an F which could be Formulas or Formats, or a V which
could be Values as I have. do not empty the clipboard, because
the same formatting might be useful for additional usage, as
can be done with the Format Painter when you double-click..
*NOTE:* If someone can figure out how to resize to smaller
and larger destination ranges like the Format Painter uses
that would be great.
Sub PasteSpecialFormats() 'assign macro to Ctrl+SHIFT+P
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
'-- Application.CutCopyMode = False
End Sub
I actually use the Format Painter icon, but for those wanting shorcut key.
With the Format Painter, single cell destination selection is
resized to match to format painter selection, and the above macro does this.
The Format Painter allows you to choose other larger or
smaller destination selections and does this quite well, the
macro will not resize and apply unmatched range sizes except
for the single cell expansion..
******
My choice for Ctrl+SHIFT+V is to paste special values
which I just added more code today to display my own
error messages if clipboard is empty or range does not
match. A single cell range will use the same dimensions
as had been used with copy (Ctrl+C). Truth is I use the menus.
Sub PasteSpecialValues() 'assign macro to Ctrl+SHIFT+V
On Error Resume Next
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
If Err.Number = 1004 Then
MsgBox "Can't Paste Special Values from Empty Clipboard" _
& Chr(10) & "or dimension of multiple cells does not" _
& " match clipboard" _
& Chr(10) & Err.Number & " " & Err.Description
ElseIf Err.Number <> 0 Then
MsgBox Err.Number & " " & Err.Description
End If
Application.CutCopyMode = False
End Sub
****
Chip Pearson uses a right-click menu with associated macros
to paste formulas for a single cell
http://google.com/groups?threadm=uNR1fmHt%24GA.287%40cppssbbsa05
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Andy Brown" <andy.j...@ntlworld.com> wrote in message news:ufKRILNP...@TK2MSFTNGP11.phx.gbl...
Andy Brown
Sorry for misleading. CTRL+SHIFT+C and CTRL+SHIFT+V are pre-defined
shortcuts *in Word* (at least in my version (2000)), that being the subject
of OP's enquiry (I believe).
> I think Ctrl+SHIFT+P as in Painter might make a decent choice
> for a Format Painter shortcut
NB - CTRL+SHIFT+P *in XL* is a pre-defined shortcut to access the Font Size
control on the formatting toolbar (tho' I doubt anyone uses it).
Rgds,
Andy
Andy Brown
Rgds,
Andy
David McRitchie
to Word. Oh well, I improved fixed a an old macro and made up another
but it certainly would need some major enhancement to match the way
that the format painter handles selections of a different dimensions.
"Andy Brown" <andy.j...@ntlworld.com> wrote l...