Date will not update when macro is run

[JO505]

When I run the macro posted below, everything works fine with the exception of the date. The date copys to the correct page and cell but copys the previous date posted and not the date being copied ie if I try to post todays date it will copy yesterdays date.

Please Login or Register  to view this content.

Jim O

To clairify a bit Cell E10 contains a date and cell G10 contains a number. the number copies fine but the date will not update.

Hope this helps.

Jim O

[rollis13]

What is this script supposed to do ?

Please Login or Register  to view this content.

As it is it overwrites the last date copied ("B" & NR) with the one in the previous above cell ("B" & NR - 1).

[JO505]

That does the trick. I copied the general macro from another sheet and overlooked that.

Thank you for your time with this.

Jim O

[rollis13]

Glad being of some help .