"hurriancep" wrote
in message ...

I should write a macro to get the data range from user.
Now I am using "Inputbox" to obtain the range of data.
However, I thnk it is unconvinient.
So could I get the range by highlighting the related cells by using
macro.

Use Application.InputBox and set the Type parameter to 8

Robert