Good morning BRISBANEBOB

This technique that you are describing is actually an old (OK, very old) XL4 macro. These are the days before VBA was invented, and actually predates my time with Excel that started with Excel 95.

The problem with these old XL4 macros is that they can't be used directly in the worksheet - which is why you need to wrap the formula up in a named range. The object of the Get.Cell command is to return info about a particular cell, in pretty much the same way as todays Cell() command does - except far more powerful.

The problem with these XL4 macros is that they are followed by parameters that are usually just numeric, so unless used frequently (very frequently) you wouldn't be able to follow what's happening. These old XL4 macros still pop up (albeit infrequently) on the forums because in some cases they can return information that can only be accessed by using a number of lines of VBA code.

If you really need to know more, have a look at this link which contains the old help files for XL4 functions.

HTH

DominicB