VB Code to go to certain cell.

[rizmomin]

Hello:

If A=C5 where C5 is the position of the cell ( Column C, Row 5)


I need simple code to go to cell depending on the value in cell A.

Let me Know if you have any questions.
Thanks.



Riz

[BigBas]

This type of code should do the trick. NOTE: This code is set to look at the value in cell A1. Amend it to suit your needs.

    Dim rng As Range
    
    Set rng = Range(Range("A1").Value)
    
    rng.Select