Excel VBA pass range value

I have the following
Sub TestInsertPictureInRange()
  Dim filename As String:  filename = Cells(1, 11)
  Dim rangevalue As Range: Set rangevalue = Range(Cells(1, 12), Cells(1, 13))

  InsertPictureInRange(filename, rangevalue)
    
End Sub

Sub InsertPictureInRange(PictureFileName As String, TargetCells As Range)

End Sub

Open in new window


However, when I put in "rangevalue" in the call to:
InsertPictureInRange(filename, rangevalue)

I get an error:
Compile error:
Expected: =

How should I be passing this?
maverick0728Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
You need to remove the parenthesis around the arguments.
When you call a procedure without using the keyword Call, you don't need to specify the arguments inside the parenthesis.

So you should use one of the following method to call another procedure...

InsertPictureInRange filename, rangevalue

Open in new window


OR

Call InsertPictureInRange(filename, rangevalue)

Open in new window

1
 
KimputerCommented:
Line 5: InsertPictureInRange filename, rangevalue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.