Updating "#Invalid entity XXXX" using VBA
 

"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

Updating "#Invalid entity XXXX" using VBA
 

Dim rng as range
Dim cell as Range
set rng = Activesheet.UsedRange.specialcells(xlformulas,xlTe xtValues)
for each cell in rng
if instr(1,cell.value,"#Invalid",vbTextCompare) then
cell.value = 0
end if
next

--
Regards,
Tom Ogilvy

"QuietMan" wrote:

"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

Updating "#Invalid entity XXXX" using VBA
 

Thanks Tom, will try it later
--
Helping Is always a good thing


"Tom Ogilvy" wrote:

Dim rng as range
Dim cell as Range
set rng = Activesheet.UsedRange.specialcells(xlformulas,xlTe xtValues)
for each cell in rng
if instr(1,cell.value,"#Invalid",vbTextCompare) then
cell.value = 0
end if
next

--
Regards,
Tom Ogilvy

"QuietMan" wrote:

"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