Help is a lousy subject line and your explanation leaves a lot to mind read
over. Could you try again.

--
Don Guillett
SalesAid Software

"uobt" wrote in message
oups.com...
i need a vba script that will select any cell interiorcolor = 36
and then copy special paste value?