Posts by jhenderson

Re: Custom Cell Formating - Macro or Automated

Format cells then choose special then select the phone number selection

Re: Calculation with number and text in cell

Hi
You need to get the text striped from the cell
go "data" select "text to column" the rest is simple

Re: New MS Excel MVP

Hi Wigi,
Better late than never. Congrats:yourock:

Re: OzGrid crosses 100,000 users

Happy 100,000 from an old fart that has been hanging around since 2003:exclamat:
:thumbcoo::drink:

Re: iPad half Price

LOL

Re: Populate Userform From A Listbox

have you checked the possible answers on the bottom

Re: If cell color = blue (e.g.) then insert value of '1'

Hi
I would look at using conditional formatting

To my mature friends

Two elderly women were eating breakfast in a restaurant one morning. Ethel noticed something funny about Mabel's ear and she said, ''Mabel, do you know you've got a suppository in your left ear?'

Mabel answered, 'I have a suppository in my ear?' She pulled it out and stared at it.
Then she said, 'Ethel, I'm glad you saw this thing. Now I think I know where to find my hearing aid.'
[FONT=&quot] [/FONT]





When the husband finally died his wife put the usual death notice in the paper, but added that he died of gonorrhea.

No sooner were the papers delivered when a friend of the family phoned and complained bitterly, 'You know very well that he died of diarrhea, not gonorrhea.'

Replied the widow, 'I nursed him night and day so of course I know he died of diarrhea, but I thought it would be better for posterity to remember him as a great lover rather than the big **** he always was.'
[FONT=&quot] [/FONT]





An elderly couple were on a cruise and it was really stormy. They were standing on the back of the boat watching the storm, when a wave came up and washed the old man overboard. They searched for days and couldn't find him, so the captain sent the old woman back to shore with the promise that he would notify her as soon as they found something.

Three weeks went by and finally the old woman got a fax from the boat. It read: 'Ma'am, sorry to inform you, we found your husband dead at the bottom of the ocean. We hauled him up to the deck and attached to his butt was an oyster and in it was a pearl worth $50,000. Please advise.'

The old woman faxed back: 'Send me the pearl and re-bait the trap.'
[FONT=&quot] [/FONT]





A funeral service is being held for a woman who has just passed away. At the end of the service, the pallbearers are carrying the casket out when they accidentally bump into a wall, jarring the casket. They hear a faint moan. They open the casket and find that the woman is actually alive!

She lives for ten more years, and then dies. Once again, a ceremony is held, and at the end of it, the pallbearers are again carrying out the casket. As they carry the casket towards the door, the husband cries out, 'Watch that wall!'
[FONT=&quot] [/FONT]





When I went to lunch today, I noticed an old man sitting on a park bench sobbing his eyes out. I stopped and asked him what was wrong.

He said, 'I have a 22 year old wife at home. She makes love to me every morning and then gets up and makes me pancakes, sausage, fresh fruit and freshly ground coffee.'

I said, 'Well, then why are you crying?'

He said, 'She makes me homemade soup for lunch and my favorite brownies and then makes love to me for half the afternoon...

I said, 'Well, why are you crying?'

He said, 'For dinner she makes me a gourmet meal with wine and my favorite dessert and then makes love to me until 2:00 a.m.'

I said, 'Well, why in the world would you be crying?'

He said, 'I can't remember where I live!'
[FONT=&quot] [/FONT]





Two elderly ladies had been friends for many decades. Over the years they had shared all kinds of activities and adventures. Lately, their activities had been limited to meeting a few times a week to play cards.

One day they were playing cards when one looked at the other and said, 'Now don't get mad at me....I know we've been friends for a long time.....but I just can't think of your name! I've thought and thought, but I can't remember it. Please tell me what your name is.'

Her friend glared at her. For at least three minutes she just stared and glared at her. Finally she said, 'How soon do you need to know?'
[FONT=&quot] [/FONT]





THE SENILITY PRAYER
Grant me the senility to forget the people I never liked anyway, the good fortune to run into the ones I do, and the eyesight to tell the difference.
[FONT=&quot] [/FONT]

