vba: How do I write a "For Each Statement" nested in a "With Statement"?

M

Mcasteel

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

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

Frank Kabel

Hi
then your statement can't work. you may try something along the lines
'...
Dim cell as range
for each cell in rng
if cell.value=dtReportDate then
'do something
end if
next
'...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba: How do I write a "For Each Statement" nested in a "With Statement"? 0
VBA: For Each.... wont work correctly / is placement wrong? 0
VBA: For Each... Statement, Expert? 1
VBA: Look-Up Cell Date From User Input Box and return ALL matches 1
VBA Export to PDF 0
Word macro that can call cells out of Excel for a find and replace 0
Seach Column and return multiple dates to another worksheet? 0
vba: How do I write a "For Each Statement" nested in a "With Statement"? 1

Top