How do I filldown an array using VBA? Or copy and paste one?

[9tanstaafl9]

I need to use VBA to either filldown or copy and paste a cell that contains an array. I have to admit, I don't even know what an array is, I'm trying to clean up someone else's report. (Never again!)

Anyway, when I try to use VBA to filldown, or to copy and paste, it "works" fine and pastes the EXACT SAME array, but it does not adjust the row numbers like a normal filldown or copy paste would.

Could someone tell me how to do that, or if it is even possible. I've tried searching but I'm finding answers to different questions.

 

[Norie]

Do you mean an array formula?

 

[9tanstaafl9]

I guess I do. It looks like a normal formula but it has curly brackets. But I realized this morning that my question was dumb. A different array does Fill down quite nicely in an earlier part of the macro. I assumed that the array formula was the root of my problem simply because I wasn't familiar with them. Please disregard my question. And if there is a way to get rid of embarrassing posts altogether please let me know. Thanks!

 

[9tanstaafl9]

I figured out my issue. I needed to calculate before proceeding with the rest of the macro. I had copied the cell with the array formula and pasted it into another cell, then immediately grabbed the pasted cell's value as a variable to use somewhere else. I was getting the pre-calculated value, which happened to be zero, and I had mistakenly thought that my copy and paste wasn't working. Sorry for wasting your time, I should've realized that was what was happening.