Formula with relative columns

Hi,

I would like to fit this code:

Range("start!b14").Formula = "=sumif(data" & "!$D$2:$O$" & Lrow & ",""<0"")"

to work with relative columns (instead of the fix one here)

Tia

Nati

relative to the number of columns .

In the example the columns are "d" (this column is always the first, so it is fixed for me) to "o", which means from 4 to 15.

But sometimes I'll have the data till column "s" or to "z", and I want the formula to be flexible of course (I know the number of the the last column)

Hope it is clear know

Thx

I found the answer