I just read a post where I guy wanted a function to replace a certain string
of characters with another one. Then he responded saying he used the
"replace" function. "Duh" he said. He knew the obvious, just not at that
moment. It's possible the OP could have had a similar brain fart, and just
needed a reminder.

It sounded too me like a perfect scenario for Set Print Area. Usually when
people want options other than the obvious they say "I don't want to Set
Print Area" or "I don't want to Sort" or "I don't want to use the ROUND
function" etc.

Also, the OP could have been really new to Excel and not even known about
Set Print Area. I used excel all through High School and College without
ever knowing you could set the print area.

Sometimes people like doing things the easiest, or most direct way. There
are a million reasons why my post was appropriate.

My post might not have been helpful to the OP, but it didn't hurt anything.
Your posts however are harmful (not as in my feelings are hurt). This forum
is good because of the community. You start posting stuff like that, and
this forum turns into a trolling forum. People will be afraid to post
anything, questions or answers. I honestly would like 7 wrong answers to one
of my questions, than no answers at all. People can still benefit from wrong
answers and obvious answers.

By the way your solution was very good. It works perfectly. I couldn't
find anything in the help though. The only thing I could find was naming
cells or ranges of cells. Do you have any suggestions where to look in the
help, or any links on the subject?

"Harlan Grove" wrote:

Sloth wrote...
Wow, settle down guys. I meant no offence, and was just offering a
suggestion. I didn't know if you even considered that an option.
....

No, no one would have considered the obvious before you mentioned it.
You have everyone's deepest gratitude for mentioning it.