M
Murat D. Hekimoðlu
Hello all,
I copy a Range and then paste it into new excel workbook. Duiring this
action I use the below code. I can pastespecial the column widths but cant
paste the Row Height. Is there any possibility that I can copy the
RowHeights too??
Sheets(1).Range("A1").PasteSpecial Paste:=xlValues
Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteFormats
Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteColumnWidths
Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteRowHeight ?????????
I copy a Range and then paste it into new excel workbook. Duiring this
action I use the below code. I can pastespecial the column widths but cant
paste the Row Height. Is there any possibility that I can copy the
RowHeights too??
Sheets(1).Range("A1").PasteSpecial Paste:=xlValues
Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteFormats
Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteColumnWidths
Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteRowHeight ?????????