copy row high

F

F Andrew

hi,

i need to copy row high from one worksheet to another worksheet, is there
any way to copy the row high ? ( just like paste colom widths )
 
E

excelent

Sub tst()
Application.ScreenUpdating = False
For t = 1 To 20
Sheets("Sheet2").Cells(t, 1).RowHeight = Sheets("Sheet1").Cells(t,
1).RowHeight
Next
Application.ScreenUpdating = True
End Sub


"F Andrew" skrev:
 
Top