I am trying to select the date from Q2 and place that date in th
header.

How do i correct the statement below to make sure the date is capture
as HDRDATE?

Dim HDRDATE As Date
Set HDRDATE.Value = ("Q2"

--
waynehind
-----------------------------------------------------------------------
waynehinds's Profile: http://www.excelforum.com/member.php...fo&userid=2533
View this thread: http://www.excelforum.com/showthread.php?threadid=38844