Hello,
I have the following that works in Excel 2003, but not in Excel 2000. I
am trying to apply a number format to an average of a range (called DB)
Dim VF as string, DB as database, DAvg
VF = DB(1,1).numberformat
DBavg = format(application.average(DB),VF)
When the number format is General, the value I get for DBAvg is
"Ge5enral". Why is that happening and how do I get around this?
Thanks.
*** Sent via Developersdex
http://www.developersdex.com ***