Do
insert=Name

Name: RangeName
RefersTo: =INDIRECT(Sheet1!$J$6&":"&Sheet1!$J$7)

If you change the values in J6 and/or J7, the definition of RangeName will
be changed as well.

Regards,
Tom Ogilvy


spence wrote in message
...
on sheet 2 cell J6 i have the text B7 and in J7 i have
the text L10. i need a macro to name range("B7:L10")
with the text that is in cell J8. J8's text
is "RangeName" i want it to name the range that the text
in the two cells specifies, because the value in cells J6
and J7 will change periodically, i just don't want to
have to keep re naming a bunch of ranges every month. TIA