Fill Down Column?

[stfeliciasredpanda]

This isn't an issue, per se, but more of a how to question. The code below imports data from a workbook to a destination sheet. Three of the columns don't come from the array (A, B, C) but are set values. How do I fill those values down the blank cells in their columns? I've literally tried every piece of code I could find and nothing has worked so far. I've not had to do that before, so it may be a lack of understanding on implementation. Appreciate any insight.

Please Login or Register  to view this content.

[stfeliciasredpanda]

Just in case this helps anyone else out who is treading unfamiliar ground. I found this code and it did the trick. Change column number to your relevant column.

Please Login or Register  to view this content.