Is there a way to do this:
I have a form called "List of Proposals Written" that is listed by the Proposal number.

Is there a way to display on another excel spreadsheet, the most current Proposal number?

I know Access you use something like Dmax(ProposalID)+1
What should I do in Excel?

Any help would be greatly appreciated!
Michael

In Excel you can run many worksheet functions in VB by preceeding the function name with 'Application'

Debug.Print Application.Max(Columns("A"))

This will work if you are using a consecutive numeric value for your proposal numbers. If you have an alpha numeric id like prop123, prop124 ... then you will need to evaluate another way for example sort on the id field and check the last entry in the column.