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