ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   writting a macro for the sum function so I can use it as a keyboard shortcut (https://www.excelbanter.com/excel-programming/304722-writting-macro-sum-function-so-i-can-use-keyboard-shortcut.html)

Frank Kabel

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
.



All times are GMT +1. The time now is 07:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com