Replies

As an alternative, you could just have two charts – one for each year – of the same size and scale etc. The second chart has plot area fill, chart area fill, axis and gridlines removed and is over laid on the first giving the appearance of one chart as attached.

cheers
Andrew

Finally a puzzle I know…

a Cigars of the Pharaoh
b Flight 714
c Seven Crystal Balls
d Prisoners of the Sun
e Shooting Star
f Calculas Affair
g Blue Lotus
h Black Island
I Secret of the Unicorn
j Land of Black Gold
k Explorers of the moon
l Red Sea Sharks
m Crab with the Golden Claws

Destination Moon
Tintin in Tibet
Tintin in the Land of the Soviets
Tintin in America
Tintin and the Alpha Art (incomplete at Herge’s death)
Tintin in the Congo
The Broken ear
The Blue Lotus
The Scepter of Ottokar
Red Rackrams Treasure
Temple of the Sun
The Castafiore Emerald
Tintin and the Picaros

ahh the memories, by far and away the best books from my childhood. So much so I still have them, although some are a bit tatty from repetitive use.

cheers
Andrew

Afternoon Andrew,
I would quite like to try out GMail if you still have an invite. Can whatever I need be sent via private message or do you need an email?

many thanks

Morning Rob,
Your second clue narrowed my remaining possibles from 50+ to less than 10, so that made the trial and error not quite so daunting ….

2 1 3 5 6 4 7
6 26 5 35 3 37 1
1 2 6 3 4 7 5
4 31 2 36 7 39 6
3 6 7 2 5 1 4
5 38 4 26 1 24 2
7 5 1 4 2 6 3

cheers
Andrew

Thank you Sam for your refined code. It is working a treat.
An Interesting aside, if the ‘Where’ & ‘What’ is in another workbook it returns #value! unless the source workbook is open. Jim Cone’s code is the same. I vaguely remember something about this in relation to user defined functions from somewhere.
Anyway thanks again for the help, Jim and Jan also.

Thanks Jim,
Your code produces the correct result. I will tweak it to return the value in the cell instead of a msg box and set a variable for the range to look in and I should be cooking with gas.

VLookup wasn’t an option as it will only search in the leftmost column of the array and the name is not always in that column.

Thanks

Thanks for your time Sam,
The function is still returning #value! error, but it has given me another angle from which to think about the problem.

thanks

Hi Phil,
I had duplicated these settings from another machine. However no files would open at all when I did.
I solved the problem in the end over the w/e by doing a repair/re-install of Office. Could have done that in the first place I suppose but wanted to try and find out a bit about what was controlling it.

Tim,
I am using R5.0.6a nad have noticed that the rules do not seem to run consistantly. I have a number set up filing mail into different folders according to keywords in the subject line.
A couple of the rules work spot on every time, others don’t work at all. The only consistancy I have have picked up on so far is that if the subject line is short the filter seems to kick in just fine, whereas if it is a long sentence containing the keyword it dosn’t seem to work.

The simple questions are often the most important. I know of many cases where technicians assuming that the obvious have been checked have spent hours on some problem to discover that a cable is unplugged, program not installed or other such cause

I have finally managed to get back to this one. After much harrasing of the IT dept I finally sussed the problem lies within the security settings of Office 2000 (service pack 2 again). IT have managed to get some of their own forms working so I now have then trying to tweak mine to work. Will let you know if a definate cause/solution is found.

I also have a home lan which was promopting for a password at start up, when I had never established a password. I stopped this prompt by changing the setting in Control Panel/Passwords to “all users use the same password”. End of prompt.

Fyredillo
Another option is once in the Windows folder, take the tick off ‘as Web Page’ under the Veiw menu.

I don’t know of any way to keep the inital connection box open, however once connected, if you right click the connection icon in the system tray and then select status (IE on Win98) then you will have a dialog box which although can’t actually be minimized, it can be sent behind your browser window with quick access either through the task bar or Alt+Tab. Bear in mind that the speed shown is on the rate at which you initally connected at, its not a real time meter updating as you surf. You will need specific applications for that.

A good site to check out if you are interested in learning more about your vunerability while on the web is grc.com. The host Steve Gibson supplies information on protecting your system as well as a number of *free* downloads to test your firewall as well as check your system for previous breachces. Well worth a visit.