Add a value to a cell which is referenced using ".cells"

[ianpwilliams]

I'm trying to increase a particular cell's value by another value, and I am referencing the cell using ".cells", because I am using a variable for the column value:

Please Login or Register  to view this content.

But on the first wbk command after the "If volchange > 0" check, I'm getting an "Application Defined or object-defined" error. Any ideas why this might be happening? I tried adding ".Value" to the end of each reference as you can see, but it doesn't work either way.

[Leith Ross]

Hello ianpwilliams,

The addressing order of the Cells method is the opposite of the Range method. With the method, Range you specify an address as Column then Row. With the Cells method, it Row then Column.

Please Login or Register  to view this content.

[ianpwilliams]

It's ok, I put the wrong variable in, It's working now. Thanks!