The range as an argument of a UDF

[alice2011]

Hi everyone, I suspect the following reference to the range is problematic: Range("Rng1").Cells(1,2). In this function, Rng1 is an argument. Does this mean that VBA tries to find the actual name called 'Rng1', rather than the pass-through from the argument?

Please Login or Register  to view this content.

[MrShorty]

Why are you mixing syntaxes? As you have it now, Rng1 is dimensioned as a range object, there is no need to use the Range keyword to make it more of a range.

The first syntax you use is the one I use most -- Rng1.cells(1,1)

You are correct about the second syntax -- Range("Rng1"). VBA is looking for a named range in the activesheet/workbook that is named "Rng1". It is not looking for the Rng1 object variable defined in the scope of the procedure.

The syntax I would use would be Myfunction=rng1.cells(1,1) + rng1.cells(1,2)

[alice2011]

Hi MrShorty, many thanks for your explanation. I'm new to VBA

I made a function today. The function uses the range in the 2nd form Range("xxx")., which failed to work. Good to gradually correct these mistakes.