"Tom Ogilvy" skrev i melding
...
Or the more flexible:

Worksheets("Pricing").Cells(Rows.Count,"J").End(xl Up).Row

As long as a worksheet will be active. (all worksheets have the same
number
or rows). More flexible because it will work with xl95 and earlier as
well
(which may not be a consideration).

Right, of course, sorry. The 60k limit is spoiling me.

Best wishes Harald
Followup to newsgroup only please