Search:

MS Office Answers

Ask Question UnAnswered

Question Asked By: Dai Tanaka on Dec 31 In MS Office Category.

Absolute vs. relative range selection

Question Answered By: Alberta Miller on Dec 31

Try this

ActiveWorkbook.Names.Add Name:="testname", RefersTo:=Range(Range("A2"),
Range("A2").End(xlDown))

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

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us