Copy Range in Excel Tip

[larrykathy]

You've created a named range on an Excel worksheet. You have placed photos into the specific range. Now how do you copy everything in that range to paste them into another workbook?
Very easy!!!!
1. Select the named range
2. Hold down SHIFT and click Copy Picture on the Edit menu
3. Open your other workbook and Paste.

See help in Excel for additional help in this area.

KyleS may remember us struggling with this.

frmDBConcern.OLE1.object.Application.Goto Reference:="PhotoRange"
frmDBConcern.OLE1.object.Application.Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture
Later
Larry

 

[SkipVought]

Larry,

Did you post this is the correct forum?

1) This is MS Access - Your idea refers to MS Excel.

2) This is VBA coding - There is no VBA coding.

Apart from that, one can do the same thing

a) without a named range and

b) without the CopyPicture feature, unless there are some other factors that you did not include.

Skip,

_[red][/red]