View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
smw226 via OfficeKB.com smw226 via OfficeKB.com is offline
external usenet poster
 
Posts: 98
Default IF/THEN Statement - Simple Question...

Hi,

This should be what you need assuming that B6 contains your flagged value

Thanks,

Simon

range("B6").select
if activecell.value <"Flagged" then

do your stuff

end if

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200610/1