Excel: Dynamic Named Range


Dear all May i know if it is possible to create dynamic named range with multi columns?

=OFFSET($A$1,0,0,COUNT($A:$A),1)
Above formula is a dynamic named range which i get from microsoft. I would like to a dynamic named range from A1:AN ...... Thank you very much


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of May 31, 2015.


For more resources for Microsoft Excel