Fill/Copy Down Blank Cells Issue

[ptmuldoon]

I'm trying to copy down blank cells based on the value above it. But I'm not certain how to handle the last item to fill down the blanks for the range selected.

This is the basic code which works except for copying the last item. I think I need to somehow include an 'end' of the range?

Please Login or Register  to view this content.

[AB33]

Option Explicit

Please Login or Register  to view this content.

[ptmuldoon]

Thanks AB33.

But that does the same thing. I am selecting cells below the last Non-Blank cell. Example if you had items in Cells A1, A10, and A20. And if you selected the range from A1 to A30, those last to rows/cells do not fill down.

I think you almost may need to add something to below your selected range, ie, A31 then fill down, and then deleted whatever added to cell A31?

Thats just made up example of cells and ranges. Just not sure if that is best way to fill in the blanks after the last item in the selected range.

[AB33]

Assuming the data are in column A.

Please Login or Register  to view this content.

[ptmuldoon]

Same Result. Doesn't copy that last items info down the blank cells selected.

[AB33]

It does on my sample. Please attach your sample.

[ptmuldoon]

Seems strange it works for you.

This is in Office/Excel 2013.

[AB33]

Only loop (back-wards) could work. You do not have cells above, so the code will not find any cell to fill in.

[AB33]

You need to select the range before you run the attached code. As you can see sheet2, it works

[ptmuldoon]

Ah ok. So currently, even with the the original code. If you select it from bottom to top, it will see the first cell selected as the active cell and copy blanks down to that spot.

I know my user's won't think to do that so wonder if there in alternative approach. Is there a way to get the bottom cell of a selected range?

[AB33]

How does any code know where the last cell end unless you have some kind of pointers?
The last non empty cell could be 15,20 or 30 after some blank cells. You need to indicate where the cell start/end after a blank ends.
One way would be to select the desired range. You could also use some kind of data input inbox, but this still suffers the same as selection.

[AB33]

The code you have even with selection will not fill in the blanks while my last code does