Use OLE to apply date format to cells?

Started by mark_in_atx, January 02, 2018, 05:21:00 AM

Previous topic - Next topic

mark_in_atx

When I execute this:

objWB.Worksheets('Worksheet 1').Range('Q12:Q100').NumberFormat="d/m/yyyy"

It applies the number format to the range, not the date format.  How do I apply a date format to a range???

Thanks!

td

Excel stores dates as serial numbers so I am not sure what you are asking.
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade