Convert code in a class module to a macro

[Consty1]

In the attached sheet I have a command button which copies filtered information to Sheet2. The functionality of this command button is fine, what I'm trying to do is assign the code as a macro to a normal button that I can edit. Here is the code:

Please Login or Register  to view this content.

Now I'm clueless when it comes to coding but I gather I need to convert the "Me" part of the code to be able to use it in a module as opposed to a class module? If trying to assign it as a macro screws the functionality of the code, is there a way to format the command button (all the format options seem to be greyed out).

I've probably explained that terribly, basically what it comes down to is I want to make the command button more attractive but can't see a way of doing so unless I create a standard button and assign it a macro.

Sample 7 macro.xlsm

[JosephP]

replace 'Me' with ActiveSheet if you want to refer to the sheet that has the button on it

[Consty1]

Hi, thanks for that. That works fine with the sample file but for some reason I'm receiving an error that just says 400 when I use it in my project but this is obviously a separate issue altogether.