wh.rangeh1.value

  1. M

    Copy sheet based on cell value, but if this value exits in sheets don't create it

    Hi, I'm trying create a copy of the active sheet and name it based on a cell value ("H1" is text January) using a command button. This works fine. But the problem i run into is that when the name already exist I get an error 1004. Then it creates a copy of the sheet name like "test (2)". What...

Some videos you may like

This Week's Hot Topics

Top