Hello,
Some coworkers and I use an excel file to record the projects that we
are working on.
The file is stored in a shared folder and each of us has change access
to it.

My boss asked that I come up with a way to notify everyone through
email when the file has been updated. I would like to use a VB (or
VBA, not sure which is the proper acronym) to look at the bottom most
filled cell (so if A32 was is blank/empty, it will look to A31 and so
on) and email everyone in an MSOutlook distribution list with the
contents of A-whatever as the subject line.

To avoid confusion, though, I would like the procedure to only run
when the file is updated.

Anyhelp would be very appreciated.

At the moment, I can prepare an email (it opens up on screen) but the
file that has the macro within is set as an attachment. I would like
to try and avoid this as too many copies of the file might be
confusing and take up valuable email space.

Thank you in advance for your help,

MarcusIsFunny