Can you check my post here? Maybe this is what you looking for...
(I didn't solve his porblems but I might solve yours )

http://www.excelforum.com/excel-gene...me-period.html

Also, check other solutions, you might find somenthing usefull...