ok just add.

I have originally. Worksheets("OVERALL DS SUMMARY").Activate
{
'first line is Range("G6").select
all of my conditional formating code

}

' then I add

Worksheets("DS Admin - RC3000").Activate
MsgBox "hello"
Range("G6").select
MsgBox "hello2"




It gets to the first msgbox but then it crashes with the error "400".

DS Admin and DS SUMMARY are identicle in layout but have different
values


--
evil baby
------------------------------------------------------------------------
evil baby's Profile: http://www.excelforum.com/member.php...o&userid=31983
View this thread: http://www.excelforum.com/showthread...hreadid=518265