Forum Discussion
Solved
intersection operator in @ indirect formula
Hi All, I'm using INDIRECT formula for sometime and I find it quite useful but recently I discovered a situation that gave me some headache. I have the following situation, I'm trying to populate...
Use Formula2 instead of Formula to assign the formula:
Range("...").Formula2 = "=ADDRESS(MATCH(FALSE,ISBLANK(INDIRECT(""'""&D2&""'!C:C"")),0),4)"
Use Formula2 instead of Formula to assign the formula:
Range("...").Formula2 = "=ADDRESS(MATCH(FALSE,ISBLANK(INDIRECT(""'""&D2&""'!C:C"")),0),4)"
- Thanks HansVogelaar
It worked!
