>>>Hi,
>>>
>>>A customer sent me a spreadsheet. Some cells (actually entire rows) have a background color that is kind of light shade of blue. But, is it possible for me to find out exactly what is the background color of a cell/row?
>>
>>open the vba editor, and the immediate window
>>
>>?activesheet().cells(22,8).interior.color
>
>Thank you. But I have done it before. How do you open the vba editor from Excel?
The immediate window is in the Visual Basic form.
Click the Visual Basic icon in the Developer page, just before help.
If you do not see the Developer tab, click the File menu, Options, Customize Ribbon and check the Developer checkbox in the right list box.
Bill
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only