Hi,
I wonder if it is possible to assign a macro to a button to add the current date to an empty excel column cell but also have it first update with missing preceding dates to the column before putting in the final current date. For example, on the attached sheet, the last entered date in column "C" is 7/10/20. The macro must first put in the dates from 7/11/20 all the way to the current date today of 7/16/20. Is this possible?
Hi,
One way is a sheet event macro. See example below which uses the Double Click event. Click anywhere in the range of dates in column C. It puts today's date in the last cell and then previous dates in the rows above.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you Richard.
It is not working.
I got a compile error "End if without block if".
Change:Originally Posted by Dbroek
to:PHP Code:With Range("C2:C" & lLastrow - 1) = "=C3-1"
PHP Code:Range("C2:C" & lLastrow - 1) = "=C3-1"
That did it! Thanks tax211 for offering to fix Richard's generous contribution.
Thanks for the correction.
I'd originally coded this section with a With..End With block of code and at the last minute decided against.
I removed the End With but not the With.
Cheers...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks