LinkBack URL
About LinkBacks
I'm trying to use an Excel function in VBA but it give me an error stating "Object doesn't support this property of method". Am I missing something obvious? Here is the exact line: MySerial1 = WorksheetFunction.Mid(A2, 3, 1)
I'm trying to use an Excel function in VBA but it give me an error stating "Object doesn't support this property of method". Am I missing something obvious? Here is the exact line: MySerial1 = WorksheetFunction.Mid(A2, 3, 1)
Last edited by FuzzyDove; 03-23-2010 at 01:26 PM. Reason: solved
Hello FuzzyDove,
I am not sure why you are using a worksheet function for something that is already defined in VBA.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Mid is also a VBA function. You can use:
or, if A2 is a variable.(can be a single cell range or string)Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mdbct; 03-23-2010 at 01:17 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks