Thread: Functions in VBA used in spreadsheet cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JRXPL JRXPL is offline
external usenet poster
  
Posts: 8
Default Functions in VBA used in spreadsheet cell
I have written an extremely simple function in VBA module for sheet 1 and
when I try to use that function in a cell in sheet 1 I get a *Name? error.
Has anyone seen this before? How do I get the function to work?

Function CalculateOne (a,b)
CalculateOne = 2*a + b
EndFunction

--
Thank you,
JRXPL
Reply With QuoteReply With Quote