What do you get if in the Immediate pane you type:and press Enter??">=" & 3.3
>=3.3
or
>=3,3
?
To make my last suggestion work in more locales consider also:
crit1 = Replace(">=" & MinValue, ".", Application.International(xlDecimalSeparator)) crit2 = Replace("<=" & MaxValue, ".", Application.International(xlDecimalSeparator))





Reply With Quote
