Macro to Shade the selected cell

[Sukie Uppal]

Hello,
I am looking for a Excel 2007 macro that when run will shade the selected cell. Say I am in cell B9 and I run the macro, the cell will be shaded Yellow
Thank you

EggHeadCafe - Software Developer Portal of Choice
XML Serializer Generator and Application Perfomance
http://www.eggheadcafe.com/tutorial...b9-dd68447ba187/xml-serializer-generator.aspx

 

[Dave Mills]

Turn on macro recorder and record the actions you do interactively.
Press ALT+F11 and open the Module code to see what it has written.