Identification of range having similar formula using VBA

[ratan203]

Dear Members,

I would like to use VBA to identify contiguous cells having similar formula (which we create using fill down or fill right in excel by dragging the mouse).
I have below table as an illustration. The range having similar formula here is C3:C7.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Age[/TD]
[TD]Weight[/TD]
[TD]Weight/Age[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10[/TD]
[TD]30[/TD]
[TD]=B3/A3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]15[/TD]
[TD]35[/TD]
[TD]=B4/A4[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]20[/TD]
[TD]40[/TD]
[TD]=B5/A5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]24[/TD]
[TD]50[/TD]
[TD]=B6/A6[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]30[/TD]
[TD]55[/TD]
[TD]=B7/A7[/TD]
[/TR]
</tbody>[/TABLE]

Is there any existing function which can be used for this purpose?
I tried searching on Google but couldn't get any relevant post.
Any help will be highly appreciated.

Thanks
Ratan

 

[pgc01]

Hi Ratan
Welcome to the board

In File->Options->Formulas, set the option "R1C1 reference style"

Now go back to the cells and check the formulas. You'll see that they are the same.