How to put VBA formula in Excel Sheet

E

EricBB

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
 
J

JE McGimpsey

One way:

Public Sub PutDate()
Range("A1").Formula = "=""Date :"" & TEXT(TODAY(),""dd-mm-yy"")"
End Sub

Note that quotes within the formula string must be doubled.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
VBA Coding Help for Beginner 0
Need Help with a VBA subroutine 0
Date Formats 4
VBA for Dependents shortcut menu 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Word VBA - Delete text from bulleted paragraphs 1
how to check MS Word paragraph line spacing using vba script 1

Top