Copy Entire Column Only Returning 1st 16 Rows?

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:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

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.

Microsoft works in mysterious ways. lol