Script not copying data from "Emails" sheet to "New Sheet" - Run time error: Object

I am currently working on a script that will copy some data from one sheet to another, but I keep getting the following error message:

Run time error: Object required

at

Set uRng = .Range("F1", .Range("F" & .Rows.Count).End(xlUp))

What could be causing it?

Code below:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Emails is nothing.

Please Login or Register  to view this content.

Originally Posted by zbor

Try:

Please Login or Register  to view this content.

It doesn't work - I managed to remediate this problem by doing the following but the data won't copy to a new spreadsheet:

Please Login or Register  to view this content.