Useful VBA for Excel
1. oSheet.UsedRange.Rows.Count
Refer to your worksheet's used rows count
2. oSheet.Cells(iLine, iCol).EntireRow.Insert xlDown
Action for insert a blank row after iLine
1. oSheet.UsedRange.Rows.Count
Refer to your worksheet's used rows count
2. oSheet.Cells(iLine, iCol).EntireRow.Insert xlDown
Action for insert a blank row after iLine