mysheets

So I am currently trying to adjust a workbook so on a single button press, it will copy the current worksheet and add it as the next worksheet and rename it "Client Location N" with only the format pasted in. It will also copy and paste another worksheet to the end, that has basically the same...

Hi, I'm trying to copy an array of sheets into a new workbook but getting run-time error (method copy of object sheets failed) with following: Sub Main() Sheets(Array(Split(MySheets, "|"))).Copy End Sub Private Function MySheets() as String MySheets = "Sheet1|Sheet2|Sheet3" End Function...

I'm trying to cleanup a colleagues spreadsheet and create a New Row button, but also want to keep the formulas in the required fields above. The below formula creates the new row with formatting from above, but does not copy the formulas. Do I have to embed the formulas into my macro or is...

Hope Everyone is well, I'm trying to do something very simple - I am using the code below to add a new row on the top row by clicking a Command Button. I'm having a hard time also including the format, some cells on the row have to be a specific format (Text, Date, Currency, Center aligned...