Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function with parameter "as range"
What are you supposed to pass to a function that has a parameter "range" data
type? I have tried the following: msgbox functionname(range("a1:a10").address) msgbox functionname(range("a1:a10").range) msgbox functionname(range("a1:a10")) msgbox functionname("a1:a10") msgbox functionname(a1:a10) -- Thanks, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parameter "TwoDimension" on RowVector function | Excel Worksheet Functions | |||
"Empty" values in holiday parameter for NETWORKDAYS() function | Excel Worksheet Functions | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |