Hi Greg

1) I copy the two formulas you have in row 3 to row 2 so we have a empty row above you data
When you use Ctrl * you see that the correct range is selected

2) your workbook is shared and this is one of the things that not work if you share your workbook

3) you want to filter on a column with empty cells and a X (enter something in the empty cells also)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Send me your test workbook private and I look at it

--
Regards Ron de Bruin
http://www.rondebruin.nl


"GregR" wrote in message oups.com...
Ron, tried both your suggestions, added new row 4 which is empty, got
the error. Removed new row 4 and set range("A4:AC100") and it errored
in the same location.