Team,
I am trying to use the excel inbuilt function eDate as part of my VBA code
I am getting the exception "Sub or Function not defined". Do we need to initialize any thing in our code so that this function works?
I already enabled atbvbaen.xls from VBA proj references which seems to be requisite to kick that function in as per my search on net.
Instead of just mentioning it as
Use it as
Please Login or Register to view this content.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
This works now. Thanks man
Glad it helps you and thanks for the feedback.
Just an Additional Information You will get the list of worksheetfunctions in vba if you type worksheetfunction.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks