'change the value of one cell within that range,
every time a new page is displayed'

1. What is the range? Rows("1:3")?
2. Which cell needs to be changed?
3. Are there cells merged?
4. Is the cell to change in a merged cell?

'every page is for a Different item, and within
that range there is a label indicating the item
reported on that page.'

3. What do you mean by label?
a. Is it a label from a tool bar? Which tool bar?
b. Other?

Below is basically what is on the website previouly referenced:

The folks who volunteer to assist in this NG cannot see
the files that the people seeking help have in front of
them. That means that the people who post their problems
need to provide as much detail as possible, including any
code or formulas that they may have tried to use to achieve
their goals. They also need to be as clear as possible in
what their goal is. Terminology that is common to the
applications that are being worked with should be used and
not colloquialisms that have to be interpreted by those trying
to assist.

"Edgar" wrote:

Please, would you give the hints on how to. I just can't access that page
--
Edgar Rey


"JLGWhiz" wrote:

The short answer is yes. But to offer any meaningful suggestions on how, we
would need to know a little more. See this site, then post back.

http://www.cpearson.com/excel/HintsA...roupUsers.aspx

"Edgar" wrote:

Hello,

I have a question and Thanks for suggestions:
I have a range designated for - Print Rows on Top - in PageSetup. I'd like
to know if i can change the value of one cell within that range, every time a
new page is displayed. Cause it is a report and every page is for a Different
item, and within that range there is a label indicating the item reported on
that page.

--
Edgar Rey