Wondering if someone could help me understand what's wrong with this line of code.
Cells(c.Offset(w - 5).Row, c(-109).Column).Resize(, 18).Copy
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...

Cells(c.Offset(w - 5).Row, c(0).Column).Resize(, 18).Copy
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.