Select current selection to row 16

I know it's probably simple. I just need code to select the range of cells from my currently selected cell or selection up to row 16 for example.

Thanks in advance!

Please Login or Register  to view this content.

Hi,

Here is a simple, logical way to do that:

Please Login or Register  to view this content.

But perhaps all of this is unnecessary... if you give us the big picture we might be able to suggest a better approach?

This command will deal with 2 dimensional selections i.e. multiColumn with multiRows ( i had trouble with shg's sol'n when in came to 2 dim selections) HOWEVER... the assumption is that the selection area is below row 16.

Please Login or Register  to view this content.