Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Dai Tanaka   on Dec 31 In MS Office Category.

  
Question Answered By: Debbie Reyes   on Dec 31

These worked for me:

If you've already selected the range  on the sheet with xldown:

ActiveWorkbook.Names.Add Name:="Sheet_Name_List", RefersTo:=Selection


but you don't need to select  the whole range, just the topmost cell:

ActiveWorkbook.Names.Add Name:="Sheet_Name_List",
RefersTo:=Range(Selection, Selection.End(xlDown))

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Absolute vs. relative range selection Or get search suggestion and latest updates.


Tagged: