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

Excel VBA 1
Placing value in every col of a named range row 1
Determine Excel cell location 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
conditional format - table - cell empty return default color 1
Get text & background color with single button click. 1
Cell Background Color Change --> Change Event 5
Change cell color 1

Top