To find only in column A

[Adrac]

Hello Gang,

I haea psrt o a script that looks for word in the whole sheet. Ca anyone suggest how I can look oly n column A:A

Selection.Find(What:="Queue Group:",after:=ActiveCell,LookIn:=xlalues,_
LokAt:=xlPart, SearchOrder:=lByRows, SearchDirection:=xlNext,_
MatchCase:=False).Activate

Adrac

 

[Andrew Poulsom]

Select column A before running that code.

 

[VoG]

Try

Dim found As Range
Set found = Columns("A").Find(What:="Queue Group:", LookIn:=xlValues,LookAt:=xlPart)
If Not found Is Nothing Then found.Select

Note: there were several typos in your code.

 

[Adrac]

Great thank you, I had to type out the code as my C&P wasn't working for some reason but its correct in the script lol

Tanks guys I shall try this out and let you know

Adrac

 

[Adrac]

Andrew - I noticed the script was selecting A:A but found row 1 was merged so it was checking all the sheet. Corrected this now in the script and all works fine,

Thanks both of you

Adrac

 

[Oeldere]

And that also proves you don't have to work with merged cells.

You get in trouble with it sooner or later, (in you case sooner).

Nice you could solve this on your own.