looping a formula

Hi,

In my data i need to delete all entries by users from NZ. i need the macro to check if the first two letters of the username eqaul "NZ" and if so then delete entire row.

This is what i have got but it keeps giving me an error 424 'object required'.

For n = endrow To 1 Step -1
If Left(Cells(n, 23), 2).Value = "NZ" Then Cells(n, 23).EntireRow.delete
Next n

Any help would be appreciated!

Thanks in advance

Thanks Norie, that did the job.

Sorry about that, will do in the future

Cheers again