Wierd error at VBA -> Excel content transfer - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Wierd error at VBA -> Excel content transfer

[b][red]This message was edited by obi_k at 2004-3-5 8:1:25[/red][/b][hr]
I'm writing a macro program for ExcelXP in VBA. I'm working only in one worksheet, whose conents change depending on the status of a pair of radio buttons, so i tried to write a procedure to create the contents of the cells that change (the contents consist of XL formulae). The problem is that when I try to run the program, it gives an error message dialog w/ the 1004 error code: 'Application-defined or user-defined error'. What's up with that? I didn't write any error-handling code! Here's the code for that procedure. Tell me if you see anything wrong with it!

Private Sub Init_XL(Tip As String)
Dim i As Integer
Dim content As String * 20
If Tip = "Factura" Then
For i = 8 To 14
content = "=IF(C" & CStr(i) & "<>0;C" & CStr(i) & "*D" & CStr(i) & ";" & """" & " " & """" & ")"
Main.Cells(i, 5).Value = content
Next i
End If
End Sub

When I step into the program, the 'content' variable takes the value '=IF(C8<>0;C8*D8;" ")' , as it should, but when I assign it to the .value property of the cell, i get the error message. What should I do? 10x.

Sign In or Register to comment.