Use OLE to apply date format to cells?

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

Previous topic - Next topic
Print
Go Down Pages1
User actions

mark_in_atx

January 02, 2018, 05:21:00 AM
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

#1
January 02, 2018, 06:49:44 AM
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
Print
Go Up Pages1
User actions