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

posted @ 2009-11-21 13:27  Rookie.Zhang  阅读(128)  评论(0)    收藏  举报