Find cell

**Verbamore** · 06-17-2014, 05:32 PM

Good afternoon everybody!
i am trying to create a VBA Code for finding a text but i don't want the code to search through all sheet.
Is there any way to tell VBA to search in specific rows, for exp the first?
Usually i use the fist row to title the columns so i want to search by the head columns.
Let's assume that i want to find and select the cell with the text "Account Number".
I use this code but this goes to all the cells:

    Cells.Find(What:="Account Number", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
        False, SearchFormat:=False).Activate

DO YOU GUYS HAVE A BETTER IDEA?

Thanks in advance for your help

**shg** · 06-17-2014, 05:43 PM

Rows(1).Find(...

**Verbamore** · 06-17-2014, 10:21 PM

Thanks man, but it doesn't work.

**Sa DQ** · 06-17-2014, 10:34 PM

PHP Code:


Option Explicit
Sub Macro1()
 Dim Rng As Range, sRng As Range
 
 Set Rng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants, 2)
 'MsgBox Rng.Address'
 Set sRng = Rng.Find(". . .", , xlFormulas, xlPart)
 
End Sub

**jolivanes** · 06-18-2014, 12:53 AM

Thanks man, but it doesn't work.

You have to do some things yourself also.

Rows(1).Find(What:="Account Number", After:=Cells(1, 1), LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate

**Verbamore** · 06-18-2014, 10:26 AM

thanks to all of you guys

Find cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Find cell

Re: Find cell

Re: Find cell

Re: Find cell

Re: Find cell

Re: Find cell

Thread Information

Users Browsing this Thread

Similar Threads

Use a specific cell reference to find and overwrite that row(Find and Copy).

Find blank cell, insert formula to find median of above cell range

[SOLVED] Trying to find a formula to find a random $ amount in a text in a cell

[SOLVED] Find match, find related cell and return that number

Range.Find to find column and place value in next available cell in one line

Bookmarks

Bookmarks

Posting Permissions