Thread: Need help
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Glenn Glenn is offline
external usenet poster
 
Posts: 8
Default Need help

Two things:

1) Change the name of your subroutine. You're using a reserved name
("cell").
2) Change "For Each Cells..." to "For Each Cell..."


-Glenn Ray



Geir wrote:
HI
I have a problem. This Sub dont work. What can be wrong?


Sub cell()
For Each Cells In Range("A1:K120")
cell.Value = cell.Value
Next
End Sub