View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
 
Posts: 320
Default 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.-