pkm1998
06-14-2006, 08:53 PM
Hi
I have written a macro which copies a formula to another worksheet ( paste special formulas), but the link to the sheet i am copying from is retained. I need to edit the link via a macro as i have 250 worksheets to go through.
I want to be to edit the link prior to moving to the next work book.
This is what i need to accomplish.. everything is working expect for being unable to edit links
Sub CopyLookup()
Counter = 0
Do While Counter < 250
Counter = Counter + 1
If Counter = 250 Then
MsgBox "Last entry"
Else
Lookup 'this is where the data formula ( which is a vlookup) is being copied
' i would love to be able to edit the link just here.
ActiveWorkbook.Save
ActiveWorkbook.Close
End If
Loop
End Sub
Can anyone please help??:banghead:
I have written a macro which copies a formula to another worksheet ( paste special formulas), but the link to the sheet i am copying from is retained. I need to edit the link via a macro as i have 250 worksheets to go through.
I want to be to edit the link prior to moving to the next work book.
This is what i need to accomplish.. everything is working expect for being unable to edit links
Sub CopyLookup()
Counter = 0
Do While Counter < 250
Counter = Counter + 1
If Counter = 250 Then
MsgBox "Last entry"
Else
Lookup 'this is where the data formula ( which is a vlookup) is being copied
' i would love to be able to edit the link just here.
ActiveWorkbook.Save
ActiveWorkbook.Close
End If
Loop
End Sub
Can anyone please help??:banghead: