Hey L. Howard,

Thanks for the reply. I will give it a try and let you know how it goes.

In your first example it seems to show that you have created a UDF and make a call to that UDF with the =LastAuthor(). Is this correct?

Also, would I be able to just type =builtindocoumentproperties.lastauthor("Last Author")

in a cell so I would not need any VBA?

I apologize if my previous post is confusing. I was actually looking for two different independent ways to find the information. 1.)using VBA so I can make it part of my macro 2.)Using Excel formula only so I can verify the information through a second source that isn't part of the macro.

Thanks again for your help.

Ty