how to show data in another sheet instead of msgbox

toravietl

New member
Joined
Mar 7, 2014
Messages
7
Reaction score
0
Points
0
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:

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,200
Reaction score
16
Points
38
Excel Version(s)
365
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
Code:
sub myrows()
dim rows as single
rows=sheet1.usedrange.rows.count
sheet2.range("C3")=rows
end sub
 
Top