Search:

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...

Finally a puzzle I know...

<span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold"> a Cigars of the Pharaoh
b Flight 714
c Seven Crystal Balls
d Prisoners of the Sun
e...

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 ....

<span style="background-color: #FFFF00;...

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...

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...

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

I have a worksheet where I want to hunt out a persons name in a range of cells, then return a value from another range in the corresponding row the persons name is in.

I have an array formula that...

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....

When opening a file via windows explorer when the application is already running, how do you back the file open in the running app instead of opening another instance of the app?
The situation has...

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...

Your probably right. Still, doesn't stop my pre-schooler giggling each time she sees the dog miss the back of the ute <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

DocWatson is right about cultural context. Here in NZ, that word is not considered that extreme a profanity. It has even recently been used as the entire script of a motor vehicle television...

The simple questions are often the most important. <img src=/S/doh.gif border=0 alt=doh width=15 height=15> I know of many cases where technicians assuming that the obvious have been checked have...

Excellent, thats going to help those of us on dial ups...

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...

We have an Outlook form that once completed as well as sending the email message inserts certain data from feilds in the form into an excel workbook.
The form was written while we were on a NT4...

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...

A workmate is having problems sending PowerPoint files to his home system.

The email is getting there alright but when he tries to open the attachment from within the email he gets the message
...

I helping my wifes kindergarten set up a couple of computers, one in the office and the othr in the centre for the kids to use.
Can I set up a profile on the kids computer, that when they log on as...

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...

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...

I too have had this occur in the past. I went through everything, checking schedulers, live updates etc. Did through scan for trojans and such like that might be trying to send info out. Ran...

I too have installed ZoneAlarm and found that it is all good. Not only does it protect against intrusions from the outsid it allows you to control what applications send data out. A highly...