Автор: dude. Добрый день! по теме: http://www.planetaexcel.ru/forum/?PAGE_NAME=read&FID=8&TID=1968 еще оно решение:Option Explicit Function RetrieveRangeForName(psRange As String) As String Application.Volitile RetrieveRangeForName = Range(psRange).Address End Function отсюда http://chandoo.org/forum/threads/passing-a-named-range-to-a-formula-with-indirect.5854/#post-32423