Macro gives Run-time error '13': Type mismatch, but nothing has changed?

**BlondOIverBlue** · 11-09-2010, 11:12 PM

I have a macro that I use to run an End of Day (EOD) Report. I have been using it for weeks now without a problem, but tonight it seems to bind up when I run it, giving me the error:

Run-time error '13': Type mismatch

I click debug to look at the code, but I have no idea what it's referring to since, well, nothing has changed either in the macro or reporting data output (as far as I know).

Attached is tonight's report in raw format (pre-macro run) with the macro enabled so the error can be duplicated. It's killing me not knowing what's wrong and I am hoping the problem is not between the chair and keyboard.

Any help is appreciated.

**jaslake** · 11-10-2010, 12:06 AM

Hi BlondOIverBlue

Your macro balks at this line of code

Please Login or Register  to view this content.

Some of your "Start Times" in column L are blank. It appears that this may be causing your issue.

John

**BlondOIverBlue** · 11-10-2010, 12:34 AM

Originally Posted by jaslake

Hi BlondOIverBlue

Some of your "Start Times" in column L are blank. It appears that this may be causing your issue.

John

Ok, that makes sense, but that never stopped the macro before which is why I was being thrown for a loop. Since it doesn't like blank "Start Time" fields, how do I get it to ignore blank start time fields?

Currently it takes 07:00 into account as the default start time for everyone and should be calculating "total hours" using that plus the highest "end time". Then it subtracts 0.50 hours to account for a meal break.

I'm not a programmer and am still learning coding (via this macro other helped me write) so I apologize if I'm asking too many questions.

**jaslake** · 11-10-2010, 03:08 PM

Hi BlondOIverBlue

If you wish to

how do I get it to ignore blank start time fields?

Change your code as follows

Please Login or Register  to view this content.

I've indicated which lines (3) of code need to be added. The code will now ignore blank start times.

Hope this helps.

John

**BlondOIverBlue** · 11-10-2010, 11:45 PM

Originally Posted by jaslake

Change your code as follows

Please Login or Register  to view this content.

I've indicated which lines (3) of code need to be added. The code will now ignore blank start times.

Brilliant! Those 3 little lines worked! Thank you so much!

**jaslake** · 11-10-2010, 11:52 PM

Hi BlondOIverBlue

You're welcome. If your issue is resolved, please mark it as such.

To mark your thread solved do the following:
- Go to your first post on the thread
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

A click on the scales is always appreciated.

John