Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete all Links via VBA
How can I delete all links/range names within a range of sheets? I
extract and Copy Paste Special values via below, but it retains links to the source document (which I don't need) Thanks Sourcewb.Sheets(Array("Report1", "Report2", "Report3")).Copy Set Destwb = ActiveWorkbook For Each sh In Destwb.Worksheets sh.Select With sh.UsedRange .Cells.Copy .Cells.PasteSpecial xlPasteValues .Cells(1).Select End With Application.CutCopyMode = False Destwb.Worksheets(1).Select Next sh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete all Links via VBA
In article s.com, Seanie writes How can I delete all links/range names within a range of sheets? I extract and Copy Paste Special values via below, but it retains links to the source document (which I don't need) Thanks Sourcewb.Sheets(Array("Report1", "Report2", "Report3")).Copy Set Destwb = ActiveWorkbook For Each sh In Destwb.Worksheets sh.Select With sh.UsedRange .Cells.Copy .Cells.PasteSpecial xlPasteValues .Cells(1).Select End With Application.CutCopyMode = False Destwb.Worksheets(1).Select Next sh Instead of the line - ".Cells.PasteSpecial xlPasteValues" try this - ..Cells.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False It worked for me on a similar project. Cheers -- Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete All Links to Worksheet | Excel Worksheet Functions | |||
Delete Links | Excel Discussion (Misc queries) | |||
how can i delete external links from my workbook | Excel Discussion (Misc queries) | |||
I can view links, but can't delete them | Links and Linking in Excel | |||
Delete links | Excel Discussion (Misc queries) |