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.
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.