Finding Last Row and Using to Copy

[Mike_e]

Hi, I'm looking to do something fairly simple. This involves copying a variable list of names from column A on Sheet1 to B1 on Sheet2. Here's the code I'm using..

Please Login or Register  to view this content.

Whenever I run this, I get a Type Mismatch error. I'm sure it can only be something basic but it's got me quite stuck. Can you help please?

[Norie]

It should be .Range("A1:A" & LastRow) instead of Cells.

[Mike_e]

Many thanks...my excel ignorance knows no bounds....

[Tejas.T]

Hello Mike_e,

Here is the simplified code for your requirement

Please Login or Register  to view this content.