VBA Macro to find specified range depending on cell contents

[lealea1982]

Hello,

This might be a bit of a tricky one to explain but here goes...

In column A I will have a cell that says, for example "01AStart", and then another (further down the sheet) that will say "01AEnd". I want a macro that will find "01AStart" and then select that row through to "01AEnd" (including those rows).

The number of rows between those two cells will vary at any time and there may be several rows between the two that contain no data at all, but the range that needs selecting must be 01AStart through to 01AEnd.

Can anybody help? Hope it makes sense!!

Thanks

[tigeravatar]

lealea1982,

Give the following a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[tarquinious]

Nice work tigeravatar. I had just written a 10-line macro to do what you achieved in 1.

lealea if you want this to select those cells between start and end, use:

Please Login or Register  to view this content.

[Kyle123]

Hi lealea1982

Taking tarquinious and tigeravatar a little bit further; you said that you wanted to select the rows rather than just the cells, for rows try:

Please Login or Register  to view this content.

[lealea1982]

Perfect! Thanks guys!!