Forum Discussion
Automatically paste cell range when a new worksheet is created
I have a group (range A2:U74)of formatted cells and I want that each time a new sheet is created this group of cells to be pasted, the the user can fill the "table" with values. https://i.imgur.com/...
Hi x12356
Try this code:
Sheets("Sheet1").Range("A2:U74").Copy
Sh.Range("A2").Select
ActiveSheet.Paste
You could hide and protect Sheet1 to make sure that the user can't delete it