Good morning baz0912

Quote Originally Posted by baz0912
Do you know of a way I can do this?
Yes, a named range should do the trick. Copy this formula :
=OFFSET(Sheet1!$G$1,0,0,COUNTA(Sheet1!G1:G5000),1)

Now go to Insert > Name > Define.
In the "Names in workbook" box type NotBlank
Delete anything in the "Refers To" box and press Ctrl + V to paste (right click shortcut doesn't work here).
Now click on Add and Close.
In your cell type the formula :
=COUNTBLANK(NotBlank)

This should now return the right formula, and as new lines are added the Name NotBlank should extend with the range.

HTH

DominicB