View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mac Lingo[_2_] Mac Lingo[_2_] is offline
external usenet poster
 
Posts: 53
Default Why doesn't ths VBA Code work?

Help!

I can run this code from inside a simple Macro called subroutine with ARG
replaced by a string. But when I put it in another function and call it
from within my own code, I get a 424 Error, "Object required" error. And it
was running until an hour ago. Anyidea what's going on?

Many thanks,
Mac Lingo
Berkeley, CA

================================================== ===========
The Code

Range("A1").Select

Set rng = Cells.Find(What:=ARG, After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate