thanks for the code part. unfortunatly i cannot arrange the empty (blank) cells at the top as the sheet is being used for calucations.

can i not use a IF statement.

IF an empty/black cell is found then use the formula, if the cell has any information move down tot he next row?