Button to copy from - to ?

[Tartesos]

I was wondering if there is a way to add a button on a sheet that will do the action of copying a number of columns and rows determintade by me.
Is this possible?
How?


Thanks

 

[craig.penny]

It's definitely possible. Write the code, insert a shape, right click on the shape, go to "Assign Macro", and click on the sub you wrote.

Does that answer your question?

 

[Tartesos]

Well, I can do all that I just need the Code ... there is a databases where I can find standart codes for this actions ??

Thanks

 

[craig.penny]

Have you recorded a macro? You can do that to get a basic idea of the code and then alter it for your button.

Click on record a macro, do your actions, click stop recording then go into the editor to look at the code.

If you have difficulty adjusting the code, post what you have here with a description of how you want to change it.

 

[Tartesos]

thanks man, i did that and works great.

Regards.

 

[craig.penny]

No problem!