Hi,
I've managed to name some dynamic ranges with OFFEST and COUNTA. However I'd really like to manage my ranges with a VBA procedure as there'll be quite a few ranges and the UI method is loathsome.
I found this during some searching but it's not working.
I have very limited VBA knowledge. (i can do cut, paste & tweak but cant write yet)![]()
ThisWorkbook.Names.Add Name:="NewName", _ RefersTo:="=$A$1:$C$10", Visible:=True
Can anyone assist?
Bookmarks