Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marta marta is offline
external usenet poster
 
Posts: 10
Default formula

Hello,
My macro contains the following formula:
With Worksheets("Entry Form").Range("K7")
.Formula = "=IF(ISBLANK(J7),"",AD7)"
End With
When i try to run it, it gives me a run-time error
(Application-defined or object-defined error).
What am i doing wrong?

Thanks for your help
Marta