Yeah, well... I get that way too...
Sometimes things just NEED to be said!
I use several strings for testing, depending on what
I'm testing for..
I get tired of "this is a text string", so I use
whatever happens to float to the top of the mind puddle... (muddle?)
Most are misquotes from movies, actors or show tunes:
"The rain in Spain stays mainly on the plain" - Eliza in "My Fair Lady"
"Take my wife, please!" - Rodney Dangerfield
"Luke, I'm your Father" (Darth Vader - DEFINITELY misquoted)
"Do or do not, there is no try" - Yoda
and a favorite:
"You must unlearn what you have learned" - Yoda
I think I'll start using that one more...
Paul
________________________________
From: Dave Bonallack <davebonall...@hotmail.com>
To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
Sent: Tue, March 8, 2011 9:22:34 PM
Subject: RE: $$Excel-Macros$$ OT
Hi Paul,
Well said. I tried to let it go unchallenged, but since I had nothing better to
do at the time... :)
Dave.
________________________________
Date: Tue, 8 Mar 2011 19:12:46 +0530
Subject: Re: $$Excel-Macros$$ OT
From: svyas0...@gmail.com
To: excel-macros@googlegroups.com
very nice speech Mr. Paul Sir.
Regards
Sumit Vyas
On Tue, Mar 8, 2011 at 7:07 PM, Paul Schreiner <schreiner_p...@att.net> wrote:
Dave,
>Hey! I'm an ENGINEER, not an ENGLISH major!
>Or a veterinarian for that matter!
>What kind of dog would jump over a fox anyway...
>Always seemed (seems?) suspicious (spurious?), if you ask me...
>lol.
>
>Paul
>
>
>
>
________________________________
From: Dave Bonallack <davebonall...@hotmail.com>
>To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
>Sent: Mon, March 7, 2011 7:54:54 PM
>Subject: $$Excel-Macros$$ OT
>
>
>Hi Paul,
>Completely OT, but it has to be "jumps", not "jumped", otherwise there's no
>"s"
>in the sentence. -:)
>Dave.
>
>________________________________
Date: Mon, 7 Mar 2011 06:13:04 -0800
>From: schreiner_p...@att.net
>Subject: Re: $$Excel-Macros$$ ( ) for Array Must???
>To: excel-macros@googlegroups.com
>
>
>It really depends on how you're using the array.
>Basically, using:
>Dim Arrayabc
>
>You're not declaring an "array", you're declaring a single variable, type
>Variant.
>Now, later you can use
>Redim ArrayABC(30)
>and change the variable to an array.
>
>Or, curiously enough:
>
>ArrayABC = Split("The big brown dog jumped over the lazy fox"," ")
>
>will Redim ArrayABC to whatever array size is required to store the string.
>(in this case, Ubound(ArrayABC) will be 8)
>
>If you were to use:
>Dim ArrayABC
>Dim ArrayDEF()
>Dim ArrayXYZ(3)
>.
>.
>.
>Redim ArrayABC(30)
>Redim ArrayDEF(30)
>Redim ArrayXYZ(30) ' Will not work, because the array was already defined.
>
>So, depending on how you plan to use it, you can either have the () or not.
>However, if you choose to use the (), you MUST (in some manner) define the
>array
>size before you can use the array.
>However:
>You CAN change a single variant to an array, and back again:
>
> Dim A
> A = "The Big Brown Dog"
> A = Split("The big brown dog jumped over the lazy fox", " ")
> Erase A
> A = "Jumped over the Lazy Fox"
>
>hope this isn't too confusing.
>
>Paul
>
>
>
________________________________
From: hanumant shinde <hanumant_5...@yahoo.co.in>
>To: excel macros <excel-macros@googlegroups.com>
>Sent: Sat, March 5, 2011 2:31:03 PM
>Subject: $$Excel-Macros$$ ( ) for Array Must???
>
>
>Hi friends,
>
>when we declare array is it must to give () i mean parantheses.
>
>can i declare array as dim arrayabc or i have to say dim arrayabc()
>i know that if we dont write any value in () its ok. but i am not sure if we
>can
>declare array without ()
>
>
>
>--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com/
>4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>
>--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>
>--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>
>
>--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
