[Ask]Code VBA filter range from Formula of cell

hochoaivandot

New member
Joined
Oct 26, 2012
Messages
1
Reaction score
0
Points
0
Formula of cell A1: "= Sheet1!A2+Sheet3!A3"
Formula of cell B1: "= Sum(Sheet1!A5:A10)+Sheet2!$C$7"
I want a function named FilterRange (arg) with arg is argument address of cell (such as A1, B1).
Function return array containing ranges that cell has reference to.
Detail:
FilterRange(A1) --->array("Sheet1!A2", "Sheet3!A3")
FilterRange(B1) --->array("Sheet1!A5:A10", "Sheet2!C7")
Thanks!
 
Last edited:
Top