Possible to copy row height/column width when copy format?

When duplicating a section of a workbook, is there a way to copy the row heights and column widths as well as the cell formats. Every method I've tried, I can get the cell format(borders,bold print,currency,etc.) but the rows and columns have to be sized manually.

[Derek]

Hi
If you're using Excel 2000 try this:
Select the entire rows you want to copy, when you paste them to a new sheet the rows heights should adjust.
Now copy the columns whose widths you want to repeat. When you paste, use Paste Special,Column Widths.
Hope this helps
Regards
Derek

Thank you. It is at least 90% solution. Still have to cut and paste data on a second pass but that is much easier than sizing hundreds of rows and dozens of columns.

[timbowyn]

On your original excel worksheet, there is a blank square located above the "1" and to the left of "A" column and row identifiers. Right click on this blank square, choose copy. This will copy everything on your original sheet. Now go to the new sheet. Right click on the blank square, choose paste. This will copy and paste everything exactly as it was on the original sheet, columns, rows, formatting.