temporarily add the line:
mylookin.Cells(iw).Interior.Color = vbRed
directly after the line:
mylookin.Cells(iw).Value = "Weekly"
to highlight the changed cells in column L.
It works here, but then I don't have your sheet RR.
temporarily add the line:
mylookin.Cells(iw).Interior.Color = vbRed
directly after the line:
mylookin.Cells(iw).Value = "Weekly"
to highlight the changed cells in column L.
It works here, but then I don't have your sheet RR.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote