Thread: Excel VBA Function Parameter Overwritten
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Melanie Breden Melanie Breden is offline
external usenet poster
  
Posts: 88
Default Excel VBA Function Parameter Overwritten
I need to reuse the values of a and b later on in the sub, hence my
problems with the value of a changing.

do you declared the argument with the keyword ByVal?

Function functwo(ByVal pos As Integer, text As String) As Integer


--
Regards
Melanie Breden
- Microsoft MVP für Excel -

http://excel.codebooks.de (Das Excel-VBA Codebook)

Reply With QuoteReply With Quote