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
We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. 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?
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!