Sub setselect()
Application.InputBox(prompt:="Select Something", Type:=8).Select
End Sub

This is like a pause that allows the user to select a range (either mouse or
typed).

You can then sort the Selected range.
--
Gary''s Student - gsnu200786


"Yngve" wrote:

Hi

Is ther a way to check selection before I sort a sheet, I need to do
it on the fly


Thank

Yngve