Re: [ExcelVBA] Re: Need help on a Macro to compare two spreadsheets

 

I'm having trouble sending a response.
So I'll try sending it in "packets":

part 1
OK...
I think I'm going to answer your questions in reverse order....
--------------------
Option Explicit
--------------------
Using this AS THE FIRST LINE OF EACH MODULE tells the compiler that all
variables have to be "declared" (using Dim, Public, Global, etc.)
 
Without this, a variable doesn't HAVE to appear in a Dim statement.
The compiler will "automatically" declare the variable the first time it is
used.
This can be dangerous because if you're using a variable called "YearValue"
and in one place, you accidentally call it "YearValeu", the compiler will not
recognize that as a problem.  It will simply create a new variable.
"Option Explicit" tells the compiler that all variables have to be "Explicitly"
declared.
 
Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

• New Members 3

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

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

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___