how to show data in another sheet instead of msgbox

[toravietl]

hi I written the below code it will display the no of rows in msg box.but I want to show that value in another sheet collumn

sub myrows()
dim rows as single
rows=sheet1.usedrange.rows.count
msgbox(rows)
end sub

 

[p45cal]

hi I written the below code it will display the no of rows in msg box.but I want to show that value in another sheet collumn

sub myrows()
dim rows as single
rows=sheet1.usedrange.rows.count
msgbox(rows)
end sub

sub myrows()
dim rows as single
rows=sheet1.usedrange.rows.count
sheet2.range("C3")=rows
end sub

 

[toravietl]

Thanks.Its working fine.

sub myrows()
dim rows as single
rows=sheet1.usedrange.rows.count
sheet2.range("C3")=rows
end sub