Copy Entire Column Only Returning 1st 16 Rows?

[rwr]

Hello.

I am trying to copy and paste an entire column with VBA. It was working well, then I changed some input cells in another sheet (did not change anything in code) and now it is only pasting the 1st 16 rows of the column. I changed the input cells back and it still did the same thing. I tried copying another column and it only pasted the 1st 16 rows of that column too.

I have tried:

Sheets("Sheet1").Range("a:a").Copy
Sheets("Sheet1").Range("c:c").PasteSpecial

and

Sheets("Sheet1").Range("a1").EntireColumn.Copy Destination:= _
Sheets("Sheet1").Range("c1")

Both only return 16 rows.

Any ideas?

Thanks.

---------- Post added at 11:31 AM ---------- Previous post was at 11:06 AM ----------

So I restarted my computer and I'm not sure why, but it seems to be working fine again.

Sorry for not trying that first.