I have a macro that when it runs checks a column to see if there's a name on it, if there is, it generates a report.
it's a while loop that goes until the last name in that column. How can I check to see if a particular cell is empty?? I tried checking against = "" or ='' and it didn't work.
to make it work, I added the word END after the last name on that particular column.... in my while loop I simply check to see if name = "END" and then it stops.
ex: 
Please Login or Register  to view this content.
this is a patch to make it work but I would like to be able to check simply if the cell is empty... I'm sure it's something real simple..but I don't know what it is ...so I'm stuck

thanks

PAbs