Input box select range in excel then split range

[Jacques Grobler]

Right, so here is a bit of a challanging one for me.

I would like a user to select a range from an input box, then a sub needs to split the range.

For example, a sub runs, the user selects range:

B2:D19

Then I need the range to be split into:

B3:B19
C2:D2
C3:D19

Thus B2 is actually a dead cell...

Is this possible? and How?

[Jacques Grobler]

For the clever people?

[Jacques Grobler]

Ok, if there is a better way than this, please inform me...

Please Login or Register  to view this content.

[Andy Pope]

You could try the following,

Please Login or Register  to view this content.

[Jacques Grobler]

Hi Andy,

Thanks for the reply but I'm not sure what this code does so I'm not sure of how to implement it.

Can you please briefly explain what it does?

Thank you

[Jacques Grobler]

Bump it up...

[snb]

Although I do not understand what you mean with a 'dead' cell...

Please Login or Register  to view this content.

[Jacques Grobler]

Hi snb,

Where the row and column meets: Cell (1,1), in this cell there is nothing to be used, except that it indicates where the range starts.
That is what I mean by dead cell.

I just had to change your code slightly to work:

Please Login or Register  to view this content.

But it works like a charm, thanks

[Andy Pope]

I thought you just wanted the range of cells excluding the dead cell in top left corner.

This will give you the 3 ranges excluding the dead cell.

Please Login or Register  to view this content.