Just posted an alternative for you ..
-----------
Think you could try copying only the visible rows over to a new sheet
(achieves the same purpose)

Press F5 Special Visible Cells only
Then right click to copy the selection
In a new sheet, right-click on A1 Paste special values

Delete the original sheet (optional)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---