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

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

Thanks for the quick suggestion, i'll dive into that page and come back soon.
web u around
--
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

Dear JLGWhiz

There is an error accesing that page. try by yourself please
--
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

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

>There is an error accesing that page. try by yourself please

The web hosting hosting company trashed one of the config files used
by the site. It should be up later today.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sun, 23 Nov 2008 07:13:01 -0800, Edgar
<(E-Mail Removed)> wrote:

>Dear JLGWhiz
>
>There is an error accesing that page. try by yourself please

'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

Hello JLGWhiz,
Sorry for the delay, i was in my way back home. Now I'm ready for your help.
This is my concern:
Range A1:g16, are repeated for every page. No merged cells in that range,
included the one i need to change the value for.

range("A11") says: Period of Report. (That's the label). and Cell "B11"
could say "May 2008" or "Year 2008" or "Week September 09 through September
16".
this is the value i need to change according to an array variable that has
in one column the number of the page i'm previewing and in the second column
the value for that cell to show.

thanks my friend
--
Edgar Rey


"JLGWhiz" wrote:

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

thanks for the information, i´ll keep trying later
--
Edgar Rey


"Chip Pearson" wrote:

>
> >There is an error accesing that page. try by yourself please
>
> The web hosting hosting company trashed one of the config files used
> by the site. It should be up later today.
>
> Cordially,
> Chip Pearson
> Microsoft MVP
> Excel Product Group
> Pearson Software Consulting, LLC
> www.cpearson.com
> (email on web site)
>
>
> On Sun, 23 Nov 2008 07:13:01 -0800, Edgar
> <(E-Mail Removed)> wrote:
>
> >Dear JLGWhiz
> >
> >There is an error accesing that page. try by yourself please
>

I have to apologize. I thought a variable could be used to change the cell
in the fixed print range, but apparently I was wrong. There does not appear
to be an easy fix to the problem without writing code for the entire process
and I am not up to that at the moment.

"Edgar" wrote:

> Hello JLGWhiz,
> Sorry for the delay, i was in my way back home. Now I'm ready for your help.
> This is my concern:
> Range A1:g16, are repeated for every page. No merged cells in that range,
> included the one i need to change the value for.
>
> range("A11") says: Period of Report. (That's the label). and Cell "B11"
> could say "May 2008" or "Year 2008" or "Week September 09 through September
> 16".
> this is the value i need to change according to an array variable that has
> in one column the number of the page i'm previewing and in the second column
> the value for that cell to show.
>
> thanks my friend
> --
> Edgar Rey
>
>
> "JLGWhiz" wrote:
>
> >
> > '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