Addig NAmed Range Dynamically | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Addig NAmed Range Dynamically

Excel_WorkBook.Names.Add "ImportT1able", sActualLocationOfData supposed to add a Named range to the excel fill. But It doesn’t? what can be the reason<br /><br />I think I have missed out very minor this [<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />!]<br /><br />
DONE!! Excel_WorkBook.Names.Add "ImportTable", "=$H$14:$K$43", True is working
]]>