Just to add to GS and Gord's responses...

If you use worksheets(1), then you're using the leftmost sheet. You can change
the name and it'll still work. But if you change the position, then the code
may work--but it may not do what you want to the correct sheet!

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

--

Dave Peterson