Thread: How to put VBA formula in Excel Sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
EricBB EricBB is offline
external usenet poster
  
Posts: 50
Default How to put VBA formula in Excel Sheet
hi there,
how can i fix the error for this VBA?
Sub PutDate()
Range("A1") = "="Date :" & TEXT(TODAY(),"dd-mm-yy")"
End Sub
pls. help me for this. thanks in advance.
EricBB
Reply With QuoteReply With Quote