macro error Copy Time format to other Worksheet and continues copy range

Hi everyone!!

Good Day!!

I have a issue with the next macro:

Please Login or Register  to view this content.

Thanks again for everyting!

Best Regards!

Master Time Tracking Low Voltage_test.xlsm Help!!

This is the file..

Thanks again!

Why is 00/01/1900 08:30:00 a.m and error?

If that's supposed to be 08:30 then it's just not formatted properly.

Perhaps you could fix that in your GetData function/sub.

Is the 2nd problem that the formula is copied down to the last row in the worksheet?

If it is try going up instead of down.

Please Login or Register  to view this content.

The code in your workbook is password protected.

ahh sorry!!.. the password is "tm22064900"

Sorry!!!

Have you tried adding some code to format the data after you've got it?

I've no data to test with so I don't know what that code would be but it would be pretty straightforward.

You really think Norie.. it's that simple?

Each day I learn more of you ..
But there are some things I don't understand, but thanks for your help!

Well, I've not actually seen what exactly needs to be done so perhaps I'm being a bit optimistic.

Hopefully I'll see what's going on now you've uploaded the data file.

Give this a try.

Please Login or Register  to view this content.