I have made an excel sheet as an example

All I want to do is when select the month in the drop down combo, add
up the next month and the rest off the cells the same so it this
example when selecting Januari it will be Januari(A8:A13) plus Februari
(B8:B13) and get the results underneath the result list as: F8=A8 + B8
and F9=A9+B9 and so on.
I Think there must be a simple way to display this but I don't know how
to refer in VBA to the Defined names (or how you call them) I have set
this but how do I use them in the code?

In column G you can see what it supose to do when Jan is selected

Anyone?

thanks


+----------------------------------------------------------------+
| Attachment filename: test ref.zip |
|Download attachment: http://www.excelforum.com/attachment.php?postid=360800|
+----------------------------------------------------------------+

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/