you are trying to treat HDRDATE as an object with the set statement. and you
dimmed it as a value

Dim HDRDATE As Date
HDRDATE = range("Q2")

--
When you lose your mind, you free your life.


"waynehinds" wrote:


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

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

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


--
waynehinds
------------------------------------------------------------------------
waynehinds's Profile: http://www.excelforum.com/member.php...o&userid=25331
View this thread: http://www.excelforum.com/showthread...hreadid=388444