I have this code in an excel macro.

[JDU]

I have this code in an excel macro. I keep getting the error "Expected: expression." What's wrong with the syntax?

strDateString = Format(Currentsheet.Cells(1, 1).Value,"mm/dd/yyyy",,)

Thanks

 

[JohnAcc]

Hi There,

You need:

strDateString = Format(ActiveSheet.Cells(1, _ 1).Value, "mm/dd/yyyy&quot

Rgds

John

 

[JohnAcc]

Sorry mis-type !

Ignore the underscore b4 the second 1!

 

[JDU]

Thanks.