Macro - For copying columns from one sheet onto another is failing and instead insterting a Picture???

[thorxes]

I have a sheet made into a form with some check boxes included. If I select all the relevant columns, create a new sheet, and paste into cell A1 - all of the information carries over just fine. You can still select cells and check the boxes in the new sheet.

However, when I record this action as a macro, using the macro produces a picture of the selected columns instead of actually copy/pasting the information. I can't click on the cells or check boxes. I can only move the picture around within the new sheet.

Does anyone know why this is happening?

 

[Redwolfx]

If I were to guess I'd say the macro is using PasteAll. I'm not sure if it will work, but try to just Pastespecial

 

[thorxes]

If I were to guess I'd say the macro is using PasteAll. I'm not sure if it will work, but try to just Pastespecial

ActiveSheet.Paste

This is the vba code used in the macro.

What do you recommend I use instead?

 

[Redwolfx]

Can you paste your Macro?