| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function with parameter "as range"
It should be like this
msgbox functionname(range("a1:a10")) Which is passing cells A1:A10 of the acitve sheet to the function. If that is not working you will need to post your code... -- HTH... Jim Thomlinson "Mike Archer" wrote: 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 |
| Reply |
| 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 | |||
![Jim Thomlinson[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
