Hi all, Im using Range("f1").End(xlDown).Offset(1, 0).Select to get to
the next empty cell downwards in a column, It doesnt always work?
sometimes it selects the same cell over and over (im using this in
various instances).

is it something to do with the cell containing a number? also if the
collumn is blank then it crashes out, i have to have a line of 1s above
the column to make the code work.

is there a better way?


Duncan