VBA function to change multiple cell values?

**Econdoc1** · 06-22-2010, 08:17 PM

In each row of a spreadsheet, I need to simultaneously calculate three different values based on values in that row. A UDF seems like the proper way to go, something like =MYFunc(a,b,c). However, a function can only return a single value. I have "solved" my problem in an inelegant way, namely =MyFunc1(a,b,c), Myfunc2(a,b,c), Myfunc3(a,b,c), where each function is in its own column/cell. There must be a simpler way! To be clearer, the arguments a,b,c are not the values that are calculated by the function. I need to do this in multiple rows.
Any suggestions are welcome. Thanks in advance.

**shg** · 06-22-2010, 08:22 PM

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

**Bob Phillips** · 06-23-2010, 03:13 AM

You could return an array, something like

Public Function myFunc()

    myFunc = Array(1, 2, 3)
    
End Function

SO you select three cells, say M1,N1 and O1, enter =MyFunc() in the formula bar, and array enter it.

Thread: VBA function to change multiple cell values?

Thread Tools

Display

VBA function to change multiple cell values?

Re: Newbie VBA function question

Re: Newbie VBA function question

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions