Thread: [Solved] worksheet linking in VB
View Single Post
 
Old 08-18-2012, 11:19 PM
Catalin.B Catalin.B is offline Windows Vista Office 2010 32bit
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
You may find useful this approach, which does the same thing:
Code:
ThisWorkbook.Sheets("Sheet3").Range("F8").Formula = "='C:\Users\Catalin\Desktop\[New Microsoft Excel Worksheet.xlsx]Sheet1'!$I$16"
Reply With Quote