timestamp

So I am trying to place a static date in a cell if Column A has a number in it and Column C, where the date will go is blank I have been looking for awhile now and cant seem to get anything to work for me here is my code

Please Login or Register  to view this content.

Hi

Your first mistake is in this line:

Please Login or Register  to view this content.

you haven't specified an end row so your macro stops at that point.


This amendment fixes that and inserts your date stamp.

Please Login or Register  to view this content.

This whole thing is a mess. mehmetcik was correct on the first section but later on down it is done correctly

Please Login or Register  to view this content.

However, both spots are flawed. (example: If cell = "" is testing column A for a blank value but you need to be testing it for a number)

This small section is probably the closest to correct (corrections added)

Please Login or Register  to view this content.

Thank you both very much I got it working and made those corrections