Copy/Pasting Macro Function

1) Glad to help ... the macro was failing because your Target Range Names had gotten corrupted (i.e. they had #REF in their references). You probably named everything OK, but then you might have moved or copied something which caused these 6 Range Names to loose their reference. I edited your copy and am sending it back to you (see attached).
2) Range Names may sound like a hassle, but they are better than putting hard cell addresses in your code. If the latter, then every time you insert columns or rows, or move your referenced cells, the code must be manually adjusted (major pain!). With Range Names, if you are careful, typically they hold fast in staying with the appropriate cells.
3) The Range Name editor in Excel is VERY lacking. If you want to manage Range Names, I HIGHLY recommend downloading the following "Name Manager": (http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp). ... Regards, sauerj