>>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement