Gustav Brock
Gustav at cactus.dk
Sat Feb 28 09:03:21 CST 2009
Hi John Now, I don't quite know what you are trying to do, but it sounds as what you were dealing with in Jan. 2006 ... Please look up the threads: "Syntax for seeing named range in excel" for the dates 19, 20, and 21 and indeed: "Setting data into and getting data from Named Range" for the date 23 and 24 ... <quote by John Colby> I have it WORKING!!! Yea!!! What a learning experience this has been. </quote by John Colby> /gustav >>> jwcolby at colbyconsulting.com 28-02-2009 14:17 >>> >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