Hi Shirley
Are you copying data from the same sheet within the same workbook?
How many columns are involved?

Cordially
Pascal

"shirley " a écrit dans le message
de ...
i need to add 10 empty rows after each non-empty row and copy data from
other columns and paste it within the empty row. how should i go about
doing it?


---
Message posted from http://www.ExcelForum.com/