Dynamic Formula

[boynowonder]

I am trying to change the last part to a dynamic cell reference instead of the text "AQ:AQ"..

change from this

=MATCH("Cash, end of period",INDIRECT(CHAR(39)& T2 & CHAR(39)& CHAR(33) &"AQ:AQ" ),0)

to this

=MATCH("Cash, end of period",INDIRECT(CHAR(39)& T2 & CHAR(39)& CHAR(33) & AA2 & ":" & AA2 ),0)


where the value in cell AA2 holds the text AQ.

TRIED THIS, didnt work

=MATCH("Cash, end of period",INDIRECT(CHAR(39)& F2 & CHAR(39)& CHAR(33) & CHAR(34)& AA2 & CHAR(58) & AA2 & CHAR(34) ),0)

[VBA Noob]

boynowonder,

Welcome to the forum.

Please take 5 mins and read the forum rules below. Once you read the rules please post the link to the other forum where you have crossed posted this question.

I would also suggest you add the link from this site to the other forum

Thank you

VBA Noob