Scott,

Normally you would just use this function to return a ColorIndex value, as
selected from the palette. What I was saying was that you could demonstrate
it by typing ?ReturnColorIndex() in the immediate window, so that you can
get used to using it and how it works. To get the immediate window, go to
the View menu in the VBE and click the Immediate Window option. Then just
type that code into the window.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"scottnshelly " wrote in
message ...
Thanks Bob,
i'm afaid i don't know what you mean by 'immediate window'. Where
exactly should i put ?ReturnColorIndex() ?
Thanks,


---
Message posted from http://www.ExcelForum.com/