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
Bookmarks