Failing to paste to worksheet

[Dryver14]

Ws2.Cells(1, 13).End(xlDown).Offset(1, 0) = TheName

WS2 is set to Sheet7
TheName is a variable that contains something

On active sheet this line works.

What am I doing wrong please.

Heading is slightly wrong, i'm not trying to paste

 

[Dryver14]

Maybe I've explained wrong.

this line fails

Ws2.Cells(1, 13).End(xlDown).Offset(1, 0) = TheName

this line works

ActiveSheet.Cells(1, 13).End(xlDown).Offset(1, 0) = TheName

 

[RoryA]

Does M2 on Ws2 have anything in it?

 

[Dryver14]

Thanks Rory, and no It didn't...now it works.

How do get around this where M1 is the heading

 

[RoryA]

As a general rule, you should go up not down:

Ws2.Cells(ws2.cells.count, 13).End(xlUp).Offset(1, 0) = TheName

 

[Dryver14]

Brilliant.

Thanks for your help.