Your DIM statement says that thingy is an integer variable. Then you try to
assign a string (text) to it. That won't work. Try
Dim thingy As String
On Mon, 30 Aug 2004 15:12:43 -0500, 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/