I can't see how there is anyway progromatically to determine what the "Original" size of your named Range was

----- gavmer wrote: ----

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