using CreateNames for sheet-only names vba
I am using
ActiveCell.CurrentRegion.CreateNames top:=True, left:=False
this is effective in naming the columns at the top. I need to make these
named ranges local to the sheet. Is there a way to do this with the
CreateNames instead of the Names.Add?
Any help would be much appreciate.
No comments:
Post a Comment