Thread: Object required
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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"