Record Date of Data Entry Except When Blank

Try adding the below line before your "Set rInt...." line:

Please Login or Register  to view this content.

BSB

Hey BSB, thank you for the reply, I added your line and got a Type Mismatch error.

I've tried to attach demo spreadsheet, but attachments button (next to smiley face) is inop at this time.

You got the type mismatch err when you were entering data into a single cell or when you were clearing multiple cells?

I only get it during the latter.

BSB

To attach a file:

Click on GO ADVANCED and then scroll down to Manage Attachements to open the upload window.

View Pic

Does this work for you?

Please Login or Register  to view this content.

BSB

BSB,
The code does not record the date. I followed your instructions for adding the attachment, thank you. Please take a look. I am using the ENTER button on the sheet to copy and clear.
Thank you for your help thus far. I think we are close.
Ken

Try this:

Please Login or Register  to view this content.

BSB

BSB,

Your code works if data is directly input into Column B, but does not record the date if I use the simple Macro to cut and paste data into Column B from another location. Any ideas?
I appreciate it.

Could we see the code you're using to paste the data in?

BSB

of course. here it is:

Please Login or Register  to view this content.

it is in the demo spreadsheet. i have attached again if that helps.

Thank you