And see a few more replies at your other post.

"mpjohnston <" wrote:

Dim thingy As Integer

thingy = "=MATCH(""DiceC"",qperiodagentperformance!A:A, 0)"

ActiveCell.Formula = _
"=INDEX(qperiodagentperformance!D" & thingy &
":D13000,MATCH(""Agent Summary"",qperiodagentperformance!A" & thingy &
":A13000,0))"
Range("D26").Select

my thingy doesnt seem to work..... no comment
Mike

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson