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?

As ALWAYS, post YOUR code for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"daphoenix" <(E-Mail Removed)> wrote in message
news:9DB6AD2D-2638-4602-9926-(E-Mail Removed)...
> 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?