Sub getvalues()
Sheets("sheet2").Rows(3).Value = _
Sheets("sheet1").Rows(2).Value
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alen32" wrote in message
lkaboutsoftware.com...
On sheet1 in row2 I have formulas in some cells and comments in some
cells.
I want macro which copy entire row2 from sheet1 and paste on sheet2 and
row3.I don't need formulas only values from cells and comments.


--
Message posted using
http://www.talkaboutsoftware.com/gro...l.programming/
More information at http://www.talkaboutsoftware.com/faq.html