Excel: defing a range with a varying size...

Hi there, I need to define a range on a sheet in column A, eg. A1:A15 (15 values) However, the number of values varies depending upon what has been inputted. Is there a way to define the range up to the last cell with a value and discount anything after? If you can point me in the right direction, that's be brilliant. Thanks

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of February 25, 2017.

For more resources for Microsoft Excel