AAE:

I think you are right. However my entire program is based on that lin
of code:
Set rng = .Columns(68).Find(dtReportDate)


Does anyone have any clever ideas? I guess I will try switching th
range to = .columns(68)

and I will have to figure out a different way to return dtReportDate t
the report.

Im up for the challenge :rolleyes

--
Mcastee
-----------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27696