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.
example please
example please