View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default passing targets between functions

Hi Chip,

Sure you can. Objects are always passed ByRef. The ByVal/ByRef
keyword in the argument list indicates how the pointer to the
object is passed. If ByRef, the called procedure can change the
object to which the argument points. If ByVal, the called
procedure cannot change, in the calling procedure, the object to
which the argument points.


Duh, silly me. Go and read the manual again, Jan Karel! <g

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com