Active Range?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mturner - 24 Jan 2006 16:18 GMT

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

Signature

mturner

Reply to this Message

Dave Peterson - 24 Jan 2006 16:24 GMT

Use Selection

if selection.cells.count > 1 then
'more than one cell selected
...

> Is there a way of referring to an active selection of cells in vba, like
> you can activecell for an individual cell?
[quoted text clipped - 4 lines]
> mturner's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30147
> View this thread: http://www.excelforum.com/showthread.php?threadid=504516

Signature

Dave Peterson

Reply to this Message

mturner - 24 Jan 2006 16:41 GMT

Thanks, I'll give it a try.;)

Signature

mturner

Reply to this Message