The -1 should have been deleted for this query.

Thanks Dave

Dave Peterson wrote:

I think I'd use something like:

With worksheets(1)
maxrows = .rows.count
maxcolumns = .columns.count
end with

I'm not sure why you're subtracting one, though.

wrote:

2003/2007

The following works fine except when one is using 2007
in compatibility mode.

Is there a better VBA test than "VBA Application.VERSION = "12.0"
to force MaxRows and MaxColumns to the older limits if one is
in compatibility mode?

If Application.VERSION = "12.0" Then
MaxRows = 1048576 - 1
MaxColumns = 16384 - 1
Else
MaxRows = 65536 - 1
MaxColumns = 256 - 1
End If

TIA