⟩ 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?
Use a line of code like this:
OrigColor = Selection.Interior.ColorIndex
Question and Answer:
Home MS Excel
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Maybe you can help.... I use Excel not for calculation but for maintaining large mailing lists which I usually import from text files.Simple question... how do I keep Excel from dropping the leading zero when I import a 4-digit mail code? I NEED that zero there. I understand that I can format the cells to text and THEN TYPE the number in and the zero stays... but who has time for that? Is there a way to IMPORT or OPEN a text file in excel and keep the leading zero?
Can I see a list of the ColorIndex and the corresponding color?
How can I get Excel to accept an entry like "5+5" without the leading equals sign as a formula? I have done this is the past but can not remember how.?
How can I speed up my Macro execution?
How can I make the screen stop flashing during macro execution?
How can I format a worksheet to have alternating green and white rows like a "greenbar" report?
How can I show the complete path and filename in the Excel title bar?
How can I copy the name of the worksheet tab to a cell in the worksheet?
Hey! Excel used to have letters to indicate the columns. Now, all of a sudden, there are numbers for the columns?
I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?
