Posted to microsoft.public.excel.programming

Max Bialystock[_2_] Max Bialystock[_2_] is offline

external usenet poster

Posts: 31

copy the font color

Thanks Norman,
that's perfect.

Max

"Norman Jones" wrote in message
...
Hi Max,

How can I copy the font color (and only the font color) from A1 to B1?

Try:

'=============
Public Sub Tester()
With ActiveSheet.Range("A1")
.Offset(0, 1).Font.ColorIndex = .Font.ColorIndex
End With
End Sub
'<<=============

---
Regards,
Norman

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy cell and the font color	Falcon248	Excel Discussion (Misc queries)	4	January 22nd 10 07:36 PM
Retain font/cell color on lookup/copy	JPS	Excel Worksheet Functions	3	July 23rd 08 06:30 AM
VBA color picker - copy of Font dialog combo box	[email protected]	Excel Programming	27	December 5th 06 08:23 PM
Copy Rows that have a Green font color to another worksheet	mrdata	Excel Programming	6	February 15th 06 11:17 PM
How copy format, font, color and border without copy/paste?	Michel[_3_]	Excel Programming	1	November 5th 03 04:43 PM

All times are GMT +1. The time now is 11:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us