VBA Pasting as picture not as data!!??

SamanthaSkilltec

New Member
Joined
Apr 11, 2019
Messages
20
Hi all

I'm at my wits end so I really hope someone can help!

I have a macro that I recorded that simply needs to copy the content from the active sheet (using copy and paste as I need the command button to copy as well), create a new sheet and paste the copied data there... but it's pasting it as a PICTURE???

I have no idea what I'm doing wrong and I've tried this on two PCs and a laptop but it's always the same.

Please can someone advise before I completely lose the will!!!

TIA

Samantha
Code:
Sub Macro2()
'
' Macro2 Macro
'


'
    Range("A1:AB100").Select
    Selection.Copy
    Sheets.Add After:=ActiveSheet
    ActiveSheet.Buttons.Add(624, 291, 48, 42.75).Select
    ActiveSheet.Buttons.Add(624, 291, 48, 42.75).Select
    ActiveSheet.Buttons.Add(624, 291, 48, 42.75).Select
    ActiveSheet.Buttons.Add(720.75, 20.25, 118.5, 41.25).Select
    ActiveSheet.Paste
    Range("I:I,K:K,M:M,O:O,Q:Q,U:U,W:W,Y:Y").Select
    Range("Y1").Activate
    Selection.EntireColumn.Hidden = True
    ActiveWindow.SmallScroll ToRight:=-10
    ActiveSheet.Shapes.Range(Array("Button 4")).Select
    Application.CutCopyMode = False
    Selection.Delete
    Selection.Cut
    Range("A1:E1").Select
End Sub
 
Last edited by a moderator:

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Paste the copied cells before adding the buttons.
 
Upvote 0
Glad to help & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top