It will help us if you would post the Sub that is giving you the error.

In the VBA Editor, Select and copy the sub, then in our Forum Post Editor click the # icon to insert Code Formatting Tags, then merely press Ctrl+V to past the code between the Tags