Cells is a reserved word. Try changing it it something like rngCells or
rCells...
--
HTH...

Jim Thomlinson


"Cristian" wrote:

The code:

Function Teste(Cells As Object)

For Each cell In Cells
cell.Value = 11
Next

end function

"Jim Thomlinson" wrote:

Post your code... Also note that A UDF called from a worksheet can not modify
any cell other than the one it is called from... Called from code it can
change whatever it wants, but not if called from a sheet.
--
HTH...

Jim Thomlinson


"Cristian" wrote:

I have a module with a function where I receive a range of cells. Every time
I try to modify the value of this cells I receive an error "out of context".
There are some way to do it ?

Best regards

Cristian