P
Paul Wagstaff
Excel 03
Hi all
I have a bunch of named ranges (Insert > Name > Define) which I wan to
iterate through, & then delete their contents. I'm trying this :
For Each nm in ThisWorkbook.Names
nm.ClearContents
Next nm
can someone please show me the correct way to do this.
thanks
paul
Hi all
I have a bunch of named ranges (Insert > Name > Define) which I wan to
iterate through, & then delete their contents. I'm trying this :
For Each nm in ThisWorkbook.Names
nm.ClearContents
Next nm
can someone please show me the correct way to do this.
thanks
paul