How to find used range of a row/column?
Is there any way i can know the used range of a row or column?
Regards, |
How to find used range of a row/column?
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 |
How to find used range of a row/column?
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 |
All times are GMT +1. The time now is 02:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com