Export Image Issues

All-

I am using the below code to export an image of a range. It works perfectly, except for the fact that it comes out as a picture of my range over top of a chart of the data in the range.

How do I do get this to only export the picture of the range?

Any help would be greatly appreciated!


Code:

Sub RangePic()

Worksheets("NewRepScoring").Range("A1:Q17").CopyPicture xlScreen, xlBitmap

Application.DisplayAlerts = False
Set oCht = Charts.Add
With oCht
.Paste
.Export Filename:="\\portal\DavWWWRoot\cwie\sales\business\QA%20Pages\RepDashboard.png", Filtername:="PNG"
.Delete
End With
End Sub

I guess you got the idea from like this: http://www.jpsoftwaretech.com/export...re-file-redux/

Try adding a sheet via code, do your thing, and remove the sheet.

If you don't mind BMP files, with a reference to the Microsoft Forms 2.0 Object Library.

Please Login or Register  to view this content.

Thanks for your help! However, I'm not sure I follow completely.

I tried your code and it buts a line break between the const and the beginning of the Sub. then gives me a Run-time error '424' and highlights the 'SavePicture' line.

Is there something I'm missing?

Did you add the reference to the Forms object from VBE's Tool's menu?

reference to the Microsoft Forms 2.0 Object Library

AlphaFrog -

That worked perfectly, brilliant!! Thank you both for your help.

Kenneth-
I'm a bit of a VBA newb so I did not follow your instructions properly regarding the microsoft objects library. I will try that when I have time as well though. Your assistance is greatly appreciated.

Great! When ready, explore the many tutorials for learning like this one to set a reference. http://excel-macro.tutorialhorizon.c...es-vbaproject/