Macro--userinput
 

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.


--
hurriancep
------------------------------------------------------------------------
hurriancep's Profile: http://www.excelforum.com/member.php...o&userid=31358
View this thread: http://www.excelforum.com/showthread...hreadid=510518

Macro--userinput
 

"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

Macro--userinput
 

Hi
Use a Userform with a RefEdit control from the Control Toolbox. This
allows you to select a range using the mouse while the form is visible.
The value of the RefEdit control is the address selected as a string
which you can use in code as Range(SelectionString) for example.

regards
Paul

hurriancep wrote:
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.


--
hurriancep
------------------------------------------------------------------------
hurriancep's Profile: http://www.excelforum.com/member.php...o&userid=31358
View this thread: http://www.excelforum.com/showthread...hreadid=510518