Recent content by AngelB

I've printed it and had a very brief look at it. It's a very clever puzzle and I'm looking forward to sitting down with it and thrashing it out properly. I'm a bit of a fan of snakes so I'm hoping that will help me out a bit too Geraint The lights are on but nobody's home, my elevator doesn't...

My dinner today is curry and curly fries I'm going to stink Geraint The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

That's great. Thanks for the help CC. Geraint The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

Hi All I work in road safety for a local council and I need to respond to an email received earlier today from a member of the public regarding the speed of vehicles passing through his village. My email contains the sentence: Is 'thereto' the correct word with which to end this sentence? Or...

There was a van parked at the end of my street on the weekend with the licence plate: B19 PMS I'm guessing that one week a month it would be a good idea to stay out of this van's way... Geraint The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a...

Just read your piece Maria and was really impressed. I always love it when a short story makes you wish you knew more about its characters and the world of its setting. I'm going to have to go back and read your other work now Geraint The lights are on but nobody's home, my elevator doesn't go...

Hello All The IT department at work has asked that we all try and cut down the size of our inboxes in outlook 2003. I would like to archive some of my folders to a network drive, but if I select any more than one email at a time and then 'Save As' from the file menu, the only 'Save as type'...

Opieo - I know there's a rapper called Lil Mama. Maybe that's what it was referring to. Geraint The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

Thank you both for your replies. It would appear that I have embarrassed myself, since the pasting was occurring correctly and I was overwriting it later on in the code by incorrectly referencing the cell again and pasting the contents of a blank cell into it. (Pasting C2 into B2 when I meant...

Hi All I need to copy some data from one sheet to another using vba. Two of the fields I need to copy are in date format (dd/mm/yyyy). I am using the following syntax to paste them into another workbook: Range("H2").Copy Destination:=Workbooks("GroupStats.xls").Sheets("Sheet1").Range("B" & j)...

Maybe they just omitted the decimal place after the 5 [smile] Geraint The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

There were (maybe still are) some mint chocolates sold in the UK with the name 'Mingles'. Their tag-line in the advert was 'You just can't eat a single mingle', making it sound like they were so bad you couldn't even eat one of them. Geraint The lights are on but nobody's home, my elevator...

Not too far from my house is a mercedes convertible that has the delightful vanity plate of LISA BJ. Always makes me wonder - are those her initials or is it a form of advertising? [smile] Geraint The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a...

Hi All I am using Excel 2003 (SP2). If a particular cell in my worksheet is blank, then the entire row will be blank and I wish to delete it. I found the following line of code posted by anotherhiggins in a separate thread: which would quite rightly delete the entire row where a blank cell...

Thanks Geoff, that's exactly what I need. I knew of the existence of named ranges but had never had cause to use one til now. Thanks for providing me with the perfect excuse to learn about them. Star for you sir! Geraint The lights are on but nobody's home, my elevator doesn't go to the top...