What is wrong with this line of code for a cell offset?

Wondering if someone could help me understand what's wrong with this line of code.

Please Login or Register  to view this content.

The problem seems to be the (-109). I want to offset the cell 109 columns to the left. When I run this I get an "Application define or Object defined" error. If I change that -109 to a zero like this...

Please Login or Register  to view this content.

The code works, but it just take the row offset and doesn't offset the column. How do I get it to give me a negative offset?

Thanks.

It depends where c is, ie what are the rows and columns where C is found?

C must be beyond column DE to offset it -109 to take you to column A.

Thanks for the reply. Yeah, I'm working from Cell ED so offsetting 109 to the left is OK.

shg, thanks for the options. The first one was what I was looking for. Worked perfectly. Thanks!

If you are working from column ED, offsetting -109 will take you to column AC.
One of shg's lines should work