02-08-2010, 04:58 PM
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 rc
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)