i have come across a couple of times instances where there is a VBA function that does the same job as a function in excel
like
ASC
does tthe same as CHAR but it does it in VBA before going on to the sheet
my Question is
is there a way to get a list of ALL of the functions like this that exist in VBA???
also posted here
I dont like to use code i dont understand
it makes it hard to use in other situations
so please try to be as clear and patent as possible with me
Criticism is welcomed
Use the Object Browser and type in worksheetfunction
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
ah thanks roy got it
didnt know that you needed to typebefore
worksheetfunction.
thanks
friel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks