Thread: How to make a function change other cells in worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_60_] Leith Ross[_60_] is offline
external usenet poster
  
Posts: 1
Default How to make a function change other cells in worksheet

Hello James4U2enjoy,

You need to move the function into a VBA module. Add a VBA module to
your project using the VB editor. Under Insert choose Module, the
default name is Module1. You can rename this to something more
appropriate. The function will now be seen by Excel as a worksheet
macro.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=476109

Reply With QuoteReply With Quote