Thread: Convert array formula into VBA module
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Forgone Forgone is offline
external usenet poster
  
Posts: 60
Default Convert array formula into VBA module
I tried using the worksheet version Tools Formula Auditing
Evaluate - it passes the first condition ({=IF(BCostCentre="",) which
works but excel dies when it moves on.


I'll try it and see how it works.
Reply With QuoteReply With Quote