Passing Arguments in Excell function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Is there any way , I can pass arguments in Excell 'Range', object when
wrting a VBA code.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Passing Arguments in Excell 3
Passing a UDF as an argument to a UDF 3
Passing a range to a user defined function 1
Replace ; with , in functions 1
Using Text string in Sum formula 2
OnTime: Pass Object Arguments 6
Pivot table 2

Back
Top