Search results for query: *

thanks strongm, works a treat. and thanks for the explanation, makes perfect sense now Cheers, Craig Si fractum non sit, noli id reficere

PHV Thanks for the reply, i've tried that and it matches the tabs with no colour but all the coloured tabs are showing as totally different colours e.g. a Red Tab shows as green in the list? Cheers, Craig Si fractum non sit, noli id reficere

I have the following code to list all worksheet names and their corresponding tab colors, it seems to work fine EXCEPT where the tab has no color in which case it shows as black. cna anyone suggest what i am doing wrong? Many Thanks Sub ListWorkSheetNamesAndTabColors() Set wks =...

Thanks Simi That is exactly what I needed Cheers, Craig Si fractum non sit, noli id reficere

i have a query that returns records with a callTime in the last 24 hours. what i am trying to do is determine which of these records has a calltime within the current shift (shift start times are 06:00 and 18:00) so... if the current time is 11:10 all those records with a calltime greater than...

Hi All i have a range of cells in Excel currently C16:F16, i use the following formula to return the value in the last populated cell from that range =LOOKUP(2,1/($C16:$F16<>""),$C16:$F16) this works great, however the range is going to be expanding i.e. each week a new column will be inserted...

WOOHOO! sorted Thanks smah i took your advice and disconnected all other USB devices, including my internal card reader then rebooted and backup found my drive first time. i then reconnected everything and it couldn't find it, however i disconnected the drive (which was plugged into one of the...

smah tried as you suggested but still the same, any other ideas? Cheers, Craig Si fractum non sit, noli id reficere

OK will try that when i get home tonite and post back the result Thanx Cheers, Craig Si fractum non sit, noli id reficere

hi i have recently got a new Vista machine and am trying to use the backup utility with a Maxtor external USB drive however when i select "backup files" in the backup and restore center it gets as far as "Looking for backup devices" and stays there forever. if i unplug the USB drive and try...

Hi Guys Thx for the reponses. Skip, can't believe i didn't spot that, DOH! Cheers, Craig Si fractum non sit, noli id reficere

i have the following that changes the x axis scale based on a value on a worksheet, it works fine until i change With ActiveChart.Axes(xlCategory) .MinimumScale = minScaleValue .MaximumScale = maxScalevalue End With toWith oSPCCht.Axes(xlCategory)...

i have a table with the following fields (among others) id priority name i need to count the number of records for each name grouped by priority, my problem is that where there are several records with the same id number for a particular name/priority i only want the result to return 1. for...

Thanks Guys Dale used your code, worked great after a couple of tweaks. Thanks again. Cheers, Craig Si fractum non sit, noli id reficere

i have an excel sheet with 4 named ranges, "pa", "pb", "pc", "pd". I need to sort these by the 11th then 6th column in each range. Can someone point me in the right direction? Cheers, Craig Si fractum non sit, noli id reficere

Nick tried your suggestion, just get a "#value" error. this is what i've got up to now Public Function totalHours(t1 As String) ' ' Dim tt1 As Double Dim time1 As Double Dim time2 As Double If IsNumeric(Left(t1, 4)) Then time1 = Left(t1, 4) time2 = Right(t1, 4) If time1 <...

Nick on the sheet there is a range of cells with text values in the format 0800-1900,2100-0700 etc also some may have other text in e.g. "rest day" the code i posted converts each part into a time and calculates the difference in hours. This works great for a single cell e.g. "=totalHours(c3)"...

I have the following function thats takes a cell value in the format 0700-1900 and calculates the number of hours elapsed. It works fine but I would like to be able to use a range of cells as the parameter and work through the cells to get the total hours. Can someone point me in the right...

Hi all Don't know if this is possible but here goes... i have a view that returns data like: DATE AREA No1 No2 FINAL 01/04/06 firstArea 20 28 .71 02/04/06 firstArea 15 22 .68 . . . 01/04/06 secondArea 14...

Thanks to you both, it is now sorted. PH you solution did it. Cheers, Craig Si fractum non sit, noli id reficere