How can I make CopyPicture show the selected cell

[xltrader100]

I have one cell selected in the middle of a named rectangular range. How can I do a Copy Picture of the range that shows the selected state of the cell?

[stanl]

something like (assuming the range is selected)

Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicturethe question is what are you going to do next? Stan

[xltrader100]

Thanks, Stan. I have no problem getting the Picture, but the Picture is not showing the selected cell. As for "what are you going to do next", I'm pasting the Picture into a Frame on a Userform, but again, that's not the problem.

I just want the selected cell to appear "selected" in the Picture. I don't select the range before taking the Picture but just reference it by name. Maybe Excel makes a hidden selection of the range before it takes the Picture which would remove the selection from my cell? Anyway, the cell is still selected on the sheet after the Picture is made but it's just not shown.