Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cell background color
Message
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Divers
Thread ID:
01660424
Message ID:
01660445
Vues:
35
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform