| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Like this:
Option Explicit Sub PastPicLink() Range("A1:T50").Copy ActiveSheet.Pictures.Paste(Link:=True).Select Application.CutCopyMode = False End Sub I don't know what you mean by copying it to a new file, an Excel file? Quote:
__________________
Justin Labenne www.jlxl.net |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link a picture to a text cell | Excel Discussion (Misc queries) | |||
| Macro to link Sheets to main workbook | Excel Discussion (Misc queries) | |||
| Link a picture to data | Excel Discussion (Misc queries) | |||
| Copying a workbook with custom toolbar assigned to a macro | Excel Discussion (Misc queries) | |||
| copying text into a macro | Excel Worksheet Functions | |||
Threaded Mode
