Hi,

Are Usedrange.Rows & UsedRange.Columns what you want?
You might also want to check out the SpecialCells Method

Cheers

"Von Shean" wrote in message
...
Is there any way i can know the used range of a row or column?
Regards,




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.561 / Virus Database: 353 - Release Date: 13/01/2004