Attempting to copy and paste rows 1 to 8 from one worksheet to another. I am able to copy, however when I try to format the copied range I am receiving an error. I am using the following code.
Thank You
Sub copyrows()
Dim rng As Range
Set rng = Rows("1:8")
rng.Copy...