Copy a table and paste as image, Shows grid line around empty cells

[Skeeta]

I have a table that is generated from a Macro. The table has borders around the data. I have a 2nd macro that then copies the table (there are hidden colums so first I "go to special and select visible cells only") and paste's it into a proposal as an image. The only issue I have is the macro grabs a couple of blank rows when it selects the data. When the image is pasted into the proposal, those rows show up. It's as if they have gride lines around them. But the original table has show grid lines turned off. Those blank cells look awful on the proposal. Any help would be appreciated.

[Ace_XL]

Perhaps..You could uncheck the 'gridlines' box on the 'view' tab before executing the macro

[dogberry]

Hi

No idea how to solve your problem but until someone can a work round is the camera function in excel take a snapshot of it and see if you get the same result you can find camera in excel options customise ribbon then select commands not on the ribbon its almost at the bottom of the visible screen

Chris

[Skeeta]

This worked. Thank you!