• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date Value from one cell

Hi, I was trying to copy date from E6. If I put 3/20/2015 in E6, I want E7 to add just one day, so it will have 3/21/2015. However, I am getting object errors. Can you help me please? Attached is the excel file I made. Thank you.
 

Attachments

  • Book.xlsm
    20.4 KB · Views: 0
Hi,

Change your last line of the code to reflect as:

Range("E7").Value = Range("E6").Value + 1

Regards,
Prasad DN
 
Back
Top