Assigning a Macro

[Jack-P-Winner]

well, I have been doing this for a while and I guess my brain is in lock mode.

How do I assign a Macro? I have a sheet that I need to link up and I need to assign the Macro to a sheet and I an not seem to remember how to do so

If I can get a step by step. I have either Excel 2010 or 2013

Thanks

 

[chirayu]

When you say assign to sheet what exactly do you mean? do you mean run the macro on a specific sheet? if that's the case you need to add the Worksheets function before the Range function:

Worksheets("Sheet1").select
Range("A1").select

 

[Jack-P-Winner]

Never mind, I got it sorry, needed coffee LOL

 

[Jack-P-Winner]

I had a clear button I needed to assign