Copy Inactive Worksheet using pre-defined data

Thank you -

Hello Mumps,

I hope you are well and don’t mind reaching out - I figured I reengage you as you’re most familiar with this workbook.

In the attached workbook, I need to make a change to one of the “names” – instead of using the name “Avaya Virtual Host #” – I need to drop the word Avaya and go with just “Virtual Host #”. When I make the change to the command button 1 code, the macro runs just fine when I enter any QTY of hosts the first time. It copies rows 27:37 and pastes them below and updates the numerical identifier for that particular host. When I try to go back and add additional hosts I get a run-time error 13 “type mismatch”. I looked at the debugger and can’t figure out why this is not working when the only thing I’ve changed is the name from “Avaya Virtual Host” to “Virtual Host” throughout the code.

Any help is greatly appreciated.

Thanks

Hi Roy, Will do - this is somewhat a complex WB so I figured I'd start with someone who helped with the original code. Will start a new thread - thanks