Thread: copy row high
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
 
Posts: 695
Default 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 )