object required
 

hi i have the same error but now its at different place

firstly can i use this
shoper.Offset(0, 5) = "Browsing"

if not how to use it.actually im using it to resets the state

Please let me know
Regards

Ram

object required
 

On 28 Aug, 17:08, wrote:
hi i have the same error but now its at different place

firstly can i use this
shoper.Offset(0, 5) = "Browsing"

if not how to use it.actually im using it to resets the state

Please let me know
Regards

Ram

Not sure we have enough information - what is shoper for example?


something like

range("shoper").offset(0,5).value="Browsing"

would be valid for a named range of shoper

object required
 

On Aug 28, 11:12 am, "
wrote:
On 28 Aug, 17:08, wrote:

hi i have the same error but now its at different place

firstly can i use this
shoper.Offset(0, 5) = "Browsing"

if not how to use it.actually im using it to resets the state

Please let me know
Regards

Ram

Not sure we have enough information - what is shoper for example?

something like

range("shoper").offset(0,5).value="Browsing"

would be valid for a named range of shoper

hey i juss got it
thanks for the solution
Regards
Ram

object required
 

What did you get, that you misspelled shopper?

--
Regards,
Tom Ogilvy


" wrote:

On Aug 28, 11:12 am, "
wrote:
On 28 Aug, 17:08, wrote:

hi i have the same error but now its at different place

firstly can i use this
shoper.Offset(0, 5) = "Browsing"

if not how to use it.actually im using it to resets the state

Please let me know
Regards

Ram

Not sure we have enough information - what is shoper for example?

something like

range("shoper").offset(0,5).value="Browsing"

would be valid for a named range of shoper

hey i juss got it
thanks for the solution
Regards
Ram