Hi there,
I would like to use the FIND function in VBA to look for a variable
saying the name is "Cell". The code is:
Range(Range("A1"), Range("A1").Offset(0, MsgNum)).Find(what:="Cell",
lookat:=xlWhole, LookIn:=xlValues, searchorder:=xlByColumns).Activate
However, if this variable name could not be found, I would like to
show a message box.
I tried to use ISERROR, but it doesn't work.
If IsError(Range(Range("A1"), Range("A1").Offset(0,
MsgNum)).Find(what:=TestCellName, lookat:=xlWhole, LookIn:=xlValues,
searchorder:=xlByColumns)) Then
Can somebody please help?
Thanks
Mao
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
