Thread: If...Then function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pingin Pingin is offline
external usenet poster
  
Posts: 2
Default If...Then function
I was wondering if anyone could help me get this to work

If Range("B30:BS30").Formula = "=SUM(B19:B29)" Then
Range("B31:BS31").Value = "yes"

Reply With QuoteReply With Quote