Make this code column specific?

Roy Roy Roy Roy,

what would i do without you? probabbly be jobless mate.

Top work as ever Buddy

Hi Roy

'clear only cell in A
               Sheets("Teams left").Cells("A" & j).ClearContents

for some reason the code does not work and this line is highlighted when i try and Debug the code.

PLease help (Hands in the prayer position)

Try to change so your code:

Sheets("Teams left").Range("A" & j).ClearContents

or

Sheets("Teams left").Cells(j, "A").ClearContents

Regards,
Antonio

Antonio Your a top man,

i been messing with that code for ages too

Thanks very much!!