Functions v Procedures

[confusion123]

The main (possibly only) difference between a function and a procedure is a function can return values whereas procedures can't.

Therefore why use procedures at all? Why not just write functions and return values if you want, don't if you don't need to?

 

[RoryA]

Macro dialog, shape, VBE...

 

[Marcelo Branco]

Macro dialog, shape, VBE...

Ok. I was able to run a function without arguments using Macro dialog

Function myFunc1()
    Range("A2") = "Blah"
End Function

But, I could not do it with a function with arguments.

Function myFunc2(r As Range)
    r.Value = "Blah"
End Function

Is it possible

M.

 

[RoryA]

Not with an object, no. You couldn't do that if it were a sub either.

 

[Marcelo Branco]

Not with an object, no. You couldn't do that if it were a sub either.

Ok. Thank you.

M.

 

[JackDanIce]

n/a

 

[thisoldman]

I Learn something new every time I read a post by one of the MrExcel MVPs. Thank you guys.