synthax of Cells.offset.value

**Ramo13541** · 03-14-2016, 02:06 PM

Hi everybody,

I have a few code lines and i don't know what it doesn"t work.

Please Login or Register  to view this content.

the value of strValSUmMonth is for exemple =SUMIF(Z34:AC34;"OK";Z3:AC3)

the bug here is in the last code line.
Any help please ?

**mehmetcik** · 03-14-2016, 02:13 PM

What is J?

**Ramo13541** · 03-14-2016, 02:32 PM

Hi mehmetcik

Please Login or Register  to view this content.

**mehmetcik** · 03-14-2016, 07:54 PM

I think that you you should be using a formula statement.

Please Login or Register  to view this content.

**mehmetcik** · 03-14-2016, 08:32 PM

I think that you you should be using a formula statement.

Please Login or Register  to view this content.

**InvisibleMan** · 03-14-2016, 09:01 PM

Maybe try Dimming i and j as Long, rather than Byte.

Re: synthax of Cells.offset.value