Hi there, this is my first post

I am using Excel 2010 in a Citrix environment and I have code that selects a range and copies it as a Bitmap, ready to copy in PowerPoint

Application.screenupdating = True
Range("A9:N" & prow).Select
Selection.Copy
Selection.CopyPicture Appearance:=xlPrinter, Format:=xlBitmap

however the code errors out with a 1004 error. Note prow is a row counter variable

If the code is replaced with
Selection.CopyPicture Appearance:=xlPrinter, Format:=xlPicture
it seems to work, but the quality of this picture image is poor, relative to the bitmap which I am wanting.

I have just read on a forum page indicating that this issue may be caused by a conflict between Office 2010 (32 bit) and Windows (64 bit) but this is beyond my knowledge scope at present. Sorry I am unsure how our company systems are set up with the 'bit' stuff.

Can anyone help explain and help me find a solution to get the higher quality Bitmap I am wanting.

Thanks Ken