| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Application.Function.Text" doesn't work
Greetings!
Cell E20 contains =NOW() and the format is set to "dd/mm/yyyy hh:mm" which is what I want to use in my VBA Code CopyDate = Range("E20").Value gives Copydate in the format "dd/mm/yyyy hh:mm:ss, but that is not what I want. CopyDate = Application.Function.Text((Range ("E20").Value), "dd/mm/yyyy hh:mm") generates a 438 error - Object doesn't support this property or method How can I overcome this? RClay AT haswell DOT com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Application.Function.Text" doesn't work
Hi Robin
Use Application.WorksheetFunction instead HTH Cordially Pascal "Robin Clay" a écrit dans le message de ... Greetings! Cell E20 contains =NOW() and the format is set to "dd/mm/yyyy hh:mm" which is what I want to use in my VBA Code CopyDate = Range("E20").Value gives Copydate in the format "dd/mm/yyyy hh:mm:ss, but that is not what I want. CopyDate = Application.Function.Text((Range ("E20").Value), "dd/mm/yyyy hh:mm") generates a 438 error - Object doesn't support this property or method How can I overcome this? RClay AT haswell DOT com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Application.Function.Text" doesn't work
On Thu, 8 Jul 2004 03:23:52 -0700, "Robin Clay"
wrote: Greetings! Cell E20 contains =NOW() and the format is set to "dd/mm/yyyy hh:mm" which is what I want to use in my VBA Code CopyDate = Range("E20").Value gives Copydate in the format "dd/mm/yyyy hh:mm:ss, but that is not what I want. CopyDate = Application.Function.Text((Range ("E20").Value), "dd/mm/yyyy hh:mm") generates a 438 error - Object doesn't support this property or method How can I overcome this? RClay AT haswell DOT com Try: copydate = Range("E20").Text --ron |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Application.Function.Text" doesn't work
CopyDate = Format(Range("E20").Value2, "dd/mm/yyyy hh:mm")
-- Regards, Tom Ogilvy "Robin Clay" wrote in message ... Greetings! Cell E20 contains =NOW() and the format is set to "dd/mm/yyyy hh:mm" which is what I want to use in my VBA Code CopyDate = Range("E20").Value gives Copydate in the format "dd/mm/yyyy hh:mm:ss, but that is not what I want. CopyDate = Application.Function.Text((Range ("E20").Value), "dd/mm/yyyy hh:mm") generates a 438 error - Object doesn't support this property or method How can I overcome this? RClay AT haswell DOT com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Need function that will work in Excel 2003 like "Countifs" in 2007 | Excel Worksheet Functions | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
| TEXT(Cell1,"MMMM YYYY") to work in all locale. | Excel Programming | |||
| TEXT(Cell1,"MMMM YYYY") to work in all locale. | Excel Programming | |||
![Robin Clay[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
