Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to detect formula where it is refrering same row

  Asked By: Clariee    Date: Jan 05    Category: MS Office    Views: 779
  

Can some one help me. I work with financial services company. Where we
usally use sum of quarters. But what I am trying to do is write a code
that'll detect the formula if not paste it will highlight. I want some
line codes that will do this job.
Basically it'll be a par of big code that I have written for qulity check.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Leonardo Costa     Answered On: Jan 05

Maybe you could use ActiveCell.Formula to return the formula  and then scan
it for what you want.

 
Didn't find what you were looking for? Find more on How to detect formula where it is refrering same row Or get search suggestion and latest updates.




Tagged: