Excel: Copy formula-resulting values from a range to the first "empty" cell in another column

Hello all, So I have a column of values ("E") that are the result of formulas. Is it possible to copy all resulting values of Column "E" into the first unoccupied cell in Column "D" (that also has values that depend on the result of a formula)? I have tried a combination of Range ("E1:E) with .SpecialCells(xlCellTypeVisible).Copy to no avail. Any help would be greatly appreciated. Thanks in advance!

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of July 17, 2017.

For more resources for Microsoft Excel