Error 1004- In a PC with softwares in German there is no Error

I received one excel sheet with macro that was prepared in a computer in
Germany, when I try to make a seletion there is a message "erro em tempo de
execução 1004 erro de definição de aplicativo ou de objeto"
My computer is with all the softwares in Portuguese.

Part from the macro is :

"Sub rm1411500()
Range("B3").Select
ActiveCell.FormulaR1C1 = "=Z(24)S(2)"
Range("B4").Select
ActiveCell.FormulaR1C1 = "=Z(24)S(2)"
Range("B5").Select
End Sub"

In a computer with the softwares in German language there is no erro message.

Jorge,

This is a guess but I think it well work. It sets the formula to "=$B$24"

Sub rm1411500()
Range("B3").Select
ActiveCell.FormulaR1C1 = "=r24c2"
Range("B4").Select
ActiveCell.FormulaR1C1 = "=r24c2"
Range("B5").Select
End Sub

hth,

Doug

"Jorge Adam" <Jorge [email protected]> wrote in message
news:[email protected]...
> I received one excel sheet with macro that was prepared in a computer in
> Germany, when I try to make a seletion there is a message "erro em tempo
de
> execução 1004 erro de definição de aplicativo ou de objeto"
> My computer is with all the softwares in Portuguese.
>
> Part from the macro is :
>
> "Sub rm1411500()
> Range("B3").Select
> ActiveCell.FormulaR1C1 = "=Z(24)S(2)"
> Range("B4").Select
> ActiveCell.FormulaR1C1 = "=Z(24)S(2)"
> Range("B5").Select
> End Sub"
>
> In a computer with the softwares in German language there is no erro
message.