IntroductionI've run into references to Get.Cell The latest was in an article at TrumpExcel, How to Filter Cells with Bold Font Formatting in Excel.
About Get.CellGet.Cell is a function from Excel 4.0 macro sheets. It is used to retrieve information about a cell, using a long list of numeric codes to get a specific type of information. There are a number of types of information that Get.Cell can return that are available now through other worksheet functions. For example, COLUMN() and ROW().
Get.Cell is still available but on very limited terms, i.e. it cannot be used in a cell but it can be used as a function in a workbook/worksheet Name RefersTo box.
Because in VBA we have access to the