Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
EXCEL_ISSUE
#3
Not Solved
I used...

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)
Reply


Messages In This Thread
EXCEL_ISSUE - by bfakruddin - 02-08-2010, 04:05 PM
RE: EXCEL_ISSUE - by Saket - 02-08-2010, 04:19 PM
RE: EXCEL_ISSUE - by bfakruddin - 02-08-2010, 04:58 PM
RE: EXCEL_ISSUE - by Saket - 02-08-2010, 05:18 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)