Hi,
When I tried to compile my VBA code I'm getting an error that says "Label not defined ". The label that it is referring to is getNextRowStudentVIIandVIII.
I'm attaching the excel with the macro and vba code. Kindly help me. Its quite urgent. Thanks friends.
If this is a label as inthen the label needs a colon ( : ) on the end of it.
Please Login or Register to view this content.
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi !
As a good code does not need any label - except for error handling - since more than 20 years for VBA ! …
Hi , I have given a colon. I rechecked. Still getting the same error
In this case, it is because you have put an "End Sub" after each of the Return statements. You will need to comment them out except for the last, the actual end of the subroutine. It will then compile. GoSub is not an approach that I use so I cannot comment on its effectiveness.
Gosub and Goto are statements from more than 30 years ago of the VBA grand pa' : the BASIC !
But they were left with the coming of some advanced version like Quick Basic and Turbo Basic more than 20 years ago.
So since the beginning of VBA (more than 20 years) a good code does not need any Gosub neither any Goto statement …
@Marc L: I agree with you, but the OP is where the OP is, so it is perhaps more helpful to get the code to compile and, hopefully, work rather than criticising the approach. I'd probably use called subroutines or functions but, that said, I wouldn't know where to start to address this problem ... so the OP is one or two steps up on me.
Thanks a lot friends. So many end subs !! I agree. It is compiling now. Thank you very much
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks