Excel Macros
 

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!

Excel Macros
 

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!