LinkBack URL
About LinkBacks
you need to double all the quotes inside the formula
ActiveCell.FormulaR1C1 = _ "=INDIRECT(CONCATENATE("" '[filename.xls]"",$A$2,""'!$AQ$466""))"
you need to double all the quotes inside the formula
ActiveCell.FormulaR1C1 = _ "=INDIRECT(CONCATENATE("" '[filename.xls]"",$A$2,""'!$AQ$466""))"
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks