I want to copy the active workbook name to a cell...

[trumb1mj]

I want to copy the active workbook name to a cell... I can display the
activeworkbook using activeworkbook.name how can i display this in a
cell?

 

[Don Guillett]

oh well.

Sub wb()
Range("a1") = ActiveWorkbook.Name
End Sub

 

[trumb1mj]

Thank you.



: