Jie,

Try using absolute referencing in the address to which the name
refers. E.g., $A$3:$A$6 rather then A3:A6


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jie" wrote in message
...
Hi

I created a named range in VS.NET C#, for example, PPP_CUSTOMER
= "Jo"+Sheet1!A3:A6. But later when I use Excel VBA Addin to
query this named range (Workbook.Names(i)), the range has changed
to Sheet1!A3:A9. Do you know why?

Thanks

Jie