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