Print selected rows based on cell data

When you run the macro and get the error code, click on debug and advise which line of code is highlighted. I am unable to duplicate your error message. Suggest you post a sample of your workbook so that it can be analyzed. The code works perfectly for me based upon your description in the first post.