<div>
<div class="content wysiwyg-content">
Hello,<br />
Is there a way to change the color of the background of a cell using MACRO in Excel?<br />
I've tried using <br />
&nbsp; &nbsp; cells.background = vbGray<br />
but it returns an error in properties..<br />
<br />
thanks..<br />
cris<br />

</div>
</div>


Hello,
Is there a way to change the color of the background of a cell using MACRO in Excel?
I've tried using 
    cells.background = vbGray
but it returns an error in properties..

thanks..
cris


changing cell color

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.