excel vba - Run-time error '-2147418113 (8000ffff)': Automation Error -
After
"c =" "then" if my code is running completely. At this point runtime error '- 2147418113 (8000ffff)': Automation error has been raised. I have started an error again, to see this, start the next statement again if I leave this line and it gets cured, then it is fine. I do not really understand what this error meant and I was not getting useful information about it. Can anybody bring this problem to light? I have the "if c =" "then" to "that Lennon (c.value) = 0 Then" have tried to change, but all variables AddresRawDataFile raises the same error (range) The form is defined in public and they were determined by taking into a separate module, called PublicVariable, which is said by every process.
private sub CommandButton3_Ok_Click () variable as a version "array used to dim MsgAlert string dim as above as MsgBoxAlert each structure dim AddressRawDataFile 'dim for many investigations C message box as the version related 'Box2_UPb_Options' variable AddressRawDataFile = array (RawHg202Range, RawPb204Range, RawPb206Range, RawPb207Range, RawPb208Range, RawTh232Range, RawU238Range, _ RawHg202Header, RawPb204HeaderRange, RawPb206HeaderRange, RawPb207HeaderRange, RawPb208HeaderRange, RawTh232HeaderRange, _ RawU238HeaderRange Require values from Box2_UPb_Options Starting from Ntit to) variable with the address code "Next error then if c = all of the above variables should not be" for each c AddressRawDataFile = "" Then MsgBoxAlert = MsgBox ( "start -and-place one or more addresses missing sheet. "& Amp; _" Please, it's Czech. ", VbOKOnly," missing out ") load Box2_UPb_Options Box2_UPb_Options.MultiPage1.Value = 2 Box2_UPb_Options.Show end next < / code>
<: item named
RawHg202Range
etc. range
objects you should use nothing
if they address to check empty> AddressRawDataFile = array (RawHg202Range, RawPb204Range, RawPb206Range, RawPb207Range, RawPb208Range
Comments
Post a Comment