What happens if a function returns a value but you don't have a variable to capture it?

**dmasters4919** · 06-30-2015, 01:16 PM

I was expecting to get an error when running this line because the Find method is supposed to return a Range object, and I don't have a "Set x = " in front of the function. However, it keeps going without issue. What's the logic behind this?

Please Login or Register  to view this content.

**stephenloky** · 06-30-2015, 01:30 PM

Nothing happens, theorically it's a valid syntax,that's why no errors. But for real uses you need to assign it to a variable.

What happens if a function returns a value but you don't have a variable to capture it?

LinkBack

Thread Tools

Rate This Thread

Display

What happens if a function returns a value but you don't have a variable to capture it?

Re: What happens if a function returns a value but you don't have a variable to capture it

Thread Information

Users Browsing this Thread

Similar Threads

Max Func returns Variable name

Capture variable from part of cell formula

[SOLVED] How to capture a Property as a variable

[SOLVED] How to use function that returns array of variable size?

[SOLVED] Query that returns a value to variable

Bookmarks

Bookmarks

Posting Permissions