View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joemeshuggah joemeshuggah is offline
external usenet poster
 
Posts: 96
Default Compile Error: Variable Not Defined

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!!!