It is helpful to those responding to questions if certain information is always provided along with the question...
1. Excel version
2. Computer operating system
3. Complete error message
4. The line at which the error occurs.
5. What is the code supposed to do.
6. What you have tried in order to fix the problem.
'-----

Replace this line at the bottom of the code...
MsgBox "An error occurred."

With this line...
MsgBox Err.Number & " - " & Err.Description

Post back.
--
Jim Cone
Portland, Oregon USA
( http://tinyurl.com/PrimitiveSoftware )



"kaydee"
wrote in message ...
Hi All,
I found code and tried to change it to make it fit me worksheet. I am
using a inputbox to get a date range for report selection. The following
code highlights and copies the first matchof my criteria set then I get the
Err_Execute message in the sheet that I am copying to. Can someone tell me
what is wrong with my code? Thanks
Kim

'snip