Thread: using vb to create charts over multiple worksheets

thanks that looks great, there is an error here tho:

For Each rngRow In rngData.Rows
        ' check whether to create report
        If rngRow.Cells(1, 11).Value = "Y" Then
            Set shtPolicy = m_GetPolicySheet(rngRow.Cells(1, 5).Value)

thanks that looks great, there is an error here tho:

one of them 'sub or function not defined' errors, i think that's something to do with references? i have pdfcreator added as reference, but is there also a reference there for the emailing porion maybe?