Jie,

Are you sure it was A3:A9, not A6:A9. If the latter, that is due to being in
a different cell from that when the range was named, which is overcome by
making them absolute $A$3:$A$6

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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