How can you retrieve information about the error that occurred using 'On Error GoTo'?

By: USER4347
28 Agustus 2025 Support 5 minutes
4.5
85 views 85 comments 7 shares
Responsive Ad Header

Question

Grade: Education Subject: Support
How can you retrieve information about the error that occurred using 'On Error GoTo'?
Asked by:
85 Viewed 85 Answers

Answer (85)

Best Answer
(270)
Within your error-handling block, you can use the built-in VBA objects 'Err.Number' and 'Err.Description' to get the error code and a textual description of the error, respectively. You can also use 'Err.Source' to determine which object or application raised the error.
Answered on 28 Agustus 2025

Related Articles

a) ''Zmeii traiesc in familii,iau de neveste fete frumoase si au palate bogate,insa ravnesc la bunurile de pret ale muritorilor.''
Am nevoie de analizaa va rogg

160 views 168 comments

analizati verbele to go si to wash la interogativ si negativ

60 views 60 comments

hitung luas permukaan dan volume kubus dengan panjang rusuk 6cm

63 views 63 comments

2x6:3x6:3x9 = cu cat este egal?

31 views 31 comments

1)Rezolvare completa:
-3·(-3x+1)+14=3(7x-3)-10
Multumesc!..

71 views 71 comments

text argumentativ rolul socializarii in societate

49 views 49 comments

KUMOHON DIJAWAB dengan cara yg mudah dipahami y

1.suatu kolan renang mempunyai ukuran panjang 25 m dan lebar 12 m. kedalaman air pada ujung yang dangkal 1 m dan terus melandai sampai 3 m pada ujung yang paling dalam. berapa literkah banyak air dalam kolam tersebut jika diisi penuh?

160 views 294 comments

Ce inseamna imagini sugedtive?

31 views 31 comments

Care este familia lexicala a cuvantului "minune" ?

51 views 51 comments

Alcatuiti o compunere PROPRIE libera pe tema naturii. Nu vreau ceva rapid si prost!

83 views 83 comments

Alcatuieste niste propozitii cu cuvantul vineri care sa aiba valori gramaticale diferite.

89 views 89 comments

Gaseste 4 variante în care se poate primi restul la 16 lei in bacnote
Dau coroana.

88 views 88 comments

probleme care se rezolva cu ajutorul ecuatiilor :

a+b= 80

76 views 76 comments

Apa yang dimaksud sikap siap meraih keunggulan

52 views 52 comments

probleme care se rezolva cu ajutorul ecuatiilor :

x-y = 20

71 views 71 comments

Relatează intr-o compunere de 10-15 de rânduri o întâmplare din viața ta în care ai avut parte de o dovada sinceră de prietenie .

129 views 129 comments

How do I check if Cloudflare Warp is active for my website?

59 views 59 comments

Realizați o descriere a unui colț din natură în anotimpul de primăvară folosiți adjective la diferite grade de comparație minim 15 rânduri .va rog am nevoie urgent ​

160 views 165 comments

What are the common causes of CoreTax DJP errors?

49 views 49 comments

QUESTION SIMPLE !!!!
Je dois me mettre dans la peau d'un directeur d'école et je dois inventer les règles de mon écoles. Je dois citer : les obligations, les permissions, les interdictions... J'ai déjà quelques idées mais pas assez ! Aidez moi à trouver quelques-unes de ces règles ! Merci d'avance ! :) (Ne pas faire en anglais, répondre en français !)

160 views 358 comments