how do I use VBA to set background of a cell
One of the easiest ways to get this kind of syntax is to record a macro when you
do it manually.
I usually do it in a test workbook so I don't mess up the real one.
keith wrote:
Hello,
Using the following basic syntax
Worksheets("Sheet1").Range("A1").Value
How would I sent the of the cell ranges to yellow (or any other color)
Keith
--
Dave Peterson
|