The Smiths were unable to conceive children and decided to use a surrogate father to start their family. On the day the surrogate father was to arrive, Mr. Smith kissed his wife goodbye and said, "Well, I'm off now. The man should be here soon."
Half an hour later, just by chance, a door-to-door baby photographer happened to ring the doorbell, hoping to make a sale. "Good morning,Ma'am", he said, "I've come to..."
"Oh, no need to explain," Mrs Smith cut in, embarrassed, "I've been expecting you."
"Have you really?" said the photographer. "Well, that's good. Did you know babies are my speciality?"
"Well that's what my husband and I had hoped. Please come in and have a seat".
After a moment she asked, blushing, "Well, where do we start?"
"Leave everything to me. I usually try two in the bathtub, one on the couch, and perhaps a couple on the bed. And sometimes the living room floor is fun. You can really spread out there."
"Bathtub, living room floor? No wonder it didn't work out for Harry and me!"
"Well, Ma'am, none of us can guarantee a good one every time. But if we try several different positions and I shoot from six or seven angles, I'm sure you'll be pleased with the results."
"My, that is a lot!", gasped Mrs Smith.
"Ma'am, in my line of work a man has to take his time. I'd love to be In and out in five minutes, but I'm sure you'd be disappointed with that."
"Don't I know it," said Mrs Smith quietly.
The photographer opened his briefcase and pulled out a portfolio of his baby pictures. "This was done on the top of a bus," he said.
"Oh, my God!" Mrs Smith exclaimed, grasping at her throat.
"And these twins turned out exceptionally well - when you consider their mother was so difficult to work with."
"She was difficult?" asked Mrs Smith.
"Yes, I'm afraid so. I finally had to take her to the park to get the job done right. People were crowding around four and five deep to get a good look"
"Four and five deep?" said Mrs Smith, her eyes wide with amazement.
"Yes", the photographer replied. "And for more than three hours, too. The mother was constantly squealing and yelling - I could hardly concentrate, and when darkness approached I had to rush my shots. Finally, when the squirrels began nibbling on my equipment, I just had to pack it all in."
Mrs Smith leaned forward. "Do you mean they actually chewed on your, uh...equipment?"
"It's true, Ma'am, yes... Well, if you're ready, I'll set-up my tripod and we can get to work right away."
"Tripod?"
"Oh yes, Ma'am. I need to use a tripod to rest my Canon on. It's much too big to be held in the hand very long."
Then Mrs Smith fainted.

[FONT=&quot]:smile:[/FONT][FONT=&quot] [/FONT]
If you don't laugh at this one, you're not breathing. [FONT=&quot] [/FONT]
A firefighter was working on the engine outside the Station, when he noticed a little girl nearby in a little red wagon with little ladders hung off the sides and a garden hose tightly coiled in the middle.[FONT=&quot] [/FONT]
The girl was wearing a firefighter's helmet. The wagon was being pulled by her dog and her cat. The firefighter walked over to take a closer look. 'That sure is a nice fire truck,' the firefighter said with admiration.[FONT=&quot] [/FONT]
"Thanks," the girl replied. The firefighter looked a little closer. The girl had tied the wagon to her dog's collar and to the cat's testicles.[FONT=&quot] [/FONT]
"Little partner," the firefighter said, 'I don't want to tell you how to run your rig, but if you were to tie that rope around the cat's collar, I think you could go faster.”
The little girl replied thoughtfully, “You're probably right, but then I wouldn't have a siren."

Re: Hide All Worksheets Except One

OLA
Please let us know how you solved your problem, there could be others with the same problem
thank you

Re: vlookup or another way?

http://www.ozgrid.com/forum/showthread.php?t=105331
goto this thread it is a video on formating

Re: vlookup or another way?

Try conditional formatting

ADDED BY ADMIN
Lookup Table

An elderly man in Louisiana had owned a large farm for several years.

He had a large pond in the back. It was properly shaped for swimming, so he fixed it up nice picnic tables, horseshoe courts, and some apple and peach trees.

One evening the old farmer decided to go down to the pond, as he hadn't been there for a while, and looks it over. He grabbed a five-gallon bucket to bring back some fruit.

As he neared the pond, he heard voices shouting and laughing with glee..

As he came closer, he saw it was a bunch of young women skinny-dipping in his pond.

He made the women aware of his presence and they all went to the deep end.

One of the women shouted to him, 'We're not coming out until you leave!

The old man frowned, 'I didn't come down here to watch you ladies swim naked or make you get out of the pond naked.'

Holding the bucket up he said, 'I'm here to feed the alligator.'

Some old men can still think fast.

A Texan farmer goes to Australia for a vacation. There he meets an Aussie farmer and gets talking. The Aussie shows off his big wheat field and the Texan says, "Oh! We have wheat fields that are at least twice as large".

Then they walk around the ranch a little, and the Aussie shows off his herd of cattle. The Texan immediately says, " We have longhorns that are at least twice as large as your cows".

