Thread: Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Howard Howard is offline
external usenet poster
 
Posts: 40
Default Range

I have this formula:

-- If IsEmpty(Range(d9) Then
Range (e11").Formula = =(e5:e8)/4
End If

I want to insert the Else statement to do this:

If d8 and d9 are both empty then (e5:e7)/3

How do I do it?
Thanks,
Howard


Howard