option explicit public sub testrun() dim l long l = selection.row.count activecell.value = l end sub this code showing 424 error: object required in vba. please help.
use rows instead of row
option explicit public sub testrun() dim l long l = selection.rows.count activecell.value = l end sub
Comments
Post a Comment