"I working with a file that has about 150 columns and 1000 rows
I using a Hyperion formula that will at point return "#invalit Entity ???
does not exist

I was to use VBA to find all cases when the entity is invalid and replace it
with 0
or if there is a simpler was I'm open to it
--
Helping Is always a good thing