VBA Area Selection

**ewill** · 06-15-2010, 06:13 AM

I want to select an area from a list of data by finding the name of the first item, then running to the next blank cell. Can anyone tell me how to do this within visual basic?

**davesexcel** · 06-15-2010, 07:14 AM

Try This,

Sub FindAndSelect()

    s = InputBox("Find Something")

    Columns(1).Find(What:=s, After:=Cells(1, 1), LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _
                    SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate
    Range(ActiveCell, ActiveCell.End(xlDown)).Select

End Sub

VBA Area Selection

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA Area Selection

Re: VBA Area Selection

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions