Thread: vba: How do I write a "For Each Statement" nested in a "With Statement"?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mcasteel[_30_] Mcasteel[_30_] is offline
external usenet poster
  
Posts: 1
Default vba: How do I write a "For Each Statement" nested in a "With Statement"?

Dim strReportDate As String
strReportDate = InputBox("Please Enter Report Date:", "Get Dail
Report:")

Dim dtReportDate As Date
dtReportDate = DateValue(Date:=strReportDate

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

Reply With QuoteReply With Quote