[VBA] Place x quantity of value in visible cells only

[RockandGrohl]

Hi guys, let's say x is a variable of a value that I want placed in a variable number of visible cells after filtering.

How I do dis?

For posterity, the range I want the cells placed is in column BD, I'd want the values placed vertically so BD2, BD3, BD4 but only where visible. How do I place 860 values of x in the first 860 visible cells in column BD?

Thanks!

 

[Peter_SSs]

It got pretty complicated for somebody who is not very familiar with your data and requirement and you seemed to be making good progress yourself.
Is there a particular problem with what you have?

 

[RockandGrohl]

It got pretty complicated for somebody who is not very familiar with your data and requirement and you seemed to be making good progress yourself.
Is there a particular problem with what you have?

No, I just generally feel like the portion I've added to handle allocating 1,000 references when there's only, say, 545 records is a little messy and I think there may be a more elegant solution than counting the areas and cutting it short when I get to the final area.

Thanks again. It does work remarkably well and it's lightning fast. Our old allocation system used to take hours to do a few thousand rows and this can do tens of thousands instantly.