Macro that copies values
 

If application.Counta(cells)0 then
activesheet.copy befo=workbooks("Other.xls").Sheets(1)
End If

Bob Umlas
Excel MVP

"Emece" wrote in message
...
I need a Macro to do the following:

Read a worksheet and if the cells contain any value, copy
them into another workbook.

Can't figure it out!

Thanks a million!

Emece.-