Selecting a range based on text

Spent85 · Mar 3, 2011

I’m new to VBA, so excuse me if there’s an obvious solution to this problem.

Is there any way to select a range of cells in a spreadsheet based on text? For example, all data between Start and End needs to be selected. I have groups of information that open and close with the same text, but do not share other common characteristic, such as, number of rows, blank spaces, etc. I need to split the groups into different worksheets, but cannot figure out how to select the appropriate ranges.

Any help is appreciated.

VoG · Mar 3, 2011

Try like this

Code:

Sub Slct()
Dim F1 As Range, F2 As Range
Set F1 = Columns("A").Find(what:="Start", LookIn:=xlValues, lookat:=xlWhole)
Set F2 = Columns("A").Find(what:="End", LookIn:=xlValues, lookat:=xlWhole)
Range(F1, F2).Select
End Sub

Spent85 · Mar 3, 2011

VoG -

Thanks for the quick response. The code is pretty close. Do you know why it would be starting the range with "end" and closing with "start", instead of vis-versus? Right now the code is selecting the range between my groups instead of the groups themselves.

VoG · Mar 3, 2011

Not sure. Try posting a sample indicating what should be selected http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

Spent85 · Mar 3, 2011

The shaded areas displayed below are what I want to select. Each begins with "Start" and finishes with "End". I'm planning on splitting each set of data into a new worksheet one at a time. Obviously, I will set a loop starting with the first set of data and running down the spreadsheet, but I'll worry about that later.

Thanks for your input.

Spent85 · Mar 3, 2011

Disregard my last post. VoG - your code is working. It came down to user error.

Thanks for your help!!!

Selecting a range based on text

Spent85

New Member

Excel Facts

VoG

Legend

Spent85

New Member

VoG

Legend

Spent85

New Member

Spent85

New Member

Similar threads

Forum statistics

Share this page

Selecting a range based on text

Spent85

New Member

Excel Facts

VoG

Legend

Spent85

New Member

VoG

Legend

Spent85

New Member

Spent85

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock