| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to implement mySum(Sheet1:Sheet3!B1)?
I can call SUM(Sheet1:Sheet3!B1) in A1.
But I cannot call mySum(Sheet1:Sheet3!B1). What type of object is passed for that kind of range? Why doesn't the following work? The second MsgBox displays Error. Function mySum(ParamArray x()) MsgBox LBound(x) & " " & UBound(x) MsgBox TypeName(x(0)) End Function |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| = Today()+1 into Sheet1, Sheet2, and Sheet3 | Excel Programming | |||
| Copy logo from sheet1 to new sheet3-10 | Excel Programming | |||
| A1 in sheet1 =” =SUM('sheet2:sheet3'!A1)” | Excel Programming | |||
| consoildate all the worksheet(example sheet1,sheet2 and sheet3 etc | Excel Worksheet Functions | |||
| user changes sheet1 - have the macro xyz run on sheet3 | Excel Programming | |||
Threaded Mode
