Is there a way of referring to an active selection of cells in vba, like you can activecell for an individual cell?
Is there a way of referring to an active selection of cells in vba, like you can activecell for an individual cell?
Use Selection
if selection.cells.count > 1 then
'more than one cell selected
....
mturner wrote:
>
> 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=504516
--
Dave Peterson
Thanks, I'll give it a try.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks