Rather than using the range function to select multiple cells, ie:

Range("A1:B6").Select

Is there a way to use - Cells() instead. This is because the number of cells
will change.

Thanks