VBA error 1004
Solved
séverine
-
Floroan -
Floroan -
Hello forum
I have a macro that was created in Excel 5 and it worked well. But now when I run it on the new version of Excel, I get the error 1004 (cannot read the drawing objects property of the dialogsheet class)
Do you have any idea?
Thank you in advance
I have a macro that was created in Excel 5 and it worked well. But now when I run it on the new version of Excel, I get the error 1004 (cannot read the drawing objects property of the dialogsheet class)
Do you have any idea?
Thank you in advance
4 réponses
Hello,
The error 1004 is a very standard error that states an
object index overflow. It is very difficult to
find this kind of error without seeing the code.
I also had some trouble with the transition from 95 to 97
and, among other things, the names of the sheets would change in certain
circumstances.
If you want more help, transcribe your code here!
Lupin
--
~What is essential is invisible to the eyes~
~One sees clearly only with the heart~
The error 1004 is a very standard error that states an
object index overflow. It is very difficult to
find this kind of error without seeing the code.
I also had some trouble with the transition from 95 to 97
and, among other things, the names of the sheets would change in certain
circumstances.
If you want more help, transcribe your code here!
Lupin
--
~What is essential is invisible to the eyes~
~One sees clearly only with the heart~