Rick Rothstein wrote:
MaximumNumberOfRows = ActiveSheet.Rows.Count

Thanks. I can probably use that in most circumstances - the only one I
can think of that would be a problem is in the startup code of an add-
in, where there is no "ActiveSheet", but I don't actually need that,
I'm probably just being awkward by thinking of it.

Phil.