Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
Making excel macros run Word macros | Excel Programming |