As Bubba said, it depends on your definition of "is" is. "comments" could
mean
in b1 =a1*2
in c1 "Gee that was two"
or it could be what you offered. Or,

Sub getvalues1()
With Sheets("sheet2").Rows(3)
Sheets("sheet1").Rows(2).Copy
.PasteSpecial Paste:=xlValues
.PasteSpecial Paste:=xlPasteComments
End With
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JW" wrote in message
ups.com...
Don, that code works fine to get the values, but the OP wanted to get
the comments as well.

Don Guillett wrote:
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