I just want it to behave like it does in excel, just double click on the bottom right corner of the selected box and autofill down to the last data value on the left.

But when i record the macro and look at it it always gives a range.
What should i code to do what i want?

Thanks for all your knowledge,

Chris