4/28/2023 0 Comments Name manager excel 2011 for macOver 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 |