How to select a cell using address formula in another cell

[ajt0107]

Hi....am using a address formula @ cell A65535 to capture the cell reference of a particular text which resides in the cell range between "G05:GO2000"....here's the formula for quick reference

"ADDRESS(SUMPRODUCT(($GO$1:$GO$2000="Ajit")*ROW($GO$1:$GO$2000)),187)"...answer for this is $GE$13. Now my requirement is to activate this cell using VBA.


Please help asap.

[alanga]

Hi Ajit

Like this, no need to use the result of the formula to select cell.

Sub macro()
    Dim r As Range
    Set r = Columns(197).Find("Ajit").Offset(, -10)
    'replace message box code with your code
    MsgBox r.Address
End Sub

[ajt0107]

THANKS A BUNCH !!!!!

have an additional query.....what's the VBA to to execute the macro automatiacally every day or on desired day at specific time

1. Macro Name is "Macro".
2. saved @ desktop.


Help

[alanga]

Hi Ajit
How bout mark this thread solved and start a new thread with your next question

[ajt0107]

Hi Alanga......okay....have posted the new thread for new requirement....thanks.