Relative Reference

How do relative reference?
In the first case it works, but when I try to do with relative reference does not work! What's wrong?

1)

Please Login or Register  to view this content.

2)

Please Login or Register  to view this content.

Moderator's Note: As per Forum Rule #3, please use code tags…Thanks.

Try this...

Please Login or Register  to view this content.

...as long as the ActiveCell is not in column A. Cannot offset -1 from column A

thank you!