Just to make sure that you are working with what you think you
will be working with -- if you start with an empty sheet so that the
lastrow count will not be messed up and populate cells B3:D4
you will get the following results (nothing is in the first two rows):

ActiveSheet.UsedRange.Rows.Count is 2
Cells.SpecialCells(xlLastCell).Row is 4
ActiveSheet.UsedRange.Address is $B$3:$D$4
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"alsameer" wrote in message
...

thanks David.
I got it. "ActiveSheet.UsedRange.Rows.Count"
ur [Your] links were really helpful. :)