VBA code for excel if formula

[devawad]

Dear All,

I need vba code for this =IF('Na Cal'!B4>=1,'Na Cal'!B4,"") excel formula.

attached file your ref..

Thanks in advance.

Dev.

[hafizimran]

Please Login or Register  to view this content.

[devawad]

Dear hafizimran ,

Thanks for your quick reply,
I tried this but is shows error message compile error - invalid outside procedure

Am I doing something wrong please guide me

Thanks in advance

Dev.

[hafizimran]

In which place you are using this code?? I mean you should use it inside a macro or another procedure like this:

Please Login or Register  to view this content.

[devawad]

Dear hafizimran,

Thanks, but I don't want to record any macro just want vba code.

Dev.