formula works in cell but doesn't work in vba

**maleeny31** · 02-05-2013, 12:17 AM

hye....what is the error in this code??? when i try this formula in cell, it works

Please Login or Register  to view this content.

but when i apply in macro, it shows error... can anyone help me to sort it out?? thank you...

Please Login or Register  to view this content.

**alansidman** · 02-05-2013, 12:26 AM

Try this:

Please Login or Register  to view this content.

**maleeny31** · 02-05-2013, 12:36 AM

Thank you so much....it works....

Re: formula works in cell but doesn't work in vba