I need to identify and highlight the last row of data in my worksheet, and
extend the whole row down by one row, to capture any new data that might be
available.

How can this be written in vb code? (I need to incorporate this step into a
macro, which will then be run every week with the source data also being
updated weekly)

Many thanks in advance.