runtime error 13 mismatch

I have an emailing script that is getting this runtime error 13 type mismatch. It creates an email and find the contact and the email address(es) based on the below. Not sure why it is suddenly throwing me these errors in the contact column. I tried to select the cells and change the option to...

Hi there, Can somebody please help me refine my code so that when I delete cells in column C and D at the same time that I will not produce a run-time error 13 mismatch. Just because I have six other people using this sub and they have zero knowledge or VBA or resetting a sub. For context the...

Hi! I would like to attach different types of file to my emails. This code worked well and sent emails untill I placed the attachment adding. .Attachments.Add "D:\8" & Range("S12").Value After that it was stucked on runtime error 13 type mismatch. Can anybody help me with this...

Hi! I would like to attach different types of file to my emails. This code worked well untill I placed the attachment adding. .Attachments.Add "D:\8" & Range("S12").Value After that it was stucked on runtime error 13 type mismatch. Can anybody help me with this? Sub Send_Mail2() ' '...

Hello all, First time posting, I'm having trouble with a simple VBA sub I've been working on. The idea is that the code drops a timestamp into a specific cell when the Plan-Do-Check-Accept (PDCA) status of that row changes. Sub Worksheet_Change(ByVal Target As Range) Dim D As Range: Set D =...

Hi everyone, Please can someone help me with the following, apologies if this is quite basic. I've not done any VBA for a long time and I'm out of practice. In my Excel workbook I have a number of buttons to take you to different sheets in the model, I'm trying to write code that can be...

Hi all, I've been using the below code to automatically enter today's date in column b when entering anything into column a - which has been working perfectly. Private Sub Worksheet_Change(ByVal Target As Range) ' If you update a cell in column A with a value and there is no date in the...

Hello, This post is a follow-up to an earlier thread http://www.mrexcel.com/forum/excel-questions/916067-need-macro-calculate-week-ending-date-override-cell.html#post4404190. The working code below essentially overrides a user's data to input the correct week-ending date (Column H) and...

Good Afternoon, I have created a set of code which works in Excel 2010 and 2007 to do the following: 1.) User fills in form as per questions. 2.) User is asked if they have completed other requirements. 3.) Form unlocks checkbox options so user can continue with form. I am now seeing issues...

Hi there! Until yesterday I had a perfectly fine working date macro on my calendar sheet allowing me to go to "today's date". However, now I am getting a "Runtime Error 13-Mismatch": The code is as follows: Sub GotoDate() Dim LastCell As Long, x As Long LastCell =...