in the vba development environment (the IDE) from the menu select Tools then
Options
In the Options window, the Editor tab is showing, make sure you check the
'Require Variable Declaration' box - this will then automatically add
OPTION EXPLICIT
to all new modules

before running code, be sure to Debug/Compile too .. thsi will pick up
errors in sybtax or names too



"joemeshuggah" wrote:

i am getting a compile error: variable not defined message on the following
line of code...

FinalRow2009 = Cells(Cells.Rows.Count, "A").End(xlUp).Row

i never had this problem before, and wonder if i may have changed a setting
somewhere and am not sure what needs to be changed to get it to work again.
i tried going into options and unchecking the Require Variable Declaration
box in the Editor tab, but that didn't work.

how do i remedy?

thanks!!!