Use VBA to format paint cell(s)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Among many other things I'm programatically adding values to cells in some
worksheets that need to match existing formatting...
 
Record a macro when you do Edit|copy, edit|paste special|Formats

And you'll see the code you'd use.
 
Back
Top