Error using macro to copy-paste checkboxes.

[Kari001]

I'm running into an error when trying to use a macro to copy a checkbox from one cell and paste it in another cell. "Run-time error '1004': The item with the specified name wasn't found".

Can someone help me please?

Sub Macro13()
'
' Macro13 Macro
'

'
    ActiveSheet.Shapes.Range(Array("Check Box 19")).Select
    Selection.Copy
    Range("H60").Select
    ActiveSheet.CheckBoxes.Add(573.75, 1569, 19.5, 22.5).Select
    ActiveSheet.Paste
    ActiveSheet.Shapes.Range(Array("Check Box 163")).Select
End Sub

 

[Tom Urtis]

This code looks odd for a few reasons. But one question pops out which is, why, if you are copying a checkbox, are you adding another checkbox and then pasting the check box you copied.

Can you re-explain your situation, for example, can you say, without the code, the essence of what you are doing. For example, are you trying to copy a particular checkbox which might be located in a reliable place (maybe it won't be but that is part of the explanation needed), and are you pasting it somewhere else, if so, where else.

Probably the specified name was not found because the names of the checkboxes you reference (19 and 163) are really named something else. Please specify what kind of checkboxes they are -- created from the Form menu or are they activex checkboxes. This is an important point because in a new fresh workbook for example, when you add a check box from the Form menu, its name will be Check Box 1 whereas from the ActiveX menu the name will be CheckBox1 without any spaces in the name.

 

[Kari001]

The whole error was with that line, thank you so much for pointing it out. Everything works as it should, problem solved.
When using the 'Record Macro' to record a simple copy-paste of a checkbox this line will be generated and it will not work, removing it solves the issue.
Again, thank you very much.