Thread
:
Use VBA to format paint cell(s)
View Single Post
#
4
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Use VBA to format paint cell(s)
Record a macro when you do Edit|copy, edit|paste special|Formats
And you'll see the code you'd use.
wrote:
Among many other things I'm programatically adding values to cells in some
worksheets that need to match existing formatting...
"Bob Phillips" wrote:
It can be, but why not just use the format painter?
--
HTH
Bob Phillips
" wrote in
message ...
Is it possible to make the formatting of a target cell the same as some
source cell - like through the use of the toolbar "format painter"?
If not what's the best way to go about replicating formatting from one
cell
to another?
Thanks in advance for any ideas you have.
Charles
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson