Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Paramiters and UDF Question
Greetings, I have a function that adds two ranges then subtracts Range B from
Range A giving me "N" I would like to know how to modify the following to be able to pass N back into a sub procedure on a userform. Function GetBalances() Dim x As Long, y As Long, N As Long Dim ARange As Range, BRange As Range Set ARange = Range("A:A") Set BRange = Range("B:B") x = WorksheetFunction.Sum(ARange) y = WorksheetFunction.Sum(BRange) N = x - y Debug.Print N End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
General Question regarding passing cells, ranges, cell values through subs & functions | Excel Programming | |||
General Question regarding passing cells, ranges, cell values through subs & functions | Excel Programming | |||
General Question regarding passing cells, ranges, cell values through subs & functions | Excel Programming | |||
General Question regarding passing cells, ranges, cell values through subs & functions | Excel Programming | |||
Question: Macro overloading, passing variable number of arguments | Excel Programming |