Hello mister, I'm a french student and I have an important project and your awesome video help me and my group a lot. Thank you very much ! You are the best !
Hi, I am facing an error while I run the following code: On Error Resume Next Set userRange = Application.InputBox(Prompt:="Enter the cell where you would like to insert the positions of " & n, Type:=8) On Error GoTo 0
If userRange Is Nothing Then MsgBox ("No Range was entered") End If Saying that End If without Block If; Can you help with this? Thanks in advance. Note: This is just a block of code but the error comes up when I keep the If statement at the end.
HI, Thanks for this wonderful video. One question please - if in VBA query first I have used On error resume next because i wanted to ignore the errors on top and then later on at some point down If error occurs I need to goto xxxxxx: for that i used this on error goto xxxx: so do you think it will be fine. Or it will still go to first resume next and then come to this second error part. request your answer please
Thank you for this video, this is exactly what Im working on for my project. If after the error handler you expect another error, can you create another error handler? Thank you.
Thank you sir for this video. But I still have some doubt on "on error goto 0". I am not able to make a difference when i am simpally running my code and when i am running with the "on error goto 0". In both cases i am getting the same output. my code is :- sub fun on error goto 0 if 0/0 = true then msgbox "keshav singh" end if end sub fun
+Luis dso on error goto 0 resets the way excel handles errors. If you add that to the code it will act like like it does by default for the rest of the code. In other words after the goto 0 the debug window will pop up if excel encounters an error.
I've never seen anyone use backspace as much as this guy....great content, just an observation
Yeah a bad habit for sure
Hello mister, I'm a french student and I have an important project and your awesome video help me and my group a lot. Thank you very much ! You are the best !
Glad it helped. Hope you did well in your class
Ah! It was the Exit Sub before the error handler that was confusing me and wasn't mentioned anywhere else I looked. Thanks!
Error handling can be a pain for sure
I like whten you say "This is very helpful", of course they are! many thanks. 😊
Hi, I am facing an error while I run the following code:
On Error Resume Next
Set userRange = Application.InputBox(Prompt:="Enter the cell where you would like to insert the positions of " & n, Type:=8)
On Error GoTo 0
If userRange Is Nothing Then MsgBox ("No Range was entered")
End If
Saying that End If without Block If; Can you help with this? Thanks in advance.
Note: This is just a block of code but the error comes up when I keep the If statement at the end.
After "then" you need to add a new line or remove your end if.
If statements be on one line and if they are you don't need and end if
Good info. Would be nice if you wrote the codes separately instead of commenting out the previous version. Thank you
Ok next time. Good input
Sometimes in error goto wrking getting runtime error 91 how to resolve this pls help me out
Very useful. Thank you.
HI,
Thanks for this wonderful video. One question please - if in VBA query first I have used On error resume next because i wanted to ignore the errors on top and then later on at some point down If error occurs I need to goto xxxxxx: for that i used this on error goto xxxx: so do you think it will be fine. Or it will still go to first resume next and then come to this second error part. request your answer please
You would have multiple goto lines it would look a little like this
GoTo first:
Code
GoTo Second
Exit Sub
First:
Exit sub
Second:
Exit sub
End Sub
really straightforward tutorial, tysm
Thank you, your video was very helpful
Glad it was helpful!
Very helpful! thank you so much! you just saved me from staying til dawn. 😂😂
Glad it helped
Thank you for this video, this is exactly what Im working on for my project.
If after the error handler you expect another error, can you create another error handler?
Thank you.
Great Question... I just posted a Video that shows you how to handle multiple errors
th-cam.com/video/bqZBE7ioimQ/w-d-xo.html
+EverydayVBA
Thank you very much. It worked perfectly for my project.
Man!! You saved my life hahaha Thanks!
Glad I could help!
Thank you sir for this video.
But I still have some doubt on "on error goto 0". I am not able to make a difference when i am simpally running my code and when i am running with the "on error goto 0". In both cases i am getting the same output.
my code is :-
sub fun
on error goto 0
if 0/0 = true then
msgbox "keshav singh"
end if
end sub
fun
thank you sir, i understand that on error goto 0 , stop the code where is the error, is it true?
+Luis dso on error goto 0 resets the way excel handles errors. If you add that to the code it will act like like it does by default for the rest of the code. In other words after the goto 0 the debug window will pop up if excel encounters an error.
Great thanks
very clear thank you EverydayVBA
Thanks I appreciate it
Awesome!! Thanks a lot !
Thanks for the props
Thank you
You are welcome glad it helped
Tks ! :-)
Thanx
👍
Thanks a lot
thank you
Your welcome