Macro - Insert Date if Cell is Blank

[smmeader]

I have data in rows 2 through 50 (max rows could be variable) of Sheet2. I would like to add a date (located on Sheet1, Cell A2) to column AB if that cell is blank.

For Example:

Sheet1, A2 = 7/25/2012
Sheet2, Rows 2 through 50 have data
Sheet2, Rows 2 through 49 have data in column AB
Sheet2, Row 50 does NOT have data in column AB

I would like to add the date (7/25/2012) to Sheet2, Cell AB50 and change nothing else.

[StevenM]

Backup your data.
Copy code to a standard module.
Run: AddDate2AB

Please Login or Register  to view this content.

P.S. If your last cell in AB is empty, you can change the line:

Please Login or Register  to view this content.

And change "AB" to another column which you know will have data in the last row.