Simple Question About An Error

[Cfallscat]

So I have this VBA code that is supposed to look through a declared range and add up the values if the cell is equal to a certain value here is the code i have

Please Login or Register  to view this content.

and when i try to run the sub

Please Login or Register  to view this content.

that gets highlighted and i dont understand why?

[Leith Ross]

Hello Cfallscat,

The Cells property returns all cells in the range the property is attached to. Your statement in effect is returning an array. You can not check an entire array's content against a single value.

I suspect you want to check each cell in the range and test if the value is equal to one. If so then this version of your code will do that.

Please Login or Register  to view this content.

[Mordred]

Hi Cfallscat, try the following code

Please Login or Register  to view this content.

[Cfallscat]

Well I was messing around with it and came up with a very similiar code that works the exact same

Please Login or Register  to view this content.

ok now the only problem i have is i want it to not add that cell value but to offset to the next column and add that value?

how would i do that i tried

Please Login or Register  to view this content.