Hi Merit,

I do not understand the purpose of multiplying
the cell content by 0,but, assuming a valid reason,
try something like:

With ActiveCell
.Value = ,Value * 0
End With


---
Regards.
Norman


"Merritt Sakata" <Merritt wrote in message
...
what is equivalent VBA to old macro
keystrokes:{edit}{home}({end})*0{enter}
I want to simply enclose the contents (number or formula) of
current/active
cell and multipy by zero. the keystroke recorder only will allow recording
of
the actual contents as permanent text string or cell address thus does not
function.
thanks!