#1
|
|||
|
|||
worksheet linking in VB
Hi I am trying to establish an Excel SpecialPaste "Paste Link" using VB code. Is it possible? - I cannot see how. John |
#2
|
|||
|
|||
Try the macro recorder, it will give you a good start point. The recorder is used by many users, from begginers to advanced...
Here is what the macro recorder came up after i manually pasted a link: Code:
Sub Macro1() ' ' Macro1 Macro ' ' Windows("diverse calcule.xls").Activate Range("F11").Select Selection.Copy Windows("New Microsoft Excel Worksheet.xlsx").Activate Range("D21").Select ActiveSheet.Paste Link:=True End Sub |
#3
|
|||
|
|||
Thanks - I'll certainly give that a try.
John |
#4
|
|||
|
|||
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 |