Copy cell backgound color to another cell

J

John

I have a macro that color codes projects. I want to copy the cell text and
background color from one cell to another. I can copy just the name w/ the
following code:
ProjectName = Range(SumProjList)(i).Value ' pick up the proj name
.....
Range(ToTable)(2, 2).Value = ProjectName ' place name in another place
What do I have to add to copy the background cell color?

I appreciate your help, -John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy files from Onedrive account to another 2
conditional format - table - cell empty return default color 1
Use BeforeDoubleClick to place 1 or 4 character in a cell 1
Remove Hyperlinks Without Changing background shading 14
Copy colored cell to a second page 1
Search other sheets for numbers & color them 10
Visio shape text disappears upon copy paste 1
Placing value in every col of a named range row 1

Top