Why not just automate the copy/paste routine ? (I have discovered that
this is faster than parsing individual cells anyway).

When pasting you only need to supply the top left cell, which in your
case will be the top of the column you wish to remove.


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