I DO NOT KNOW IF THIS HAS TO BE DONE USING VBA ETC OR IF YOU CAN DO IT WITH
NORMAL EXCEL FUNCTIONS.
I KNOW THAT YOU CAN NAME BLOCKS OF CELLS, BUT I CANNOT REMEMBER HOW TO DO IT

Select the range of cells say B5:D10. Just above Col A header in the 'Name
box' type the name you would prefer to have for the named range.


If this post helps click Yes
---------------
Jacob Skaria


"SURFERJOE" wrote:

I DO NOT KNOW IF THIS HAS TO BE DONE USING VBA ETC OR IF YOU CAN DO IT WITH
NORMAL EXCEL FUNCTIONS.
I KNOW THAT YOU CAN NAME BLOCKS OF CELLS, BUT I CANNOT REMEMBER HOW TO DO IT