<p>I need to copy a set of rows from one tab to another tab of the same Excel document by just clicking a button. </p>

<p>Also, can I also get information on how can I copy a set of rows that are hidden and paste it in the same tab without copying the "hidden" format?</p>

If 'Copystart' is your original rows, and 'Copyend' is where you want to paste them, then using named ranges:
```
```
Sub Copybutton_Click()

Range("Copyend").value = Range("Copystart").value
Range("Copyend").visible = True

End Sub
```
```
If you have multiple named ranges with the same name, then add [Sheetname]. in front of the range, where Sheetname is the name of the sheet that the named range is in that you want to reference.