It depends on how your ae referring to the Sheet.

x=Sheets("Sheet1").Range("A1").Value will not change
x=Sheets(1).Range("A1").Value will change
--
Gary''s Student - gsnu200840


"Oligo" wrote:

if my macro on sheet 2 has a formula reference with sheet 1 cell, when i
change the name of sheet 1, will the macro work and change itself
accordingly???