after you selected the scope of a name it can not be changed (at least not easily, of course it is possible with VBA).in the example file Name01 scope is the NameSample01 sheet, you can not refer to it anywhere else in the file) the scope of a name is workbook OR a sheet (in case of sheet scope name can only be used on that sheet) (e.g.actually, they are formulas (to be more precise array formulas),.defining names referring to a range of cells makes navigation much easier to that specific range of cells. in the example file NameSample02 tab F6 formula: ‘=UnitRate*Quantity’ instead of ‘=D6*B6’
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |