"GS" wrote in message
...
Another way...

With Sheets("overview")
.UsedRange.Value = .UsedRange.Value
.Copy 'opens a new wkb with a copy of the sheet
End With

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc



awesome, thanks
that works beautifully
mark