Recent content by sedgely

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