VBA + Nested If

[328mike]

Hey all,

How can I get this line of code to work?

If Range("Z" & k).Value = "CLOSED" And .Range("AJ" & k).Value - CDate(DataMonth) < 30 And .Range("AJ" & k).Value - CDate(DataMonth) > 0 Then .Range("AJ" & k).Cut Destination:=Sheets("Ready for Submission").Range("F" & k).End(xlUp).Offset(1)

Thanks

 

[CWatts]

Remove the . (periods) before your Range statements.

 

[328mike]

I get a compiler error when I do that.

 

[Ruddles]

You need to show us more than that single statement. Do you have a With statement somewhere before it?

We'd probably need to see the entire macro. How big is it?