I used...
it will give row count.... again I delete the cell contents manually... then I run above script.. It is giving row count which it has more than used (including copied rows)
Code:
rc=xl.sheets("Sheet1").usedrange.rows.count
msgbox rcit will give row count.... again I delete the cell contents manually... then I run above script.. It is giving row count which it has more than used (including copied rows)