Posted to microsoft.public.excel.programming

joeu2004[_2_] joeu2004[_2_] is offline

external usenet poster

Posts: 829

ByRef v ByVal

"Jennifer Murphy" wrote:
It is my understanding that I should use the ByVal
keyword if I am planning to modify the parameter.
Is that correct?

It depends on your objectives.

Yes, use ByVal if you do not want the caller to see the change.

No, use ByRef (default) if you want the caller to see the change.

The latter is not unusual.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ByRef vs ByVal	Grd	Excel Programming	2	May 11th 07 08:23 PM
ByRef strangeness	Nicklas Karlsson	Excel Programming	2	October 17th 04 07:36 PM
byref errors	Ryan H.	Excel Programming	12	August 4th 04 04:44 PM
ByRef question	Tommy Flynn[_2_]	Excel Programming	2	November 12th 03 01:35 PM
Is ByVal always better if ByRef isn't necessary	Jeff[_17_]	Excel Programming	5	July 25th 03 09:25 AM

All times are GMT +1. The time now is 06:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us