messingaroundok
New Member
- Joined
- Apr 15, 2016
- Messages
- 25
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!
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!