Macro to enter todays date in an active cell then delete contents of cell to left

**Ted Dennis** · 09-10-2015, 09:21 AM

I am looking to insert a button with a macro that will insert todays date then delete the contents of the cell to the immediate left of the current selected cell

I have tried

HTML Code:

Which clearly didn't work

Any help would be appreciated

Thanks

Ted

**buran** · 09-10-2015, 09:50 AM

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

Note that ClearContents will leave the comemnts and formatting of the cell intact. You may want to use .Clear instead

Macro to enter todays date in an active cell then delete contents of cell to left

LinkBack

Thread Tools

Rate This Thread

Display

Macro to enter todays date in an active cell then delete contents of cell to left

Re: Macro to enter todays date in an active cell then delete contents of cell to left

Thread Information

Users Browsing this Thread

Similar Threads

Macro to find Date Cells > Current Date and delete everything to left of that cell

Need a macro to add 1 to active cell based on previous cell contents

[SOLVED] Macro Delete Contents in 23rd corresponding cell if the cell in range is a non-blank cell

[SOLVED] Macro to Force Users to Enter Todays Date on a Particular Cell

Delete contents of a cell to the left of text

macro to enter todays date in a specific cell

[SOLVED] Macro to paste in the active cell the contents of a cell from another file??

Bookmarks

Bookmarks

Posting Permissions