Copy value of active cell down, as long as there is a value in column E
Posted on 2014-08-20
Title of question is it. I have a active cell with a value that I need to copy down that column as long as there is a value in column E. There will always be a value in column E, but it does not go down the whole dataset, only part of the way.
Active cell is column B, how do I tell it to check offset 3 columns to the right and figure out how many contiguous cells with data, (xlDown) there is from there down, so I can copy then copy my original active cell down that many times?
Then ending on the offset 3 to the right of original cell?