Excel Named Range Question
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 |
All times are GMT +1. The time now is 07:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com