excel 365 VBA "DATE" function

[neilp]

Hi,

I have a spreadsheet that has worked very happily until one user has now upgraded to Office 365.
When he runs a bit of VBA code, it hangs on the line: Cells(1, 27).Value = Date. The word date is highlighted in Blue.

Anyone know why this would happen?

thanks in advance

Neil

 

[neilp]

apologies, solution found here

VBA "Date" not working

I have a workbook with a macro with the below line on it. Sub converttoenquiry() If Range("V2").Value = "" Then Range("V2").Value = Date End Sub This worked fine previously however I have just copied the file to another computer and it doesn't seem to like the "Date" part of it. Why is this...

www.mrexcel.com