'Run-time error '13', 'Type mismatch' in Range value

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi this is now changed as per your request

OK for code but also your post title should accurately and concisely describe your problem.

I wasn't sure what to put in the title is it ok now or does it need more info

Originally Posted by jak68

I wasn't sure what to put in the title

Try think this way: If you want to google for solution what you would search for to find solution for your problem.
Searching VBA error won't bring you closer.

I'll fix it now for you to give you a clue so everyone can continue answering your question.

Thanks

I think it should work.

Are you referencing to a good sheet?
This will work only in active sheet.

I am updating the sheet all the time at the minute with various bits of information, as I said the emailing function is working but then the error comes up when I run the code.

I can attach the whole spreadsheet if it makes it easier to figure out? Thanks

Hmmm.. Sounds like you need to wait somewhere for some time...
Can't say more without example workbook but you can try to test for your own:

This will for example wait for 3 seconds.

Please Login or Register  to view this content.

Hi is this to be put in at the start of the existing code or is it a separate code?

I can attach the workbook if this does not work if it is easier...Thks

I show you above, I've put it between your code.

Attaching workbook is always good idea.
Make sure to remove all private informations and keep only what's important for your case.

Hi, thanks for the reply

The new coding made no difference so I tried to attach my workbook (which is work in progress) but it only opens a small box as below

Any help is greatly appreciated

Capture.JPG

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

That's what I did and I only got the small box in the screenshot

I managed to attach the screenshot ok but not a file attachment...strange

I even tried it on a different type of computer

I will try to attach the file tonight from home as there might be something blocking the attachment from opening while I am in work (even though it worked attaching the screenshot)

Yea.
If not attach on some hosting and provide a link for download.

Thanks for your help, out of curiosity what websites have you seen people hosting files from to be able to use the link option?

Not many. Everyone upload in the Forum and that's the way we prefere

Tried to attach the workbook last night and I had the same problem at home, it just comes up with the same small box. I tried using explorer, chrome and firefox..So I am stumped now

I'll see if I can find a website that I can host the workbook so I can use a link instead of trying to upload

jak68

Please Login or Register  to view this content.

Most probably, you have Error value in Range("O" & x)?

I really don't know.
When I click paperclip I got this window to upload attachment.
EF.png

Yeah... I found an error in some data I had hidden. I modified this and everything seems to be ok now.

Next I will be trying to figure out how to get the macro to run automatically when I open the workbook

Thanks for everyones help

I've assumed that you will see error in a first place