Run-time error '1004': Application-defined or object-defined error

[RileyC]

Code for work, so posting just some of it..
Code that matter for function:

public function compare(...,table As Range)
dim i as integer
i = 1
table.Cells(i,1).value = "Test"
end function

Throwing error "Run-time error '1004': Application-defined or object-defined error"

Any ideas on why this is happening?

 

[Fluff]

How are you calling the function & what are you passing to it?

 

[RileyC]

How are you calling the function & what are you passing to it?

Calling the function from the sheet, and passing in a table that is on the sheet. Looks similar to:

1        2                3                4        5        6        7        8        9           10
Hi       Okay          Yes             No      Maybe So      Just    An      Example ha
Other  Column      Formatted   Similar 
...

 

[Fluff]

Firstly, a UDF is like a formula, in that it cannot modify cells other than the cell that it's in.
Secondly, when you say you are passing it a table, how?

 

[RileyC]

Firstly, a UDF is like a formula, in that it cannot modify cells other than the cell that it's in.
Secondly, when you say you are passing it a table, how?

Alright, is it possible to make something that can modify cells normally? I'm passing in the table like "'Sheet1'!$A$2:$Z$600"

 

[Fluff]

If you want to change cells other than those that contain the function you'll need a macro.

 

[RileyC]

If you want to change cells other than those that contain the function you'll need a macro.

worked in a roundabout way thanks Fluff

 

[Fluff]

Glad you got it sorted & thanks for the feedback