The conversation has, meanwhile, almost died when the Texan sees a herd of kangaroos hopping through the field. He asked, "And what are those"?

The Aussie replies with an incredulous look, "Don't you have any grasshoppers in Texas"?

New Mexico Chili Cookoff
If you can read this whole story without laughing, then there's no hope for you. I was crying by the end. This is an actual account as relayed to paramedics at a chili cook-off in New Mexico .

Note: Please take time to read this slowly.
If you pay attention to the first two judges,
the reaction of the third judge is even better.

For those of you who have lived in New Mexico , you know how true this is. They actually have a Chili Cook-off about the time Halloween comes around. It takes up a major portion of a parking lot at the Santa Fe Plaza . Judge #3 was an inexperienced Chile taster named Frank, who was visiting from Springfield , IL .

Frank: “Recently, I was honored to be selected as a judge at a chili cook-off.. The original person called in sick at the last moment and I happened to be standing there at the judge's table, asking for directions to the Coors Light truck, when the call came in. I was assured by the other two judges (Native New Mexicans) that the chili wouldn't be all that spicy; and, besides, they told me I could have free beer during the tasting, so I accepted and became Judge #3.”

Here are the scorecard notes from the event:
CHILI # 1 - MIKE'S MANIAC MONSTER CHILI
Judge # 1 -- A little too heavy on the tomato. Amusing kick.
Judge # 2 -- Nice, smooth tomato flavor. Very mild.
Judge # 3 (Frank) -- Holy crap, what the hell is this stuff? You could remove dried paint from your driveway. Took me two beers to put the flames out. I hope that's the worst one. These New Mexicans are crazy.

CHILI # 2 - EL RANCHO'S AFTERBURNER CHILI
Judge # 1 -- Smoky, with a hint of pork. Slight jalapeno tang.
Judge # 2 -- Exciting BBQ flavor, needs more peppers to be taken seriously.
Judge # 3 -- Keep this out of the reach of children. I'm not sure what I'm supposed to taste besides pain. I had to wave off two people who wanted to give me the Heimlich maneuver. They had to rush in more beer when they saw the look on my face.

CHILI # 3 - ALFREDO'S FAMOUS BURN DOWN THE BARN CHILI
Judge # 1 -- Excellent firehouse chili. Great kick.
Judge # 2 -- A bit salty, good use of peppers.
Judge # 3 -- Call the EPA. I've located a uranium spill. My nose feels like I have been snorting Drano. Everyone knows the routine by now. Get me more beer before I ignite. Barmaid pounded me on the back, now my backbone is in the front part of my chest. I'm getting sh*t-faced from all of the beer.

CHILI # 4 - 2 0- BUBBA'S BLACK MAGIC
Judge # 1 -- Black bean chili with almost no spice. Disappointing.
Judge # 2 -- Hint of lime in the black beans. Good side dish for fish or other mild foods, not much of a chili.
Judge # 3 -- I felt something scraping across my tongue, but was unable to taste it. Is it possible to burn out taste buds? Sally, the beer maid, was standing behind me with fresh refills. This 300 lb. Woman is starting to look HOT ... Just like this nuclear waste I'm eating! Is chili an aphrodisiac?

CHILI # 5 - LISA'S LEGAL LIP REMOVER
Judge # 1 -- Meaty, strong chili. Jalapeno peppers freshly ground, adding considerable kick. Very impressive.
Judge # 2 -- Chili using shredded beef, could use more tomato. Must admit the jalapeno peppers make a strong statement.
Judge # 3 -- My ears are ringing, sweat is pouring off my forehead and I can no longer focus my eyes. I farted, and four people behind me needed paramedics. The contestant seemed offended when I told her that her chili had given me brain damage. Sally saved my tongue from bleeding by pouring beer directly on it from the pitcher. I wonder if I'm burning my lips off. It really ticks me off that the other judges asked me to stop screaming. Screw them.

CHILI # 6 - VARGA'S VERY VEGETARIAN VARIETY
Judge # 1 -- Thin yet bold vegetarian variety chili. Good balance of spices and peppers.
Judge # 2 -- The best yet. Aggressive use of peppers, onions, garlic. Superb.
Judge # 3 -- My intestines are now a straight pipe filled with gaseous, sulfuric flames. I crapped on myself when I farted, and I'm worried it will eat through the chair. No one seems inclined to stand behind me except that Sally. Can't feel my lips anymore. I need to wipe my butt with a snow cone.

