S
spence
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
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