Command Button Execute Macro Event Upon Click

[huntethic]

I have a command button inserted in an excel worksheet. I want my end-user to click on the button to execute an event. The event I want to execute is copy a growing dynamic range of cells from Sheet1 and paste the table in Cell A1 in Sheet2.

I have created an OFFSET Named Range to count the total number of rows in the vertically growing range in Sheet1 and output that count in Cell A1 of Sheet1. Here is the Sub function I've written to execute the copy paste into Sheet2. The problem - I can't figure out how to execute the event when the commandbutton is clicked...

Please help!

My event code:

Please Login or Register  to view this content.

[Logit]

.
Right click the button.

Select ASSIGN MACRO

Click on the macro name desired.

Click OK

Click on button.