Hi Zubair,

Ctrl-A (Twice in xl2003) to select all cells
Edit | Copy
Edit | PasteSpecial | Values | OK | Esc
Click any cell .


---
Regards,
Norman



"Zubair" wrote in message
...
Hi all,
I have an xls sheet containing formula (sql.request). After running the
macros i get all the values in xls. how can save as this file to reflect
only
the values keeeping the same format like borders colors etc.
thanks in advance.
Zubair