Object required
 

Hi! I have a problem with a simple code piece. when trying to run the code
below I get the error: "Object required". Please help me solve this! Thank
you very much!

ratingCell = Range("c9")
pos = 1
i=1
ratingCell.Offset(pos, i) = "test"

Object required
 

When assigning objects to object variables you must use the SET keyword.

Try this:

SET ratingCell = Range("c9")
pos = 1
i=1
ratingCell.Offset(pos, i) = "test"

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Arne Hegefors" wrote:

Hi! I have a problem with a simple code piece. when trying to run the code
below I get the error: "Object required". Please help me solve this! Thank
you very much!

ratingCell = Range("c9")
pos = 1
i=1
ratingCell.Offset(pos, i) = "test"