![]() ![]() So, If I am reading your answer correctly, I should be able to change the above to Over in D I define Trees to be a named range E2:J300 I'd rather define it in D and use it where I wish. Searching for help, I can define it as a named range in the destination workbook, but his will require redefining it in every workbook that uses D. ![]() ![]() In I.xls I want to use a VLOOKUP on one of D's named ranges.Ĭan I refer to D's named ranges in a formula? If so, what is the syntax? Names aren't associated with a sheet so the SheetName!explict_range syntax doesn't work. D.xls is a reference worksheet used to define commonly used infomation for a bunch of other worksheets.ĭ.xls has named ranges for this and that.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |