This seems easy, but I'm not seeing it.

How do you retrieve the index of the workbooks collection which applies the
activeworkbook?

I guess one way would be to run through the Workbooks collection looking to
see if workbooks(i).name = activeworkbook.name

Is there a better way?

Thanks.