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
