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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need an aswer- URGENT! 2
copy one row at a time to different worksheets 1
Excel Help to copy information from one row at a time to another sheet 1
Copy a range data from 1 sheet to multiple selected sheets 1
unhide row does not unhide the hidden rows 4
Too Few Rows to copy sheet to another book 2
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top