Originally Posted by OP
Oh, my ... .
Last edited by shg; 08-31-2010 at 01:19 PM.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Now you know why a macro was wanted - just one button click.
Don't you just love the use of "simple"!!!!
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
*sigh*
I missed the group hug, didn't I?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
We'll have another one next month
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I need a Macro that will give me $1,000,000. Anyone?
Please leave a message after the beep!
I could write that for you....but MAN is that gonna cost you....
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Who is Goto.......and why should I avoid him?
Audere est facere
Kinda defeats the purpose of having a go-to guy ...
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
When computers were first invented, in 1980, there were no programming languages at all, and the only way to make computers do stuff was to drip hot solder onto the motherboards. Two Japanese guys - Goto and Gosub - recognised that this was sub-optimal and, between them, created the very first (and, to date, the best) programming language - BASIC.
To make it run faster BASIC was an interpreted language, so you didn't have to spend ages sitting around waiting for a compiler to run. This is why, to this day, most supercomputers (such as the large hardon colluder) run BASIC as their main programming language, although some also run Pascal (developed by the French mathematician and philosopher, Blaze Pascal).
Unfortunately Goto and Gosub had a big argument about the development of the next version of BASIC. Gosub wanted to return to the original design, whereas Goto was keen on heading off in all kinds of wild directions. The two of them vowed never to work together again. Gosub went on to develop Visual Basic, so called because you could read what you were typing in - unlike early versions of BASIC, where you just had to remember what you'd typed. Goto developed a whole new programming language, based on the core 20% of BASIC, called C, but it was very unsuccessful and, to date, only 3 people in the world have learned how to use it.
So most programmers sided with Gosub and the mere mention of Goto's name is a huge taboo in programming circles.
So there you go, the full story ... at least that's what Wikipedia says.
I met Goto on a night out once. He said he just had to pop off and do something but he never came back
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Gee, nice to see this thread pick up again. LOL, Domski! That's a nice one.
So is a Goto the equivalent of the hubby who nips out to "get a pack of smokes" and never returns?
Interesting concept.
From Knuth's Structured Programming with Goto statements:
"At the IFIP Congress in 1971 I had the pleasure of meeting Dr. Eiichi Goto of Japan, who cheerfully complained that he was always being eliminated"
@Andrew
Very informative, hopefully Goto isn't planning something diabolical as a form of jealous revenge on GosubSo there you go, the full story.
Please leave a message after the beep!
He was, but he forgot where he left his 'murdering stuff'Very informative, hopefully Goto isn't planning something diabolical as a form of jealous revenge on Gosub.
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks