Calling Excel functions in VBA

Hi All,

I'm a VBA rookie, starting to make some progress but getting caught out with a few things.

When calling excel functions from VBA I'm often finding that the Application.Worksheetfunction.Functionname() command is not working for me. I'm not getting specific error messages in VBA, but the code won't execute for some reason. Could any more experienced users offer some advice or known causes of such an issue?

Thanks.

Nick's picture

example please

example please