Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object Required | Excel Programming | |||
Object Required | Excel Programming | |||
Object Required | Excel Discussion (Misc queries) | |||
Object required. | Excel Programming |