xlDown error when active cell is the last row.

Super basic (and wrong) code as you can see. If you have a list of ten names (A1:A10) and you select name ten, then this macro will throw an error. The error is because between A10:A15 is empty cells, but A16 is a merge cell.

Basically, I just want the macro to do xlDown UNLESS there is no value in the cell right below it. This would make A10, become A11. I cannot insert a row, or cut because that screws other cell's formulas up.

Please Login or Register  to view this content.

Excuse the ignorance. Does that go under "Range"?

I would still want that single select cell copied down. I know it is just as easy to manually do it, but this file will be used by others, and I don't want to have to tell them to do this, but not when that. You know what I mean.

Same error. Can't do that because of Merged cell.

I attached the calculator. You'll see what I mean, but stay between the yellow boxes. Macro locks the workbook. Password is "QA"

Like in the sample workbook. You have a list of dates. I want to select a date, run the macro and it moves that date and any dates below it, down one row. You cannot cut/copy or just insert row because it will mess up other cell's formulas. What my macro is basically taking the activecell and then ctrl+down. This works fine when there are cells with values below it. But if there is not any cells with values, then it wants to keep highlight until it finds the bottom yellow cell.

I am just wanting to bump the selected cell, and any cells in that table, down one row.

Disappearing would be ok, but generally no, nothing would happen because there is no month after the last cell, so that date has no where to go.

Do you mean in the middle of the year? There shouldn't be because you should enter the payment dates in sequential order. Not skipping cells. If you want to move a date to following month, then that is where this macro comes in. I think if I can just stop it from selecting anything below the active cell if there is an empty row beneath it, then that would work.

Right now when it is locked and everything, if I try to ctrl+shift+down nothing happens. That is the same thing I want to happen with the macro. When unlocked, it will select the empty cells until it hits the bottom Yellow cell. So if the macro would act the same, then it would be fine.

Can I do a bump...

Thank you. I think that is exactly what I am looking for. Can you explain what you did so I can learn? I follow everything pretty much, except the ">= 15 Then "

The december part doesn't matter though it seems? Which is good, December may not always be in row 15. Because if you make your first payment today then April 2018 would be in row 15

Nope. The original calculator that this is based on hasn't changed in over a year, so I don't expect that to happen anytime soon!


Thank you!