In visual basic, I can set the color of a cell with the .interior.colorIndex property. How can I read the color of a cell before I change it?

Submitted by: Administrator
Use a line of code like this:
OrigColor = Selection.Interior.ColorIndex
Submitted by: Administrator

Read Online Microsoft Excel Job Interview Questions And Answers