Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom function to return output in multiple cells
I'd like to write a function that returns more than one value, which I'd
like to be displayed in multiple cells. Is it possible? If not, what's the nearest thing I can do? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom function to return output in multiple cells
Public Function ArrList(rng as Range)
Dim varr as Variant Dim i as long varr = rng.Value for i = lbound(varr,1) to ubound(varr,1) varr(i,1) = varr(i,1)*i Next ArrList = varr End Function select cells C1:C10 in the formula bar enter: =ArrList(C1:C10) end with Ctrl+Shift+Enter rather than just enter to array enter the formula. -- Regards, Tom Ogilvy "Asif" wrote in message ... I'd like to write a function that returns more than one value, which I'd like to be displayed in multiple cells. Is it possible? If not, what's the nearest thing I can do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting multiple conditions to return a figure from multiple cells | Excel Discussion (Misc queries) | |||
Function evaluate multiple cells and return 1st one w/a value | Excel Discussion (Misc queries) | |||
auto filter doesn't return cells containing the custom search wor. | Excel Worksheet Functions | |||
Can a function return a Null (blank ) value? Maybe a custom functi | Excel Worksheet Functions | |||
formula for custom output | Excel Discussion (Misc queries) |