Offset_formualcells_two rows_

Hi ,

Wondering if some once code help me doing small modifications on the below code . and I am my requirement is I want the code to search the cells that has formula in particular column (X) and identifies the formula cells and offset to 2 rows .

Please Login or Register  to view this content.

Please find attached example file for your reference .

Do you want it?

Please Login or Register  to view this content.

Hi mate .. this is great.. can it be possible i want the code to be execute only in certain row lets say .

only in column" A ".

Just change line 3 as:
Columns(which you want).SpecialCells(xlCellTypeFormulas, 23).Select
For ex: Columns("A:A").SpecialCells(xlCellTypeFormulas, 23).Select

Sorry mate :
I tried with the below code it does not fetch the results . its giving object error .

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

thanks john....

Your welcome, Hudson.