if range("a1:a10")="check value" then
end if
You can give any range withing the double quotes


--
anusha2525
------------------------------------------------------------------------
anusha2525's Profile: http://www.excelforum.com/member.php...o&userid=35408
View this thread: http://www.excelforum.com/showthread...hreadid=551788