# Formula with relative columns

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

• 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 what?

Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

• 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

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!