ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA: For Each... Statement, Expert? (https://www.excelbanter.com/excel-programming/316329-vba-each-statement-expert.html)

Mcasteel[_37_]

VBA: For Each... Statement, Expert?
 

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



All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com