Macro #REF!

Giganews Newsgroups
Subject: Macro #REF!
Posted by:  daphoenix
Date: Tue, 8 Jul 2008

is there anyhthing I can do to reference the first 35 cells of a seperate
worksheet, but those 35 cells I am referencing change constantly, and with
what I have now does not work because every time a cell changes that I am
referencing I get a #REF! error. Is there a way I can change this?