jwcolby
jwcolby at colbyconsulting.com
Sat Feb 28 07:17:05 CST 2009
>The named ranges were there, you could see that they existed in the tools inside of Access, Uhh... inside of EXCEL... John W. Colby www.ColbyConsulting.com jwcolby wrote: > Gustav > > Unfortunately i do not have ongoing Excel development, so I do things as the need comes up over the > years. In this case I was trying to set named ranges in the template, then later (at run time) to > find the named ranges in code. That was what failed. The named ranges were there, you could see > that they existed in the tools inside of Access, but when I would say to put something into the > range it wouldn't go. > > As it happened I just had to get something out, and being well capable of doing it the crude way > using code, I did that. > > I am absolutely certain that using the named range is the right way, and I will be revisiting my code. > > John W. Colby > www.ColbyConsulting.com > > > Gustav Brock wrote: >> Hi John >> >> "Tried to do"? What does that mean? How could you forget? >> >> Named Range is one of the gems of Excel and should be mastered by anyone to avoid typing cell coordinates. >> >> /gustav >> >> >>>>> jwcolby at colbyconsulting.com 27-02-09 20:07 >>> >> I tried to do named ranges and couldn't get it figured out in time so I just went the brute force >> method. I will go back and revisit that. If I can get that working then I can pop it in the Excel >> class wrapper and it will be there the next time. >> >> Thanks! >> >> John W. Colby >> www.ColbyConsulting.com >> >>