Marcus

Just want to let you know I sent the sample workbook to your email address
as before for you to take a look, hope you got it. Trust its ok for me do
that!

Thanks

"marcus" wrote:

Hi

Looks pretty simple to me. This line, Option Explicit is all about
declaring all your variables. A good way to start anything in VBA.
Your lngLastRow is not declared as a variable. A simple misspelling
where you have Dim ingLastRow As Long

Replace with

Dim lngLastRow As Long

Take care

Marcus
.