Formatting problem copying sheet

  • Thread starter Thread starter Greg Lovern
  • Start date Start date
G

Greg Lovern

I have a worksheet that if I copy to a new workbook, all is well. But
if I first create a new workbook and then copy this sheet into that
new worbook, the formatting is off -- the copied sheet is much wider
than the source.

I don't see any difference in the page setup properties. Any idea why
it's happening and what I can do about it?


Thanks,

Greg
 
Greg Lovern presented the following explanation :
I have a worksheet that if I copy to a new workbook, all is well. But
if I first create a new workbook and then copy this sheet into that
new worbook, the formatting is off -- the copied sheet is much wider
than the source.

I don't see any difference in the page setup properties. Any idea why
it's happening and what I can do about it?


Thanks,

Greg
Click to expand...

I suspect...
If you first create a new workbook the copied sheet's 'Normal' format
becomes the new workbook's 'Normal' format. If you copy a sheet to a
new workbook, its 'Normal' format becomes the new workbook's 'Normal'
format.
 
Greg Lovern presented the following explanation :



I suspect...
If you first create a new workbook the copied sheet's 'Normal' format
becomes the new workbook's 'Normal' format. If you copy a sheet to a
new workbook, its 'Normal' format becomes the new workbook's 'Normal'
format.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Click to expand...

Thanks, the culprit was the Normal Style's font size.

FWIW, I found that to accurately get the source workbook's Style data,
that workbook had to be active. And, to set the target workbook's
Style data, that workbook had to be active. So now my code looks
like:

-- activate the source wb.
-- set variables to the source wb's Normal Style's font name and size.
-- activate the target wb.
-- set the target wb's Normal Style's font name and size.

Working fine now.

Greg
 
Thanks, the culprit was the Normal Style's font size.

FWIW, I found that to accurately get the source workbook's Style data,
that workbook had to be active. And, to set the target workbook's
Style data, that workbook had to be active. So now my code looks
like:

-- activate the source wb.
-- set variables to the source wb's Normal Style's font name and size.
-- activate the target wb.
-- set the target wb's Normal Style's font name and size.

Working fine now.

Greg
Click to expand...

Glad you got it resolved! Thanks for the feedback...
 
Back
Top