Thank you for the quick response.. i'll check the declaration setting.
--- On Fri, 5/20/11, david braithwaite <dbraithwaite@charter.net> wrote:
From: david braithwaite <dbraithwaite@charter.net>
Subject: [ExcelVBA] Re: VBA/Macro Version problem
To: ExcelVBA@yahoogroups.com
Date: Friday, May 20, 2011, 12:08 AM
Hi
A simple test works fine for me
Sub foo()
Irow = 10
For i=1 to irow
Next i
End sub
Is the "option explicit" the first line of module? ---- that would make
it so variables had to be declared.
But it would work the same in 2003,2007,2010 ---- so the difference would
still by a mystery.
Pull up tools>options on the vba menu and see if "variable declaration
required" is checked.
If it is, unset it --- and try.
Db
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
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
----------------------------------
Tidak ada komentar:
Posting Komentar