Specialized Pivot-like data

    You might want to just amend that line anyway to avoid the debug error - something like:


    Code
    If n > 0 then
Sheet2.Cells(2, 1).Resize(n, 5).Value = var
else
msgbox "No matching data. Please make sure the dates in the data are not text!"
End If

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

    Good to hear it is all sorted out !!! :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login