Only look in column A might be a start

Cells.Find(WHAT:="EXT"

would be

Columns(1).Find(WHAT:="EXT"

--
Regards,
Tom Ogilvy

"alexm999 " wrote in message
...
Here's my code:
Set ofound = Cells.Find(WHAT:="EXT", _
After:=ActiveCell, _
LookIn:=xlFormulas, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=True)
If Not ofound Is Nothing Then
ofound.Activate
If Trim(ofound) = "EXT" Then
ActiveCell.Offset(rowOffset:=0, columnOffset:=4).Activate
Selection.Copy
Windows("BOOK1.XLS").Activate
Range("D3").Select
ActiveSheet.Paste

I want to find the word EXT in column A only, how do i narrow my search
down????? here is another EXT in Column C that it is referencing. I need
column A...


---
Message posted from http://www.ExcelForum.com/