Print Area

[Guest]

Yes, your right. That whole loop ends up just giving you the used last row
in column A from what I can see. Not sure why the loop is even there.

 

[Guest]

Possibly
for i = 1 to 50
if cells(i + 39) > 0 then cells(i + 39,"N").Value = 1
Next


if you want to quit the first time the cell is not > 0 then

for i = 1 to 50
if cells(i + 39) > 0 then
cells(i + 39,"N").Value = 1
else
exit for
end if
Next