How to find used range of a row/column?

  • Thread starter Thread starter Von Shean
  • Start date Start date
Hi,

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

Cheers
 
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"
 
Back
Top