| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable Not in the cell
Hi there,
Can anyone help me.... I have a macro which copies a variable to cell. The variable format will always be dd/mm/yyyy However, this information makes its way to the cell but it doesnt see to be the value of the cell.... its almost as if it is text sitting o the cell and not a value. Like for example ="22/09/2008" Any help much appreciated -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable Not in the cell
Dim dt as Date
dt = Cdate("22/09/2008") ActiveCell.Value = dt ActiveCell.Numberformat = "dd/mm/yyyy" -- Regards, Tom Ogilvy "rebel1970 " wrote in message ... Hi there, Can anyone help me.... I have a macro which copies a variable to a cell. The variable format will always be dd/mm/yyyy However, this information makes its way to the cell but it doesnt seem to be the value of the cell.... its almost as if it is text sitting on the cell and not a value. Like for example ="22/09/2008" Any help much appreciated R --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable Not in the cell
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Cell Value | Excel Discussion (Misc queries) | |||
| Adding the same cell in different worksheets. Can that cell be variable? | Excel Worksheet Functions | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| set value of variable from cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
