Hi,

i use this code to find the column number: 

For i = 2 To 13
If ws2.Cells(3, i).Value = prd Then Exit For
Next
Then i need to put this integer in a formula as follows:

ws1.Cells(6, "G") = "=SUM(PF!B3:" & i & "3)"
But it inserts as an interger not a letter i.e. 2 = Column 'B' and returns a object defined error.

how can i get around this?

Thanks,