I've just started using Excel 2013, and I'm updating a VBA macro written in Excel 2003.
First, I've noticed that in the worksheet functions, NormSDist has been replaced by Norm.S.Dist. However, in VBA the syntax
doesn't work while
does still work. Is there a new syntax for accessing these worksheet functions through VBA or do I just continue using the old version? They have different syntax and I'd prefer to update.
In general, is there a way to bring up object properties for the 'Application'? When I right click I can choose 'List Properties' and it brings up a context list, but I'd like a more permanent window. The context list disappears after a few seconds for some reason.