Multiple iteration of a date stamp

Hi

Can comeone please help? I have the below code to date stamp a cell in column AN only when a cell in column AB equals 0...the trouble is I would like this to work for the entire column without having to keep copy and pasting the code like I have below.

Also if there is any other number in column AB i want it to skip that row, not date stamp in column AB but move to the next row down?? Lastly, once the date stamp is in the relevant cell in column AN I never want it to overtype,

Any help would be greatly appreciated


I am currently using:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks for your help but this doesn't work, the code we have works but we need it to just continue down the entire row of cells. We think this is 'Do Unitl' but are fairly new at VBA...the code is:

Please Login or Register  to view this content.

We essentially want this to repeat in row AB until it reaches the last row??

Many thanks again

it would be something like

Please Login or Register  to view this content.

Please Login or Register  to view this content.

SORRRRRRY