Checking cells one by one

Hey all,

Just wondering if there is a code to start off in one cell and continue moving down a cell up until a limit?

For example, say I wanted to start in B5 and move down to B20 while adding 1 to the value in each cell? or If I wanted to start in a cell and move down looking for a certain word for an if statement and for every cell that contains this word then delete the row that I'm on?

Cheers.

You appear to have flagged the thread as SOLVED prior to any solution being provided, so I've no idea if you still require answers to this or not.

In the interest of people that may find this in the future when searching for a solution to a similar issue, below are examples of code that will work for the scenarios asked about above.

This one will add 1 to the value of each cell in B5:B20

Please Login or Register  to view this content.

And this one will delete any rows where the cell value of column B for that row is an x

Please Login or Register  to view this content.

Note, when you're deleting rows you need to loop backward, from the bottom up, to save is skipping rows in instances where two consecutive rows contan x.

There are other, non looping ways of doing performing these actions, but your thread title specifically asks for checking them one by one.

BSB