Is there any way i can know the used range of a row or column?
Regards,

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

Let me explain it a little...
i have following values in my sheet
6 6 6 6 6 6
2 2
5 5 5 5 5
4 4 4 4

So used range if third row is five .... so i need to know about any way to
get that in VBA.
Something like would be like
ActiveSheet.Rows(3).UsedRange.Address
and gives
"A3:E3"


"macropod" (del NO.SPAM) wrote in message
...
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