Quote Originally Posted by daniel_d_n_r
whats this?

[vba]If Evaluate("=isblank(name)") = False Then GoTo Non
[/vba]
Evaluate is just that. Evaluates the contents of a cell. isblank is evaluating if the contents is blank in cell. (name) is the name of the cell. i.e. changed from c15 to name.
NON is a label that it jumps to if it is found to be false.