Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. minibebe

    I keep getting type mismatch error!

    Thanks Bob!!! It works now! Amy
  2. minibebe

    I keep getting type mismatch error!

    Hi Bob, Thanks for your help. The error's occuring at the following section: newvar.Find(What:=CGSYM, After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Select Thanks!
  3. minibebe

    I keep getting type mismatch error!

    I have the following code, trying to locate the same symbol in the range named newvar as the range i'm working with now. But even though I can find the symbol using Ctrl+F, the following code keeps giving me type mismatch error. Can someone help? Thanks! Set newvar = Range(Cells(3, 1)...

Part and Inventory Search

Back
Top