Thanks again guys...I did copy into a new book with sheet 1 & 2 and it did
work. That mean all I have to do is change references in the macro to sheet 1
& 2 to the actual sheet names and ranges and it should work again. will let
you know.

Cheers

"JLGWhiz" wrote:

Ben, don't let it scare you away. This is how you learn about programming.
Take the challenge and learn how to debug the code. Probably the worse
thing that can happen is you spend a couple of hours on it.


"Ben" wrote in message
...
Thanks for your help guys but I think this is bigger than I can handle
with
my knowledge.

"JLGWhiz" wrote:

I don't know why you would get a VBA error 400, which is telling you that
you are trying to open a form that is already open. There is nothing in
the
code that Joel provided that calls a form to Load or Show. If you click
the
Debug button when the error message appears, which line of code is
highlighted?


"Ben" wrote in message
...
The only thing I forgot to say was that the sheet with all the data is
call
"Voucher Records". Would that make a difference?

"JLGWhiz" wrote:

This is the message for a Err 400:

You can't use the Show method to display a visible form as modal. This
error
has the following cause and solution:

a.. You tried to use Show, with the style argument set to 1 -
vbModal,
on
an already visible form.
Use either the Unload statement or the Hide method on the form
before
trying to show it as a modal form.

So, since there is no form involved in the code Joel provided, the
question
arises, is there something you forgot to include in your original
post?



"Ben" wrote in message
...
Hi Joel

The macro does not work. I get a 400 error