View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ryan Poth[_2_] Ryan Poth[_2_] is offline
external usenet poster
 
Posts: 18
Default writing to a cell

Try replacing

..Range("J31").Text (Date)

with

..Range("J31").Value = Date

Regards,
Ryan

-----Original Message-----
I know this HAS to be simple, but I can't find the

command anywhere, driving
me crazy. I'm just trying to write to a cell the current

date. only in
mm/dd/yyyy format. something like this, but it isn't

right:

With curWks
.Range("J31").Clear
.Range("J31").Bold = True
.Range("J31").Text (Date)
End with



.