That gives me a #Name? as a result. This is the same problem I have been running into. Yes the ranges are huge. Somehow 6 weeks of work got overwritten (programmer issue) so I am trying to consolidate old work with new work so that I do not have to spend another 6 weeks working on it.
I cannot figure out why I am getting that result. If you have any more suggestions I would be eternally grateful.
What does
=IFERROR(1/0,"a")
return ?
You definitely running 2007 ?
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
i.beard 
Register To Reply
Bookmarks