02-08-2010, 05:18 PM
Yes, I guessed it right. when you use usedrange, it will take all the earlier pasted rows as used and so you are getting more than used.
how do you paste the content? try to set the rowcount back i.e if you are pasting from 1st row then at the time you delete the content set the row to start pasting back to 1.
or may be you can try deling the rows itself.
how do you paste the content? try to set the rowcount back i.e if you are pasting from 1st row then at the time you delete the content set the row to start pasting back to 1.
or may be you can try deling the rows itself.