Is the Value property somehow "special"?
The only way I get the formats to set up is if I loop cell-by-cell.
What am I doing wrong?
--
Gary''s Student - gsnu200832


"Mike H" wrote:

it doesn't work with mixed formats, and I think that's the point GS is making

"JLGWhiz" wrote:

I ran several more tests and could not make it hiccup. The code seems to
work. Must be another problem.

"Stringer" wrote:


I copied your code and set
A1:C1 as Date
A3:C3 as text
Ran the code
A3:C3 became Formatted as date


--
Stringer
------------------------------------------------------------------------
Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60083