Thread: if activecell is value
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default if activecell is value
Dim r as range
Set r=ActiveCell
if r.Value = 1 then...


Set r=Range("Z100")
if r.Value=1 then...
--
Gary''s Student


"רוז×*ט" wrote:

what is the macro to identify if the activecell contains value
and what is the macro to identify if cell XX contains value

thank you
rozent
Reply With QuoteReply With Quote