Excel vba parse formula

Question

I have some excel sheets with calculated fields, e.g. CELL_C =FIELD_A+FIELD_B. I need to extract all cells from that formula for highlight it with different color. Is there any built-in VBA function to parse cell.Formula to get the range of cells?

Your explanation is too scarce. Please provide a screenshot or elaborate more. — AnalystCave.com
– AnalystCave.com, Commented May 12, 2015 at 12:10

Gary's Student · Accepted Answer · 2015-05-12 12:12:09Z

3

You can always get the first-level precedents with something like:

Sub qwerty()
  Dim rng As Range
  Set rng = ActiveCell.Precedents
  If rng Is Nothing Then
  Else
    MsgBox rng.Address(0, 0)
  End If
End Sub

For example:

enter image description here

answered May 12, 2015 at 12:12

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

FreeMan Over a year ago

Thanks, Gary - I didn't know about .Precedents - looks very useful!

Gary's Student Over a year ago

@FreeMan There are some restrictions associated with .Precedents.

brettdj Over a year ago

need to use NavigateArrows to find off sheet precedents

Collectives™ on Stack Overflow

Excel vba parse formula

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related