ExcelBanter - copy row high

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - copy row high (https://www.excelbanter.com/excel-worksheet-functions/171307-copy-row-high.html)

F Andrew

copy row high

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 )

excelent

copy row high

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:

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 )

All times are GMT +1. The time now is 01:18 AM.