Using the Find command

[NathanW]

Hello,

I seem to be having some troubles using a find command in vba. Here's what I have:

ActiveSheet.Range("B16:AI68").Find(What:=":", LookIn:=xlFormulas, After:=ActiveCell, _
        LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
        MatchCase:=True, SearchFormat:=False).Activate
[\code]

I'm getting the "type mismatch" error. Any ideas how to fix this? Any responses are appreciated!

 

[VoG]

Guessing

Range("B16:AI68").Find(What:=":", LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=True, SearchFormat:=False).Activate

 

[NathanW]

That did it! Thank you very much =)