View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aidan.heritage@virgin.net is offline
external usenet poster
 
Posts: 244
Default Dynamic Conditional Statement

If activecell.value=40 and range("A30").value=60 then
'condition tests as true
'#####################################
' not sure if you meant 60 in quotes though!
'#####################################
end if