Two rebellious cells refuse to listen to code

[Bagharmin]

I have two cells that my code cannot seem to affect at all. The ONLY bit of code in my entire Sub that does anything with these two cells is below:

Range("B5").Value = Application.WorksheetFunction.Text(Dateone, "##/##/####")
    Range("B6").Value = Application.WorksheetFunction.Text(Datetwo, "##/##/####")

My code refers to nearly all the cells around those two in the same fashion (i.e., Range("B7").Value, Range("D5").Value, etc.) and changes their values in the way I intended, but my code can't touch B5 or B6. I can type in the cells manually and the values will NEVER change when I run the code. The cells aren't locked and the sheet isn't protected. I've even stepped through the code to verify that Dateone and Datetwo have actual valid values (they do), but nothing I do will make those values show in those two cells. Grrr.

I'm at my wit's end. Does anyone have any sort of suggestions or insight on what might be causing this?

 

[ChrisM]

You're not using sheet names in your Range object, any chance you have activated a different sheet and are writing the values to that sheet?

Try some simple troubleshooting by eliminating the .Text function, see if this works:

Range("B5").Value = "Test"

 

[shg]

"##/##/####" is not a valid format. Try, for example, "mm/dd/yyyy"

 

[eblake]

You could also use VBA's Format function rather than Application.WorksheetFunction.Text, not much of a diff but shorter. :D

Range("A10").Value = Format(myDate, "mm/dd/yyyy")

 

[Bagharmin]

Sigh. Thanks, shg. Changing to m/d/yyyy did exactly what I wanted. Of course, now I'm kicking myself for not catching that. I had done pratically everything else, though I hadn't thought about assigning some other, non-date value to those two cells (thanks, ChrisM - I'll remember that next time I have to track down stuff like this).

And thanks, eblake. Shorter is sweeter in code and I'll have to remember your suggestion (assuming I remember not to use "#" in the format).