Macro: number of rows to select changes based on input

Mouse bounce.

You also have references to Rows 253 & 246 in there so what's the relationship between them and 287 in this example? If your last row was 300 what do those change to? 266 & 259??


Also:
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.

Click on Edit to open your thread, then 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

Hi Lazarus, my apologies. I have corrected my post.
The code deletes certain rows two times. First it deletes all the rows that contain "blank" and then all the rows that contain #DIV/0! in one column and 0 in another column. I want this because I do not want to include them in my further process. Or is it a bad idea to delete rows for the macro?

Not a bad idea - it's just you referred to row number 287 as the last row in your example but the code also refers to the other rows I mentioned. I can't imagine these are fixed so there must be some way to determine which rows you want when, for example, the last row is 300 rather than 287.

Thank you for the edit to the first post.