Hi Brian,
See http://www.mvps.org/dmcritchie/excel...w.htm#insrtrow

Selection.Offset(1).Resize(vRows).EntireRow. _
SpecialCells(xlConstants).ClearContents
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"BN" wrote in message ...
I need to code worksheet so that it will clear contents of column A in rows
being pasted/inserted into worksheet. Copied from location either above or
below the insert location. Affecting only inserted rows. Hope this makes
sense. Any help would be greatly appreciated.
Thanks,
-Brian