names.add "MyName",""

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


gavmer wrote:

Hi all,

Can someone provide me with a simple code to delete a named range, on
sheet2, with a command button click? This range may vary as data is
added but as i understand the range expands when the rows are
inserted.

Cheers!!!


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