VBA SubString giving unexpected error
Here is the code:
fail.PNG
Everything but the last line is working. Getting a compiler error as invalid qualifier on "temp" on temp.Substring(0, 4). The previous line works and grabs the correct string. I've tried using another string that I manually assigned a value like "hello" and I still get this error.
Last edited by AlejandroJ; 06-01-2021 at 12:00 PM.
This codeline is a non sense as the variable is not an object and do you find any 'Substring' statement within the VBA help ?!
This is VBA not .Net
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks