Hi All,

I'm kinda new to writing macros. I'm trying to use a convert function in a macro.
Here are examples:
  • Range("E2").Formula = "=CONVERT(D2,"day","hr")" with this I get Compile Error: Expected end of statement
  • Range("E2").Formula = "=CONVERT(D2,'day','hr')" with this I get Run-Time Error '1004': Application-defined or object-defined error

Any ideas? Is it possible for me to use this convert function in a macro?

Thanks