Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
help needed to convert a sub to a function in VBA
Thanks, is that simple! :-(- mxpmxp
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
help needed to convert a sub to a function in VBA
Hey, thanks for your responses. Andrzejek, yes, I missed to specify the result type, I corrected it, but does not improve the behaviour. SkipVought, apparently it works pretty good but the right result should be "(content of A1)"+"(content of A2)" for example, if A1 = 7 and A2 = 44 then it...- mxpmxp
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
help needed to convert a sub to a function in VBA
Hi I'm a newbie with VBA. I found this macropod's contribution in the Forum and I have tried to convert it to a function but for some reason I'm not getting the same result. I would appreciate your help. The original code: Sub GetRefs() Dim MyRange As Range, strFormula As String, strVal As...- mxpmxp
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
