Thread
:
Finding Array Formulas in VBA
View Single Post
#
1
Posted to microsoft.public.excel.programming
ExcelMonkey
external usenet poster
Posts: 553
Finding Array Formulas in VBA
How do you search a cell for array formulas? Using the "{" as a search term
in Excel's Find does not seem to do it. Is ther a way in VBA to find these?
{=MAX(IF(MONTH(E6:E12)=F14, F6:F12, 0))}
Thanks
Reply With Quote
ExcelMonkey
View Public Profile
Find all posts by ExcelMonkey