P45cal and Kenneth Hobbs

Thanks to both of you for the help you provided. My code now copies successfully from Worksheet "ForeastTable" to "Audit" and then adds a date and Time stamp and the Application Users name who deleted the row. The issue with the code did seem to be that VBA did not like the Range object and once I changed that to Cells it worked fine. All that is left is to clean up the code to remove the msgboxes I was using to debug the code.

Again, the help I received being a novice VBA coder has been a great learning experience and if were not for this form I would be working twice as much and not getting as much done.