I would like to highlight a range of cells in my worksheet and then ru
a macro that will then create a Named Range using those highlighte
cells.
I suppose the VBA would be something like:
ThisWorkbook.Names.Add Name:="NewName", _
RefersTo:=
But I don't know what code is needed next. Can anyone help?
Many Thanks,
Michae
--
michael.a
-----------------------------------------------------------------------
michael.a7's Profile:
http://www.excelforum.com/member.php...fo&userid=3302
View this thread:
http://www.excelforum.com/showthread.php?threadid=55014