Activecell, not for cell,but for range?
 

Is there a way of referring to an active selection of cells in vba, like
you can activecell for an individual cell?


--
mturner
------------------------------------------------------------------------
mturner's Profile: http://www.excelforum.com/member.php...o&userid=30147
View this thread: http://www.excelforum.com/showthread...hreadid=504515

Activecell, not for cell,but for range?
 

You can use Selection when you know nothing else can be selected (like a
picture). Or ActiveWindow.RangeSelection which should always work (as long
as there is an active window).

--
Jim
"mturner" wrote in
message ...
|
| Is there a way of referring to an active selection of cells in vba, like
| you can activecell for an individual cell?
|
|
| --
| mturner
| ------------------------------------------------------------------------
| mturner's Profile:
http://www.excelforum.com/member.php...o&userid=30147
| View this thread: http://www.excelforum.com/showthread...hreadid=504515
|