this code works in VBA, not sure about VB.Net.


For Each nm In ThisWorkbook.Names
MsgBox (nm.Name & " refersto : " & nm.RefersTo)
Next nm


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=180631

Microsoft Office Help