| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find current data with macro
Tnhanks!
i had tried this and it didn't work... now i have understand! i used: Dim y As Date y = Format(Date, "yyyymmdd") but the right one was Dim y As String y = Format(Date, "yyyymmdd") Bye bye Franz Range("A1").Value = Format(Date, "yyyymmdd") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find where is the current file saved | Excel Discussion (Misc queries) | |||
| How can I Run a query from VB macro with out affect current data in the same sheet? | Excel Discussion (Misc queries) | |||
| Macro to find the first cell in a column with different data | Excel Discussion (Misc queries) | |||
| Function to find row with most current date | Excel Worksheet Functions | |||
| I need a macro to find cut and paste data to new cell | Excel Discussion (Misc queries) | |||
Threaded Mode
