Thread: Object Variable with Block Variable Not set
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
SuitedAces[_18_] SuitedAces[_18_] is offline
external usenet poster
  
Posts: 1
Default Object Variable with Block Variable Not set

Bob I tried making it public and I get the same error.

Baffling to me *PUBLIC* seems like it should be *PUBLIC* but I gues
not.

The help says the variable might not be set but it is set and is
demonstated to be set in the ManualSwap procedure because
the cell text changes.

No attempt I have made to pass the variable will work either.

Very aggravating

--
SuitedAce
-----------------------------------------------------------------------
SuitedAces's Profile: http://www.excelforum.com/member.php...fo&userid=3584
View this thread: http://www.excelforum.com/showthread.php?threadid=55735

Reply With QuoteReply With Quote