[SOLVED] runtime error "424", object required

[danndiamond]

Hi all,
I'm facing a strange problem.
I'm using the following code to insert a picture in a worksheet and although it works fine in any new workbook I create
when I try to use it in the one that i need it I get a runtime error "424", object required, message. (Excel 2000)
Can anyone help please ?

Please Login or Register  to view this content.

[smuzoen]

Welcome to Excel Forum - please read our forum rules - when posting code make sure you enclose your code with code tags - see our rules at http://www.excelforum.com/forum-rule...rum-rules.html
The error I assume is occurring at (i.e. the line being highlighted in the VB Editor)

Please Login or Register  to view this content.

->This is the line being highlighted I assume? You will get an error if you hit cancel when browsing for an image and select Cancel? Change the code to include the variable pic being dimensioned as an object

Please Login or Register  to view this content.

If you do not declare the variable pic as an object then you will get Run Time error 424. A good reason to use Option Explicit to make sure that all variables get dimesioned

[danndiamond]

Thanks smuzoen.
I tried your suggestion and although I'm not getting an error message, I'm not having the pic inserted either.
And what I still don't understand is why the same sub works in some workbooks and not in others.
Thanks for your time anyway.

[Cutter]

@ danndiamond

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

The fact that you ignored smuzoen's request to use code tags is also against the rules. I urge you to become familiar with the rules in order to avoid any further errors.

[danndiamond]

Thanks for pointing out my error cutter. I'll make sure I don't repeat it.
Anyway, I solved my problem by using some other code.

[smuzoen]

The reason your picture was not showing was in the top calculation - if you step through the code the picture is imported however the top calculation was the cause of the issue. Anyway well done for finding a solution. To help others would you upload the solution you found.

[Cutter]

@ danndiamond

Based on your last post it seems that you have resolved your issue but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. As smuzoen says, you should post the code that solved your issue so that others coming across this thread may benefit from it.
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[danndiamond]

As I mentioned before i did come across some code that seems to work well, so this is it :

Please Login or Register  to view this content.