satyen
03-24-2010, 07:59 AM
Hello,
I get a type mismatch error when writing this line of code. I'm doing something wrong and I can't figure it out. ! Please can someone point out my mistake. Thanks.
Range("A:A").Find(What:="My Tables", After:=ActiveCell, LookIn:=xlFormulas _
, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Select
I get a type mismatch error when writing this line of code. I'm doing something wrong and I can't figure it out. ! Please can someone point out my mistake. Thanks.
Range("A:A").Find(What:="My Tables", After:=ActiveCell, LookIn:=xlFormulas _
, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Select