Thread: How to get a UDF to ignore all sheets but its own?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Darren Hill[_3_] Darren Hill[_3_] is offline
external usenet poster
  
Posts: 68
Default How to get a UDF to ignore all sheets but its own?

Thanks, that does the trick perfectly. Thanks again :)

Darren

On Sun, 8 May 2005 11:54:55 +0100, Bob Phillips
wrote:

Change

Set mySheet = Activesheet

to

Set mySheet = Application.Caller.Parent




--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
Reply With QuoteReply With Quote