View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aw aw is offline
external usenet poster
 
Posts: 19
Default From Formula to Value


Can anyone can help how to write the VB code by using of :

For Each & Select Case for the purpose of changing all its formula into
value in selected cells / area.

In addition, it will not get an error message in case of value the cells
with 'text'.

Thx a lot!
--
aw