CHILI # 7 - SUSAN'S SCREAMING SENSATION CHILI
Judge # 1 -- A mediocre chili with too much reliance on canned peppers.
Judge # 2 -- Ho hum, tastes as if the chef literally threw in a can of chili peppers at the last moment. **I should take note that I am worried about Judge #3. He appears to be in a bit of distress as he is cursing uncontrollably.
Judge # 3 -- You could put a grenade in my mouth, pull the pin, and I wouldn't feel a thing. I've lost sight in one eye, and the world sounds like it is made of rushing water. My shirt is covered with chili, which slid unnoticed out of my mouth. My pants are full of lava to match my shirt. At least during the autopsy, they'll know what killed me. I've decided to stop breathing. It's too painful. Screw it; I'm not getting any oxygen anyway. If I need air, I'll just suck it in through the 4-inch hole in my stomach.

CHILI # 8 - BIG TOM'S TOENAIL CURLING CHILI
Judge # 1 -- The perfect ending, this is a nice blend chili. Not too bold but spicy enough to declare its existence.
Judge # 2 -- This final entry is a good, balanced chili. Neither mild nor hot. Sorry to see that most of it was lost when Judge #3 farted, passed out, fell over and pulled the chili pot down on top of himself. Not sure if he's going to make it. Poor fella, wonder how he'd have reacted to really hot chili?
Judge # 3 -- No report.

A midget in Texas went to the doctor because his testicles ached
almost all of the time. The doctor told him to stand on the examining
table and drop his pants. The doc put one finger under the midget's
left testicle and told him to turn his head and cough - the usual
method to check for a hernia.

"Hmmm..", mumbled the doc as he put his finger under the right
testicle, he asked the midget to cough again, "Hmmm, I see the
problem," said the doctor and reached for his surgical scissors.
Snip, snip, snip, snip, snip, snip, snip on the right side, then snip,
snip, snip, snip, snip, snip, snip, on the left side. The midget was
so scared he was afraid to look, but noted with amazement that
the snipping did not hurt.

The doctor then told the midget to hop down off the table,
pull his pants up, and then walk around and see if his testicles
still ached. The midget was absolutely delighted as he walked
around the doc's office and discovered his testicles were no longer
aching.
The midget said, "That's perfect Doc, and I didn't even feel it! What
did you do?"

The Doctor replied, "I cut two inches off the top of your cowboy boots."=

Loving on the Lawn
A man was walking one day, when he came to this big house in a nice neighbourhood.

Suddenly he realised there was a couple making love out on the lawn. Then he noticed another couple over behind a tree. Then another couple behind some bushes by the house.

He walked up to the door of the house, and knocked. A well dressed woman answered the door, and the man asked what kind of a place this was.

"This is a brothel", replied the madam.

"Well, what's all this out on the lawn?" queried the man.

"Oh, we're having a yard sale today."

A guy came into a bar one day and said to the bartender, “Give me six double vodka.”
The barman says, “Wow! you must have had very bad day.”
“Yes, I’ve just found out my older brother is gay.”

The next day the same guy came into the bar and asked for the same drinks.
When the bartender asked what the problem was today the answer came back, “I’ve just found out that my younger brother is gay too!”

On the third day the guy came into the bar and ordered another six double vodkas.
The bartender said, “What the hell? Doesn’t anybody in your family like women?”

“Yes, my wife…”

After being interviewed by the school administration, the eager teaching prospect said, "Let me see if I've got this right."

[/align]percent of my attention.
* My contract requires me to work on my own time after school, evenings and weekends grading papers.
* Also, I must spend my summer vacation, at my own expense, working toward advance certification and a Masters degree.
* And on my own time you want me to attend committee and faculty meetings, PTA meetings, and participate in staff development training.
* I am to be a paragon of virtue, larger than life, such that my very presence will awe my students into being obedient and respectful of authority.
* You want me to incorporate technology into the learning experience, monitor web sites, and relate personally with each student. That includes deciding who might be potentially dangerous and/or liable to commit a crime in school.
* I am to make sure all students pass the mandatory state exams, even those who don\'t come to school regularly or complete any of their assignments.
* Plus, I am to make sure that all of the students with handicaps get an
equal education regardless of the extent of their mental or physical
handicap.
* And I am to communicate regularly with the parents by letter, telephone, newsletter and report card.
* All of this I am to do with just a piece of chalk, a computer, a few
books, a bulletin board, a big smile AND on a starting salary that qualifies my family for food stamps!
You want me to do all of this and yet you expect me... NOT TO PRAY!!

--------------------------------------------------------------------------------