In the line preceding your .Formula (any syntax), add:
oSheet.Range("H" & (dtEntries.Rows.Count + 2).ToString).NumberFormat = "General"
"May the code that you write never work in ways that you didn't expect; and may the code that you didn't write never require you to maintain it". - Ancient Chinese Proverb
Last edited by Cerian Knight; 07-02-2012 at 12:11 PM.
Reason: Added missing oSheet. to code