Sheet Row Heights

  • Thread starter Thread starter Dorian C. Chalom
  • Start date Start date
D

Dorian C. Chalom

When I copy a sheet the row hieghts do not copy over as well.
How can I make the Row hieghts and for that matter column widths copy over
when I copy a range of a spreadsheet?

Thank you...
 
Mixed message in your description.

"copy a sheet" and "copy a range" are not the same thing.

If copying a sheet using right-click>move or copy>create a copy the
formatting will not change.

If you copy entire rows and columns the heights and widths will be copied.

If you simply copy a range of cells, the heights and widths will not copy.


Gord Dibben MS Excel MVP
 
If you copy a range you can use paste special>column widths. There is no row
height option.
 
Gord;

Yes I am sorry...I am copying a Range since when I tried to copy a sheet I
was getting error because of the llookup functions I was using were linked
to external tables I was getting errors.
When I tried to do just a range the errors did not occur and my function
could run to completion.
Only now I do loose my Row Height, Clumn Widths being kept when I copy the
range.
Is there some code I could write to restore that formating?

Thank you
 
Back
Top