Hi all

I am trying to write a macro, and can not seem to find how to do this

Basically, I have an Input Box that sets the begining of a range, but I would like to automatically detect the last data filled cell in the same row (i.e. StartRange is (say) A2, and the last cell with data in is (say) C2

How would I do this, so is actually selects this small range so I can carry out a further function on it?

Thanks