Copying Button when copying cell

Hi,

Thanks for the quick response. If I copy the cell manually or with a basic macro, though, the button in that cell pastes with the copied cell. It must somehow recognize that there is a button in the copied cells, no?

If there isn't a way to do this with a private sub and I did have to select a specific button, is there a way to move the button with respect to the cells rather than by pixels(or whatever unit is used)?

I'd like to copy a cell with a button in it and paste the new cell with a copied version of the button in it.

Essentially I'd like to copy the button.

Hi,

I'm still not completely satisfied with that option but I really appreciate your help. I think I've found a work around. Unfortunately, I couldn't find anything through the user form. I ended up just adding in another macro after the user form is complete, to copy the cell and the button.

Cheers

Hi,

Using the code you've provided, is there a way to set the destination cell relative to a command button that is controlling the macro? Essentially, I would like to copy a button from cell "Q8" and paste it two cells to the right of the command button I have pressed. This command button could be in any cell so it would be great if I could paste the new command button relative to the called button.

I've tried the following code but I get a run-time error that I don't quite understand. The only parts that I've changed are the "Set sourceRange" and Set destinationRange".

Please Login or Register  to view this content.