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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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