prob with TODAY() within a macro

  • Thread starter Thread starter deepika :excel help
  • Start date Start date
D

deepika :excel help

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table macro filter data between yesterday and today (date+time) 0
Select drop down menu option using libre-calc macro 0
Run Macro If Cell have "x" value 0
How to match the values within Tables? 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Will Macro before a Function like Now() ?? 2
running macro when workbook is openned 3
Today - volatile function 8

Back
Top