| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dispay dates return in cell
Hi Everyone,
I want to display the dates return in the cell O1. But the following code writes "sdate1 to sdate2" in the cell instead of something like 2/19/2009 to 2/20/2009. Can anyone help? Dim sdate1 as Date, sdate2 as Date sdate1 = Me.StartDate sdate2 = Me.EndDate Range("O1").FormulaR1C1 = "sdate1 to sdate2" Thanks, Tracktraining -- Learning |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
dispay dates return in cell
Try this
Range("O1").FormulaR1C1 = sdate1 & " to " & sdate "tracktraining" wrote: Hi Everyone, I want to display the dates return in the cell O1. But the following code writes "sdate1 to sdate2" in the cell instead of something like 2/19/2009 to 2/20/2009. Can anyone help? Dim sdate1 as Date, sdate2 as Date sdate1 = Me.StartDate sdate2 = Me.EndDate Range("O1").FormulaR1C1 = "sdate1 to sdate2" Thanks, Tracktraining -- Learning |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
dispay dates return in cell
thanks! that works
-- Learning "Mike" wrote: Try this Range("O1").FormulaR1C1 = sdate1 & " to " & sdate "tracktraining" wrote: Hi Everyone, I want to display the dates return in the cell O1. But the following code writes "sdate1 to sdate2" in the cell instead of something like 2/19/2009 to 2/20/2009. Can anyone help? Dim sdate1 as Date, sdate2 as Date sdate1 = Me.StartDate sdate2 = Me.EndDate Range("O1").FormulaR1C1 = "sdate1 to sdate2" Thanks, Tracktraining -- Learning |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
dispay dates return in cell
Hi,
I've got no idea where you are populating the variables sdate1 etc but try this Dim sdate1 As Date, sdate2 As Date sdate1 = Me.StartDate sdate2 = Me.EndDate Range("O1").Value = sdate1 & " to " & sdate2 Mike "tracktraining" wrote: Hi Everyone, I want to display the dates return in the cell O1. But the following code writes "sdate1 to sdate2" in the cell instead of something like 2/19/2009 to 2/20/2009. Can anyone help? Dim sdate1 as Date, sdate2 as Date sdate1 = Me.StartDate sdate2 = Me.EndDate Range("O1").FormulaR1C1 = "sdate1 to sdate2" Thanks, Tracktraining -- Learning |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need a function (UDF) return X if 2 dates fall between 2 other dates | Excel Worksheet Functions | |||
| How do I change the cell dispay in Excel 2007 from C1:R2 to A2 | Excel Discussion (Misc queries) | |||
| Dispay two values in one cell with the / border separating them. | Excel Worksheet Functions | |||
| return array result in cell based on comparing dates | Excel Worksheet Functions | |||
| Autofilter with vba wont dispay filtered data | Excel Programming | |||
Hybrid Mode
