Thread: Cell right next to colored cells is automatically colored on entering a value
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
  
Posts: 493
Default Cell right next to colored cells is automatically colored on entering a value
one way:

Range("A1").NumberFormat = "@"

In article ,
"Johan De Schutter" <jdsATDOTnisusDOTbe wrote:

2) How do I change the formatting of a cel by VBA-code? For example: change
from General to Text
Reply With QuoteReply With Quote