Savepicture

[Wike05]

I found this code on a website and that will copy a range as a picture. I
also need it too save it as a picture on our network. Can you help?
Worksheets("Sheet1").Range("A312").CopyPicture _
Appearance:=xlScreen, Format:=xlBitmap

 

[XP]

Not sure which version of XL you are using, but you could turn on the macro
recorder and print to a .tif. Set the printer name to MODI (Microsoft
Document Image Writer) and pick your file destination.

HTH

 

[Wike05]

Excel 2002

Not sure which version of XL you are using, but you could turn on the macro
recorder and print to a .tif. Set the printer name to MODI (Microsoft
Document Image Writer) and pick your file destination.

HTH