worksheetfunction.text() and font colour

**NDBC** · 09-04-2009, 11:35 PM

The following code does everything I need it to except for some reason it is not sending the font colour through first or the font colour is getting overwritten. I have formula in other worksheets that are counting the red and the blue to determine which rider in a team it is. For some reason the time sent to "B Grade" worksheet is ending up in black font. Can anyone explain to me why this is occuring.

I am using worksheet function.text because I am working with elapsed times that could be over 24hrs. I was wondering if the default text colour for the worksheet.text() function is black and if it could be changed.

Thanks

Please Login or Register  to view this content.

**NDBC** · 09-05-2009, 12:36 AM

Deleted second post because it was wrong.

**Leith Ross** · 09-05-2009, 01:12 AM

Hello NDBC,

Is this by chance related to your post here?

If so, you need to include a link to this post. Others will then know what progress has been here and elsewhere. It will avoid duplication of effort and wasting the time of the those helping you.

**NDBC** · 09-05-2009, 01:19 AM

Lieth,

Yes it is exactly the same post, but in a different forum. The race is on tomorrow so I need to maximise my chances of getting this done. As I did last time I posted I will either put up the results in both forums or at the very least say I solved it and post the link.

Anyway I was just coming back to appologise for wasting your time. The error was only happenning at what seemed like random times which was very confusing. I have now tracked it down to worksheets being protected and the code not unprotecting it until part the way through the process.

Thanks for looking though.

**Leith Ross** · 09-05-2009, 01:25 AM

Hello NDBC,

Good job on figuring that out. By the way, you weren't wasting my time. Microsoft.Excel.Public doesn't care about cross posting, but most other sites appreciate a heads up so everyone is on the same page. I'll marked this solved for you.