function that returns cell and or font color of another cell

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

is there a cell that returns the numeric d=code for the font or background
color of another cell?

thanks in advance,
mark
 
Sub MarkColor()
x = Range("A1").Font.ColorIndex
y = Range("A1").Interior.ColorIndex
MsgBox "Font color is " & x & ", Interior color is " & y & "."
End Sub
 
You must log in or register to reply 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

count cells with diagonal borders 3
Tabname function 1
Remove Hyperlinks Without Changing background shading 14
conditional format - table - cell empty return default color 1
Automatically control the font of a cell when a function is used 2
functions to change color of fonts or cell backgrounds? 1
Copying a Picture From Cell Comment 0
Compare font colors 6

Back
Top