worksheet linking in VB

Catalin.B · #2 08-17-2012, 07:55 AM

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

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