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
Code:
sub myrows()
dim rows as single
rows=sheet1.usedrange.rows.count
msgbox(rows)
end sub
Last edited by a moderator: