Trying to assign Range.Offset to a variable

[rodsan724]

How do I assign Range.Offset to a variable?

Dim x As Range: x = rng.Offset(0,-1)

x.ClearContents

I'm getting Object required error message

[#2 · Accepted solution]

@rodsan724 

You must use the keyword Set to assign an object:

Set x = rng.Offset(0, -1)

By the way, didn't you want

x.ClearContents

[#3]

Thanks, I fixed in OP