Re: Format Painter keyboard shortcut

[David McRitchie]

Hi Alex, (reply to old posting in misc with email copy to Alex)
I made up a macro that you can tie into a shortcut key of
your choice i.e. Ctrl+Shift+P

You can find everything, latest macro & update, in
http://www.mvps.org/dmcritchie/excel/paste.htm#painter

and just so everything can be found from here once archived a reference to
a later thread in programming can be found in Google Groups at
http://groups.google.com/[email protected]

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

 

[David McRitchie]

Hi Paul,
See the other thread. The only reason I replied in this old thread
was for those looking in the archives to find a solution and pointed
to the thread where I asked a question as well as what works for a
solution to this month old thread. I copied Alex in the posting to this
thread and I think it bounced.

The other thread is referenced on my web page,
http://google.com/[email protected]
and it is not the only thread referenced on my web page..

You are asking me to explain problem that I can't explain,
and asking for an explanation which was my reason for posting
(in the above thread)
in the first place. As already mentioned in that thread I can't
identify under what conditions it suddenly worked w/o that
line of code or why it failed again later. I can't duplicate it
to make if fail consistently under unknown conditions.
(inconsistent/intermittent problems are less likely to get solutions)
I know that the line makes it always work consistently in
Excel 2000, well at least for what I tested, and I had tested
multiple ranges as well like you had..

But even if it worked without the
line in Excel 2000, it was already pointed out that it did not work
in Excel 97 therefore since the code does not harm anything
it would have to be included (IMO) so that it works for everyone,
even if Excel 2002 never has the problem, it wouldn't do me
any good to omit the line of code in my Excel 2000.

Please continue discussion in the later thread that specifically
addresses the macro.