Using a variable in .offset

[GaidenFocus]

How would I get this to work? The offset will not always be the same.

Please Login or Register  to view this content.

[Norie]

Work in what way?

The only thing that's missing from the code is that you aren't actually doing anything with Range("A1").Offset(x,0).

[GaidenFocus]

I am trying to do this with it:

Please Login or Register  to view this content.

I have already declared r1 as a range and previously set it to a range("c33"). x is determined by the value of another range variable. It gives me a compile error when i try to do this.

[Norie]

That shouldn't happen, is it definitely a compile error?

Have you declared all your variables inclucing x?

Can you post the rest of the code?

[GaidenFocus]

Hmm...it just worked. No idea what i did wrong. Maybe just a typo. That's what i get for going to bed so late. Sorry for wasting everyone's time!