Copy range and ignore the hidden range

Use PasteOption to control whether to copy hidden range or not.