Moving down one cell at a time starting at a specific cell

Hello everyone. What I am looking for is vba code that will allow me to move down one cell at a time starting at a specific cell. For example, always starting at cell C1, then it will proceed to C2, then C3 etc. I would like to place a button on the spreadsheet so that each time the button is pressed it will move one cell down. So, I press the button once and cell C1 is selected, I press the button again and it moves to cell C2, etc. I am able to do this using Active Cell but that means I have to select the starting cell, which is not what I want. Thank you.

Thanks but this doesn't do exactly what I want it to do. I don't want to close the file to restart the counter. Suppose I want to fill in the cell with the color green, each time I press the button, the cells will become green. If I reset the cells to no fill and press the button again, it will start once again at C1. I hope this makes sense. I can do this using active cell but I was hoping I can do this starting at a specific cell and not having to select the cell myself. Thank you anyways.

That's a much better description than your first post in the thread!

Maybe this?

Please Login or Register  to view this content.

It will find and select the first cell in column C with no interior colouring.

BSB

This is better but if the cells are not empty it will not move down. Thanks for your help.

I'm confused!

You said the idea was you'd colour the cells green and you wanted it to go to the next one that isn't....

Perhaps describe exactly what you need and we can help from there. We're not mind readers!

BSB

Alright here goes, I press a button and cell C1 is selected and is filled in dark green and the font is white. Now, I press the button again and it moves to cell C2 and does the same thing, I press the button again and it moves to cell C3 and does the same thing etc. Now, if I should remove the color green and set the font back to automatic in Column C and if I press the button again it will start again at cell C1 and repeat the process again. In other words, every time the cells are cleared, pressing the button will start over at cell C1. I hope this clears it up.

So this amendment to the 2nd try above will find the next non green cell, select it, change the interior colour and font colour. If you clear the colouring it will start at C1 again.

Please Login or Register  to view this content.

BSB

Yes, this is exactly what I was looking for. Thank you very much for your help and sorry about the confusion.

Glad I could help.

BSB

I'm curious, what if I wanted to start on C4 instead of C1 what would I have to change?

It's okay I figured it out. Thanks everyone!