This may well be a very daft query! I am writing a macro which
analyses data imported to a spreadsheet. The problem is that it is
carrying out analysis on all cells in a column. However, I want to
follow the progression:

1) Is there a data value in Column A, row X?
2) Use that value to calculate the value for Column P, row X
3) Otherwise, move on to row Y.

I've tried If....Then and Do While.... but I don't know how to
specify point 1). How do I persuade the programme to see whether
Column A, row X is empty or not?

Many thanks,
Helen