Select Cell From Formula

[Richard2542]

Using the cell "address" function, I have identified the cell location (address) of the cell I need to select. I need to write VBA code that uses this returned address to select the corresponding cell.

 

[Joe4]

Welcome to the Board!

Please provide more details, maybe walk us through an actual example, complete with data and formulas.

 

[Richard2542]

I used this formula to determine the exact location of the cell I wish to select -

=CELL("address",INDEX(B3:H4,2,MATCH(B2,B3:H3,0))) The valve returned is:

$D$4

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

I now want to go to this location and select it. I will then paste information within this selected cell.

 

[Joe4]

Try this VBA code:

Sub GoToCell()

    On Error GoTo err_chk
'   Go to cell address being returned by activecell
    Range(ActiveCell.Value).Select
    
    Exit Sub
    
err_chk:
    MsgBox ActiveCell.Value & " is not a valid cell address to go to.", vbOKOnly, "ERROR!"
    
End Sub

It will go whatever cell address is in the ActiveCell at the time you run it.

 

[Richard2542]

Try this VBA code:

Sub GoToCell()

    On Error GoTo err_chk
'   Go to cell address being returned by activecell
    Range(ActiveCell.Value).Select
    
    Exit Sub
    
err_chk:
    MsgBox ActiveCell.Value & " is not a valid cell address to go to.", vbOKOnly, "ERROR!"
    
End Sub

It will go whatever cell address is in the ActiveCell at the time you run it.

Thanks...I'll try this shortly

 

[Richard2542]

I used this formula to determine the exact location of the cell I wish to select -

=CELL("address",INDEX(B3:H4,2,MATCH(B2,B3:H3,0))) The valve returned is:

$D$4

<tbody>
</tbody>

I now want to go to this location and select it. I will then paste information within this selected cell.

This works perfect...thank you so much

 

[Joe4]

You are welcome.
Glad I was able to help!