Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cell background color
Message
General information
Forum:
Microsoft Office
Category:
Excel
Miscellaneous
Thread ID:
01660424
Message ID:
01660445
Views:
34
>>>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
Map
View

Click here to load this message in the networking platform