Macro formats cells in some sheets, but doesn't format in some others... why?

Hello all, thanks in advance for reading.

I have a macro to process some data, what it does is arrange a large chunk of raw data into separate sheets and dates/times, with proper formatting.

The problem is, it formats "single-digit hour times" (8:00:00 AM, 9:30:10 PM) as General but formats "double-digit hour times" (10:00:00 AM) as Time correctly.

To better understand this, please set a break point at line 59 and run the macro. The formatting section is from line 49-55. I'm using Excel 2007.

How can I prevent the macro from incorrectly formatting cells as General? I need it to be formatted as Time (h:mm:ss)...

Thanks a lot!

You are applying the formatting to the current selection on worksheet "myname" rather than explicitly specifying the range.

thanks for your reply.

i don't understand, how does this affect the formatting? besides, in some sheets where it contains both "single-digit-hours" and "double-digit-hours", it formats 9:00:00AM as General but 10:00:00AM as Time... I modified the source data to display 09:00:00AM but after processing it's still changed back to 9:00:00AM and formatted as General...

appreciate all help!

oh wait i suddenly figured it out! due to my programming of

Please Login or Register  to view this content.

so it pasted " 9:00:00AM" with a [space] at the front... no wonder it didnt format as time.

so i'm guessing this can be fixed by removing the space... will try to search the forum if there's a pre-existing macro for that, but will appreciate all help nonetheless.

edit: found. answer was

Please Login or Register  to view this content.

again, thanks for reading, sorry if you think i was spamming, the answer just came to me.