run-time error '13' Type Mismatch error

Dear community,

I am trying to use the macro below to place a picture, however, I am receiving the error;

run-time error '13' Type mismatch.

The de-bug is highlighting the line "For Each oPic In Me.Pictures"

has anyone seen this before or is able to help resolve this issue?

many thanks

Please Login or Register  to view this content.

ption Explicit

Code works for me.

Given the routine is an event I assume the code is within a sheet object?

Andy, how's it going dude? hope all well with you and that you are enjoying the summer. Eek what summer!

the code tis indeed placed in sheet 12 where i want the action to happen.... im stumped!

any more clues?

It's going well thanks!
Longs as it shines when I do get a break I don't care.

Can you post an example to illustrate the problem. Nothing wrong with the code.

Hiya - when are you taking your break? going anywhere nice? we just got back from Roundhill Campsite in the New Forest nr Brockenhurst.

The weather was terrific. We took a tent and grandma and grandad took their caravan. The children loved it although it's pretty hard work trying to get them washed or taking them for a pee in the middle of the night! Anyway. it was a break and i'm now an expert with a frizby!

The worknook is about 4mb as its part of a dashboard. Can i send it to your email?

You can send to email.
But could you not just save sheet12 to a new workbook? Code and stuff in/on the worksheet should also copy.

I had a day off in July, which was nice. A trip to Natural History Museum and a wonder around westend shops.

i'll send the workbook as a whole becase when i use the code in a new workbook it works fine!! i'll send it over now.

This revision will fix the problem.

Please Login or Register  to view this content.

Looks like the activex command button is included in the Pictures collection. But when you try to reference it fails as it's not a Picture object

Hey Andy - i'll give this a shot now and report back. How did you find out that the activex cmd button is included in the pics?

Cheers

I added some Debug.Print statements to the code in order to tell me name and numbers of items in collection.

Doing that also allowed me to tell that you have multiple pictures with the same name, which may cause confusion later if the incorrect picture appears for the correct name provided.

Many thanks Andy you have been a super help. I Excel were an Olympic sport, you'd be on that podium.