I want to make a macro that will add all values in a column by pressing a key combination. My problem is I will never know how many values will be in the column, so I need to know how to be able to place my mouse pointer in an empty field in the column, press my key combo and get a total placed into the empty field.
If anyone is willing to help, I'd be most appreciative. Thanks in advance!!
Not too sure about the key combo (I just read a different post), but here is a little macro that will show you the total of a column (where $1 is the first row where your data starts and it ends the sum right above the cell that you currently have selected) -
Please Login or Register to view this content.
Last edited by aznbruinboy; 04-10-2007 at 04:08 PM.
Thanks for your reply! I'll give that a shot and see what comes out the other end.
aznbruinboy,
Your suggestion worked like a charm!! Thank you so very much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks