LNewcomerLucieGRegistered on:02/14/2015Last activity:02/18/2015 at 00:23Version of Excel:2007Posts2Votes0Files0Downloads0ThreadsPostsStatisticsVotes received Threads Created by LucieGDateForumThreadMessage Excerpt02/14/2015 at 13:11Excel - VBAMacro find replace in formulaI am trying to run a macro replacing a part of a formula using find-replace: Find: AND( Replace: AND(INDIRECT(“AL”&ROW())="1"); (within the macro of course quotation marks are added) When recording the macro this works perfectly fine, which is unfortunately not the case when I want to apply the macr...Forums