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
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?
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
Then share it in case it helps someone else with a similar problem.
Don’t have an account yet? Register yourself now and be a part of our community!