Hi Bill,My name is***** will try my best to help you with your question.
You should always avoid using usedrange to count rows.
Instead, you can find the last row and use that instead.
To find the last row in column A, you can use:
LastRow = .Range("E" & .Rows.Count).End(xlUp).Row
--------------------Kindly rate my service 5 stars at the top of your question page if my answer helped so I am rewarded for my time; tips appreciated :)You can always reply back at any time if you need further assistance.Pete.--------------------
Hello,I am the person that will be helping you today. Please, send me a document where you can show me the problem in action.
Please, be forewarned that the site is not secure:- Click the following link: http://www.wikisend.com- Upload the file to that website- Once it is uploaded, the resulting page will display a "File ID" number.- Please, give me that "File ID Number" Please, send your reply below in the box. After you type your message, click the Send button.