The following sub will do what you want:

Sub DownAndLeft()
Dim x As Variant
x = Selection.Value
Selection.Offset(1, -1) = x
End Sub

Select the cell with the formula and run the macro.

Good Luck
--
Gary's Student


"Bud Hughes" wrote:

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?