I wish I could upload a blank copy of this form so you could tell what
I am looking at.

Basically, a property record is spread over 3 rows of a 48 row form
for each page. There are currently 25 of these report detail pages.
You get 10 properties to a page. Each property has a total of 20 boxes
labeled 11 through 30 (1 to 10 are contained in the page header).

For a given property, we start off with rows 1 and 2 being merged and
centered to form one field in rows A&B. Every other row from 6 through
40 is like that with the rows in between not like that.
Box 9 is contained in column C and it extends the length of all the
property rows on that page, which would be rows 5 through 40. No big
deal comparitively on this portion. Next is where it gets harder.

On the odd number rows, you have these label boxes 11 to 22 on row 1
of each property then boxes 23 through 30 on row 3. For rows 2 and 4
you have the formula driven values for the boxed labels described
above. Just as an example there, the value below box 11 is a merge and
center cell of cell columns F&G, 12 covers columns H&I and 13 covers
J&K, then it goes all the way over to 21 before having the next merge
cell. By the time you get back to box 24, you start with the every
other box gets 2 or more columns, with a few having 3 columns.

The thing is you can get the silly page formatted correctly but then
when you start copying single cell information into an area with
merged and centered columns, you get these messages disallowing this
process. So in order to populate a new page, you may have to tear up
the merge and center columns in order to copy in formulas or whatever
values you need.

What I need is a SIMPLE macro approach to format a whole page at a
time like I just described, without distrubing any populated fields
inside of the page if there are any.

Any ideas?

Thanks,


Bruce

After serious thinking Revenue wrote :
I wish I could upload a blank copy of this form so you could tell what
I am looking at.

Basically, a property record is spread over 3 rows of a 48 row form
for each page. There are currently 25 of these report detail pages.
You get 10 properties to a page. Each property has a total of 20 boxes
labeled 11 through 30 (1 to 10 are contained in the page header).

For a given property, we start off with rows 1 and 2 being merged and
centered to form one field in rows A&B. Every other row from 6 through
40 is like that with the rows in between not like that.
Box 9 is contained in column C and it extends the length of all the
property rows on that page, which would be rows 5 through 40. No big
deal comparitively on this portion. Next is where it gets harder.

On the odd number rows, you have these label boxes 11 to 22 on row 1
of each property then boxes 23 through 30 on row 3. For rows 2 and 4
you have the formula driven values for the boxed labels described
above. Just as an example there, the value below box 11 is a merge and
center cell of cell columns F&G, 12 covers columns H&I and 13 covers
J&K, then it goes all the way over to 21 before having the next merge
cell. By the time you get back to box 24, you start with the every
other box gets 2 or more columns, with a few having 3 columns.

The thing is you can get the silly page formatted correctly but then
when you start copying single cell information into an area with
merged and centered columns, you get these messages disallowing this
process. So in order to populate a new page, you may have to tear up
the merge and center columns in order to copy in formulas or whatever
values you need.

What I need is a SIMPLE macro approach to format a whole page at a
time like I just described, without distrubing any populated fields
inside of the page if there are any.

Any ideas?

Thanks,


Bruce

Why is it necessary to merge cells? Can't you use single cells and
adjust column width to suit?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Why is it necessary to merge cells? Can't you use single cells and
adjust column width to suit?


You have to use merge cells in this case because single column widths
would necessitate that the row below it be aligned right below it and
that is not the way this silly form works. I don't have any options
with regard to changing the layout of the form. It must match what the
State of Oklahoma uses in this case.

Thanks,


Bruce

On Oct 21, 11:02*am, Revenue wrote:
Why is it necessary to merge cells? Can't you use single cells and
adjust column width to suit?

You have to use merge cells in this case because single column widths
would necessitate that the row below it be aligned right below it and
that is not the way this silly form works. I don't have any options
with regard to changing the layout of the form. It must match what the
State of Oklahoma uses in this case.

Thanks,

Bruce
Send your file with a complete explanation and before/after examples
to dguillett1 @gmail.com

" wish I could upload a blank copy of this form..."

You can use a file hosting website and post the link in this newsgroup.
One such site is... http://www.filedropper.com/
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)




"Revenue"
wrote in message
...
I wish I could upload a blank copy of this form so you could tell what
I am looking at.

Basically, a property record is spread over 3 rows of a 48 row form
for each page. There are currently 25 of these report detail pages.
You get 10 properties to a page. Each property has a total of 20 boxes
labeled 11 through 30 (1 to 10 are contained in the page header).

For a given property, we start off with rows 1 and 2 being merged and
centered to form one field in rows A&B. Every other row from 6 through
40 is like that with the rows in between not like that.
Box 9 is contained in column C and it extends the length of all the
property rows on that page, which would be rows 5 through 40. No big
deal comparitively on this portion. Next is where it gets harder.

On the odd number rows, you have these label boxes 11 to 22 on row 1
of each property then boxes 23 through 30 on row 3. For rows 2 and 4
you have the formula driven values for the boxed labels described
above. Just as an example there, the value below box 11 is a merge and
center cell of cell columns F&G, 12 covers columns H&I and 13 covers
J&K, then it goes all the way over to 21 before having the next merge
cell. By the time you get back to box 24, you start with the every
other box gets 2 or more columns, with a few having 3 columns.

The thing is you can get the silly page formatted correctly but then
when you start copying single cell information into an area with
merged and centered columns, you get these messages disallowing this
process. So in order to populate a new page, you may have to tear up
the merge and center columns in order to copy in formulas or whatever
values you need.

What I need is a SIMPLE macro approach to format a whole page at a
time like I just described, without distrubing any populated fields
inside of the page if there are any.

Any ideas?

Thanks,


Bruce

On Oct 21, 1:22*pm, "Jim Cone" wrote:
*" wish I could upload a blank copy of this form..."

You can use a file hosting website and post the link in this newsgroup.
One such site is... *http://www.filedropper.com/

Hope this link below works. Just take a look at the hideious row
heights and merge cells, and then refer back to the top for my
original question.

<a href=http://www.filedropper.com/oklahomagpxform300<img src=http://
www.filedropper.com/download_button.png width=127 height=145 border=0/
</a<br /<div style=font-size:9px;font-family:Arial, Helvetica, sans-
serif;width:127px;font-color:#44a854; <a href=http://
www.filedropper.com file storage</a</div



Thanks,


Bruce

Revenue presented the following explanation :
On Oct 21, 1:22*pm, "Jim Cone" wrote:
*" wish I could upload a blank copy of this form..."

You can use a file hosting website and post the link in this newsgroup.
One such site is... *http://www.filedropper.com/

Hope this link below works. Just take a look at the hideious row
heights and merge cells, and then refer back to the top for my
original question.

<a href=http://www.filedropper.com/oklahomagpxform300<img src=http://
www.filedropper.com/download_button.png width=127 height=145 border=0/
</a<br /<div style=font-size:9px;font-family:Arial, Helvetica, sans-
serif;width:127px;font-color:#44a854; <a href=http://
www.filedropper.com file storage</a</div



Thanks,


Bruce

The download button does nothing!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

I tested this link this time. It worked.


http://www.filedropper.com/oklahomagpxform300_1