| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy the font color
How can I copy the font color (and only the font color) from A1 to B1?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy the font color
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy the font color
Copy - Paste Sprecial can copy only formats. The color index is a type of
format. "Norman Jones" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy the font color
Hi Joel,
'---------------- Copy - Paste Sprecial can copy only formats. The color index is a type of format. '---------------- The OP's question explicitly specified: " ... copy the font color (and only the font color) ..." - hence my response. --- Regards, Norman |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy the font color
I know formats will copy other things along with color index. Wasn't sure if
Max wanted to use VBA code. "Norman Jones" wrote: Hi Joel, '---------------- Copy - Paste Sprecial can copy only formats. The color index is a type of format. '---------------- The OP's question explicitly specified: " ... copy the font color (and only the font color) ..." - hence my response. --- Regards, Norman |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy the font color
"Joel" wrote in message
... I know formats will copy other things along with color index. Wasn't sure if Max wanted to use VBA code. Perhaps he wants to colour to "Bloom" ;-) |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell and the font color | Excel Discussion (Misc queries) | |||
| Retain font/cell color on lookup/copy | Excel Worksheet Functions | |||
| VBA color picker - copy of Font dialog combo box | Excel Programming | |||
| Copy Rows that have a Green font color to another worksheet | Excel Programming | |||
| How copy format, font, color and border without copy/paste? | Excel Programming | |||
![Max Bialystock[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
