Please use Code Tags (see below).
What are you trying to do? If you're trying to delete an entire row, or rows, there's not much point in determining a start and end range just so you can delete three rows.
How many rows have the word TOTAL in them? If it's less than 2000, that's why you get the error. What is the purpose of BeginRow, EndRow and ChkCol? You don't use them.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Bookmarks