y this today() function is giving me an error when it is run within teh macro?
what should i include



Sub FTPmacro()

Cells(1, 10).value = TODAY() - Weekday(TODAY() + 1, 1) + 7

end sub

Use Date in VBA

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"deepika :excel help" schreef in bericht
...
y this today() function is giving me an error when it is run within teh macro?
what should i include



Sub FTPmacro()

Cells(1, 10).value = TODAY() - Weekday(TODAY() + 1, 1) + 7

end sub

In VBA, use "Date" rather than "Today()"

Regards
Fred

"deepika :excel help" wrote in
message ...
y this today() function is giving me an error when it is run within teh
macro?
what should i include



Sub FTPmacro()

Cells(1, 10).value = TODAY() - Weekday(TODAY() + 1, 1) + 7

end sub