Post #1 was edited in code. I did not edit the post, figured second post would stand alone. I will edit later today.
You understand how that might be a little confusing for someone who knows nothing about your workbook, data, code or processes?
it does state where code is going, here:
I missed that because I was copying the formula from the first post.
I can set the code with VBA, I guess, but why? Why does the array not fill up or down with all of the rest of the giblets?
That, I do not know. There are often things in Excel and VBA that I think should work but don't. Sometimes it's my understanding, sometimes it's a foible or restriction in Excel or VBA, sometimes I've cocked up. It happens. As I said, I don't use .FillUp so I don't know the nuances. That said, it could be that it doesn't like Array Formulae.
For example, this works:
But this doesn't:
This is the edited code to put the formula in Column Q AND use .FillUp to copy the formatting from the bottom row.
This version also works but, as you can see, I can't just drop the formula into the last row and fill up. I drop it in the last row, copy it into the previous row and FillUp from there. Swings and roundabouts.
And don't ask me why I have to do it that way … same reason I can't drop it in the top row and copy down from there. It doesn't work. There may/must be a good reason but I don't know what it is.
Bookmarks