Macro to see 0 as Blank

[RobP614]

Hello,

I have a semi-complex macro file devloped for a function or our AS/400 system.

I have been asked to modify the macro the run a field as a blank, which I never planned for in my orginal design and now I can't figure out how to had it in...

I'm going to provide the primary file so that someone can maybe take a look and give me an idea.

The main tab titled Lean% references over to the macro tabs titled Macro Static and Macro Flow. (Colum C is my main reference point)

For example line 59 in the Macro Static tab is set to ref ='Lean %''s'!$C$16 if the ref turns out to me a 0 I need it to leave a blank, and just going on to the next line in the macro.

Thanks,
Rob