Go to sheet1
Right click on the sheet tab and select view code.

click in the module, do Ctrl+a

hit the delete key.

this should clear out all code in the module (and get ride of you
incorrectly formatted sub declaration).

click in the upper right corner of the module window to close it.

--
Regards,
Tom Ogilvy

"kaz85" wrote in message
...
Its ok. Here is a picture of what happens when I click on my macro. Im
not very good at excel its always been one of my weaker points in
college.

Attachment filename: error.jpg
Download attachment:
http://www.excelforum.com/attachment.php?postid=384029
---
Message posted from http://www.ExcelForum.com/