Hello,

I am using the following code that deletes rows in a range.

This range expands as info is added. A user clicks a button to have th
rows that were inserted deleted however, when performed, the range i
deleted. What i need is for the range to not actually be deleted bu
for the inserted rows to beleted/removed and for the range to revert t
normal.

Can someone please assist??

Sheets("TEMP").Range("pricing").Delete Shift:=xlShiftU

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