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

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

Don't use the 'Set' keyword. 'Set' is used to assign an object to
an object variable declared as the appropriate type.
Change your code to

HDRDATE = Range("Q2").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"waynehinds"
wrote
in message
...

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

Thanks for replies..

I want to now set this value to the date format "mm/dd/yy" and put in
header.

It is currently printing in header but it is printing m/d/yyyy


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

try

HDRDATE = format(HDRDATE,"mm/dd/yy")

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


"waynehinds" wrote:


Thanks for replies..

I want to now set this value to the date format "mm/dd/yy" and put in
header.

It is currently printing in header but it is printing m/d/yyyy


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

Thanks a lot...That did it

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