View Single Post
  #1   Report Post  
Excel Format Copy
 
Posts: n/a
Default How do I copy a cell (content AND format) from one worksheet to a.

What worksheet function will copy both the content AND format of a cell in
one worksheet to a cell in another worksheet? I want to copy both text or
data and the format such as background color or border, under program
control. This would be a combination of both "=" function and "Format
Painter".