Try

ActiveCell.NumberFormat = "@"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"willz99ta via OfficeKB.com" <u6624@uwe wrote in message
news:5d338f36895bd@uwe...
Howdy,

I am trying to change the ActiveCell catagory from Number to
Text. Is there
a quick way to do this in VBA?

Thanks,
Will

--
Message posted via http://www.officekb.com