| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to put VBA formula in Excel Sheet
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. In article , EricBB wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I hide the formula in an excel sheet? | Excel Discussion (Misc queries) | |||
| Is there a formula which will print the sheet name in Excel? | Excel Discussion (Misc queries) | |||
| Excel formula for a time sheet | Excel Worksheet Functions | |||
| Can't get a formula to work in each row of an Excel sheet. | Excel Worksheet Functions | |||
| Need help to set-up a formula on Excel work sheet? | New Users to Excel | |||
Threaded Mode
