|
|
|
|
#1
08-18-2012, 11:19 PM
|
|||
|
|||
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"
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 "Auto-populating" data-worksheet to worksheet.
|
meggenm | Excel | 4 | 02-04-2012 02:04 AM |
| Create/delete New worksheet | ibrahimaa | Excel Programming | 5 | 01-16-2012 11:53 PM |
|
How to delete page not worksheet?
|
rec | Excel | 6 | 05-20-2011 08:51 PM |
|
Can I use a formula to name a worksheet?
|
nolesca | Excel | 3 | 06-07-2010 04:02 PM |
|
Worksheet copying?
|
markg2 | Excel | 4 | 01-07-2010 10:08 AM |
Windows Vista 
Office 2010 32bit
Hybrid Mode