I need to copy the value of a formula into a cell one down and one to the
left of the current cell I am copying. Rather then right click and select
the options. I can build a macro to copy then paste special but...I want the
copy to be the current cell I am in then move the active cell on down and one
left then paste special. Is there a way to use visual basic to move one cell
left and one cell down and move only the information in the cell?