| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Passing Arguments in Excell function
Hi
Is there any way , I can pass arguments in Excell 'Range', object when wrting a VBA code. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Passing Arguments in Excell function
The answer is yes, there is. What exactly do you want to do?
On Feb 13, 5:57 pm, ub wrote: Hi Is there any way , I can pass arguments in Excell 'Range', object when wrting a VBA code. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Passing Arguments in Excell function
One way:
Public Sub Try() Dim rTest As Excel.Range Set rTest = ActiveSheet.Range("A1:J10") PassRange rTest End Sub Public Sub PassRange(byRef rTest As Range) Msgbox "The range is " & rTest.Address(False, False) End Sub In article , ub wrote: Hi Is there any way , I can pass arguments in Excell 'Range', object when wrting a VBA code. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a row to a function | Excel Worksheet Functions | |||
| Passing a WorkSheet from a Function??? | Excel Worksheet Functions | |||
| Passing Variable Number of Arguments to a Sub | Excel Discussion (Misc queries) | |||
| Passing parameters Cel Ref) to Sum function | Excel Discussion (Misc queries) | |||
| passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Linear Mode
