How can i use UsedRange.Rows.Count if any blank rows embeded into the sheet

Hi,
I am using below statement to count the rows with data in a sheet in excel --- 'how many rows are used in the Target worksheet TrgusedRowsCount = TrgcurrentWorkSheet.UsedRange.Rows.Count

But if that sheet contains some blank rows in between ,then how can i exclude that number of blank rows and get the eaxct used rows count in the sheet.

Please help me on this.

Thnaks-Amar

Please Login or Register  to view this content.