Macro copy cell format

P

Pa Maher

If a cell ("A8:B8") on one worksheet ("Source")= "c"
The I want to copy the value and format (green fill, bold)
to a cell ("B9:C9") on another worksheet ("Quiz")
I am using
Worksheets("Source").Range("A8:B8").Copy Worksheets("Quiz").Range("B9:C9")
The text in the cell is copied but the format does not copy
 
C

CyberTaz

Apparently on a PC using a Windows version of Excel, but you've posted to
the group for Excel on the Mac.

Have a go at the WinOffice groups from here:
 

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 does not accept text format! 0
VBA Coding Help for Beginner 0
Summing a range of cells based on criteria in another range 2
Formatting and copy or copy and formatting ?? 2
Paste to excel from word - auto format problem 1
Copy addition formula of non-consecutive horizontal cells 2
Copy adjacent Sheet and name from a list 42
INDIRECT formula not working 1

Top