Formula giving Run Time Error

[WxShady13]

I am trying to post the below code into a column of a table so that it will determine if an employee is Valid or Not Valid when it comes to whether or not they accrue vacation. When I paste this formula into a VBA script I get a Run-Time 1004 error. I cannot determine why...The worksheet name is correct and security has been removed.

Worksheets("Lost Time Records").Range("J2:J120").Formula = "=IF(And(I2>1/1/1950,I2<$M$24)""Valid"",""Not Valid"")"

 

[steve the fish]

The formula itself is invalid. There needs to be a comma after the and.

"=IF(And(I2>1/1/1950,I2<$M$24),""Valid"",""Not Valid"")"

 

[WxShady13]

I just made myself type "I will not write VBA code without at least 4 cups of coffee" on the white board :D Thank you so much for catching that!!!! You rock

 

[offthelip]

The trick I use when confronted with this problem is to remove the equals in the VBA so that the VBA writes a text string. Then go to the cell and add the equals sign back in, EXCEL will then kindly tell where the problem is