Good morning Patrick Simmonds

Does this help:

Range(Cells(1, 6), Cells(1, 6)) = "Exempt"

Range is the command to identify a range, but you need two lots o
identifiers, a start and a finish, that in this case are the same as w
are identifying a single cell.

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=47164