Just a follow on i need it to do it for all the rows in the worksheet.
Thanks again

greg
"Greg" wrote in message
...
Hi all,

How do I write the code for the following. I need a vba to look up the
value in column "a" on a sheet called "reg". If the cells value is
greater than 1 i need in column "g" to input this code .

=IF(A2 500,"yes","no")

I want this to show the row number it is on instead of "a2" it might be
a31 or something

Any help would be great as I have no idea how to do this

Thanks

Greg