View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default writting a macro for the sum function so I can use it as a keyboard shortcut

Hi
something like

sub foo()
activecell.value= application.worksheetfunction. _
sum(selection)
end sub

-----Original Message-----
Hi,

How do I go about writting an excel macro or anything
else so that I can use a keyboard combination so as to
sum my highlighted range??

Please help

Please reply to my email address

thanks
.