Application.Goto error 1004

[JLHpgs]

Hi,
I am new to VBA and would be grateful for your help please. What is wrong with this that it gets an error:

Application.Goto Reference:="INDIRECT(CELL(""address"",OFFSET(R1R3,MATCH(MAX(C:c),C:c,0)-1,0)))"

The purpose is to find the maximum value in column c and move the cursor to that cell.

 

[Norie]

What exactly does the formula return?

Also, in the formula you have R1R3, what range is that supposed to refer to?

 

[JLHpgs]

Thanks Norie.

If I type this formula into the Goto dialogue in a worksheet it takes me to the cell I want.
When I try to run it in VBA is gives Run time error 1004, reference is not valid

Apologies, R1R3 was mistyped in the post, it should have been the cell address which should perhaps be in R1C3 format? The formula I have is:
=indirect(CELL("address",OFFSET(C1,MATCH(MAX(C:C),C:C,0)-1,0)))

 

[Norie]

Try removing INDIRECT from the formula and using Evaluate to get the cell address

strGoto = Evaluate("=CELL(""address"",OFFSET(C1,MATCH(MAX(C:C),C:C,0)-1,0))")

Then use the address with Range.

Application.Goto Range(strGoto)

 

[JLHpgs]

Norie, that's cracked it, many thanks!