Using selected values in macro

[Drewbie57]

This is simple, I know. I need to use the selected value in a macro. It would be best in my case to set it to a range DIM. What would be the code to do that? Thanks.

 

[Andrew Poulsom]

If you want to use a Range object variable, the:

Dim Rng As Range
Set Rng = Range("A1")

Note the use of the Set keyword, which must be used to assign objects to variables.

 

[TommyGun]

Here ya go...

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> SetSelectedRange()

<SPAN style="color:#00007F">Dim</SPAN> r <SPAN style="color:#00007F">As</SPAN> Range
<SPAN style="color:#00007F">Dim</SPAN> v <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Variant</SPAN>

<SPAN style="color:#00007F">Set</SPAN> r = ActiveSheet.Selection
v = ActiveSheet.Selection.Value

<SPAN style="color:#00007F">Set</SPAN> r = <SPAN style="color:#00007F">Nothing</SPAN>

<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>