Select Rows of MULTIPLE Selected Cells?

Hey there--

I'm relatively unversed in VBA and this could very well be a very simple function that I do not understand. I have found several scripts out there that are able to select the row of a given cell, I've been using the following one-

Please Login or Register  to view this content.

Now, it's my understanding that the ActiveCell is simply the last one selected, so if I attempt to "find all" entries with the year 2012 in them, and then run the above module, Excel will only select the last entry, as it considers this to be the active cell. Is there another term for all other selected cells when multiples are selected?

I'd really appreciate any and all help on this.

Hello Reminisciences,

Welcome to the Forum!

The ActiveCell is defined as the the cell in the upper left corner of a selected Range. To return a Range of all the selected cells, use the Selection object.

To select all of the rows of the selected cells, you can do this...

Please Login or Register  to view this content.

Hello Remy,

Did I answer your question? If so, please mark this post as solved. Thanks.