Help to correct Syntax ... Error: Wrong number of Arguements or Invalid property Arguement

[NimishK]

Hi
Can someone help me to correct my syntax below

As i am getting error Wrong number of Arguements or Invalid property Arguement

Dim a as Variant
Dim matchValueString as String
Dim curRow as Long
Dim lstRow as Long

a = Application.Match(matchValueString, (xWk.Range(Cells(3, curRow), Cells(3, lstRow), 0)))
or
a = Application.Match(matchValueString, (xWk.Cells(3, curRow)), Cells(3, lstRow), 0)

Thanks
NimishK

 

[Rick Rothstein]

I think maybe this is what you are looking for...

[table="width: 500"]
[tr]
	[td]a = Application.Match(matchValueString, xWk.Range(xWk.Cells(3, curRow), xWk.Cells(3, lstRow)), 0)[/td]
[/tr]
[/table]

 

[JoeMo]

Try:

a = Application.Match(matchValueString, xWk.Range(xWk.Cells(3, curRow), xWk.Cells(3, lstRow)), 0)

 

[Rick Rothstein]

Try:

a = Application.Match(matchValueString, xWk.Range(xWk.Cells(3, curRow), xWk.Cells(3, lstRow)), 0)

I wish I had thought of that formula.

 

[JoeMo]

I wish I had thought of that formula.

I wish posts prior to mine would appear sooner so I would know not to waste my dwindling energy!!!!!!!!!!!

 

[Rick Rothstein]

I wish posts prior to mine would appear sooner so I would know not to waste my dwindling energy!!!!!!!!!!!

Dwindling energy? C'mon, I don't take you to be an old man like I am. :wink:

 

[shg]

...xWk.Range(xWk.Cells(3, curRow), xWk.Cells(3, lstRow)...

That's either wrong or a misleading choice of variable names; curRow and lstRow both refer to columns.

 

[NimishK]

Vow What a coincedence of perfection of Same syntax from Two MrExcel MVPs.
Thanks a ton ! Rick and JoeMo

NimishK

 

[NimishK]

Shg

That's either wrong or a misleading choice of variable names; curRow and lstRow both refer to columns.

Yes you are Absolutely right thanks for the correction. Have interchanged

xWk.Range(xWk.Cells(curRow,3), xWk.Cells(lstRow, 2)...

Thanks Nimishk