excel vba - VBA Script 424: object required on Selection.row.count -


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