Thread: Writing values to worksheet from array
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
bighead[_7_] bighead[_7_] is offline
external usenet poster
  
Posts: 1
Default Writing values to worksheet from array

MyCell.NumberFormatLocal = "@"
MyCell.Value2 = "10/08/2005"

OR
MyCell.Value="'" & "10/08/2005

--
bighea

-----------------------------------------------------------------------
bighead's Profile: http://www.excelforum.com/member.php...fo&userid=2704
View this thread: http://www.excelforum.com/showthread.php?threadid=46680

Reply With QuoteReply With Quote