Do you want a macro?
You don't "need" one.
Simple worksheet function can return filename to a cell.
See Bob Phillips' site for various permutations.
http://www.xldynamic.com/source/xld.xlFAQ0002.html
Gord Dibben MS Excel MVP
On Thu, 11 Jun 2009 16:18:32 -0400, "TR Young"
wrote:
Excel 2003:
I need a macro that grabs the current workbook filename and drops it into
cell A2. I know this is simple, but my head is fried this evening....